]>
granicus.if.org Git - postgresql/log
Thomas G. Lockhart [Mon, 17 Nov 1997 16:41:04 +0000 (16:41 +0000)]
Define prototype for ExecutorLimit() to avoid compiler complaints.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:39:58 +0000 (16:39 +0000)]
Add DTK_DOY to help decode day of year fields.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:39:16 +0000 (16:39 +0000)]
Include first text in some type descriptions (~29 entries).
Thomas G. Lockhart [Mon, 17 Nov 1997 16:37:24 +0000 (16:37 +0000)]
Update UNION and subselect syntax.
Support SQL92 syntax for type coersion of strings (type 'typeval').
Example: "DATETIME 'now'". This works only for string constants and can
not replace the CAST and ::type syntax which behave identically in this
context.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:33:21 +0000 (16:33 +0000)]
Update generated source for scan.l.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:31:39 +0000 (16:31 +0000)]
Implement SQL92 binary and hexadecimal string decoding (b'10' and x'1F').
Check decoding of integer in x - y syntax (already done for most ints).
Thomas G. Lockhart [Mon, 17 Nov 1997 16:26:27 +0000 (16:26 +0000)]
Use limits.h for INT, SHRT, and SCHAR min and max values rather than
hardcoded values.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:24:17 +0000 (16:24 +0000)]
Use SHRT_MIN and SHRT_MAX for 2-byte integer limits.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:23:33 +0000 (16:23 +0000)]
Allow fractional values for delta times (e.g. '2.5 days').
Check valid numeric input more carefully for delta times.
Implement day of year as possible input to datetime_part().
Thomas G. Lockhart [Mon, 17 Nov 1997 16:18:07 +0000 (16:18 +0000)]
Include unistd.h to get read/write function declarations.
Remove unused variable addrLen.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:17:14 +0000 (16:17 +0000)]
Add storage/ipc.h include file to get read/write function declarations.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:10:06 +0000 (16:10 +0000)]
Fix compiler complaints about mismatched pointer args using coersions.
Bruce Momjian [Mon, 17 Nov 1997 05:23:11 +0000 (05:23 +0000)]
Fix for \e on empty file.
Marc G. Fournier [Mon, 17 Nov 1997 03:47:31 +0000 (03:47 +0000)]
Apply Bryan's IPC Patches
From: Bryan Henderson <bryanh@giraffe.netgate.net>
Bruce Momjian [Sun, 16 Nov 1997 05:32:16 +0000 (05:32 +0000)]
Re-ordeer new \d command output.
Bruce Momjian [Sun, 16 Nov 1997 04:36:52 +0000 (04:36 +0000)]
New \dS psql command. initdb cleanup.
Bruce Momjian [Sat, 15 Nov 1997 20:58:05 +0000 (20:58 +0000)]
Remove pg_magic, defaults, server, hosts, and demon tables. unused.
Bruce Momjian [Sat, 15 Nov 1997 17:15:35 +0000 (17:15 +0000)]
Fix problem of COPY before vacuum.
Bruce Momjian [Sat, 15 Nov 1997 16:32:25 +0000 (16:32 +0000)]
Add new \df psql option and oid8types() function.
Thomas G. Lockhart [Sat, 15 Nov 1997 02:55:57 +0000 (02:55 +0000)]
Fix testing problem when 'current' equal to 'now' for separate inserts
on fast machines with fast disks.
Adjust a few other tests to be more complete.
Thomas G. Lockhart [Sat, 15 Nov 1997 02:47:23 +0000 (02:47 +0000)]
Add mention of new environment variables for session initialization.
Cross-reference libpq(3).
Bruce Momjian [Fri, 14 Nov 1997 22:00:32 +0000 (22:00 +0000)]
Make flowchart file smaller.
Bruce Momjian [Fri, 14 Nov 1997 21:38:25 +0000 (21:38 +0000)]
Add new psql \da, \do, and \dT options.
Thomas G. Lockhart [Fri, 14 Nov 1997 15:57:12 +0000 (15:57 +0000)]
Set time zone and date style environment variables.
Update banner message regarding time zone.
Thomas G. Lockhart [Fri, 14 Nov 1997 15:50:22 +0000 (15:50 +0000)]
Include flex output in the standard distribution to fix problems with
old AT&T lexers and exclusive states (Solaris has trouble and probably
others).
Thomas G. Lockhart [Fri, 14 Nov 1997 15:48:19 +0000 (15:48 +0000)]
Supress cleaning scan.c since we will try to include it in the distribution.
This should help Solaris and (presumably) other distributions with
old AT&T-descended lex programs which can't handle "exclusive states".
Thomas G. Lockhart [Fri, 14 Nov 1997 15:43:27 +0000 (15:43 +0000)]
Add flag to supress one compiler warning regarding unused "unput" function
in flex-specific code.
Thomas G. Lockhart [Fri, 14 Nov 1997 15:41:30 +0000 (15:41 +0000)]
Add mention of PGDATESTYLE, PGTZ, PGCOSTHEAP, PGCOSTINDEX, PGRPLANS, PGGEQO
as initialization environment variables.
Thomas G. Lockhart [Fri, 14 Nov 1997 15:38:31 +0000 (15:38 +0000)]
Add other initialization environment variables:
PGCOSTHEAP, PGCOSTINDEX, PGRPLANS, PGGEQO
(PGDATESTYLE, PGTZ already defined)
Thomas G. Lockhart [Fri, 14 Nov 1997 15:34:09 +0000 (15:34 +0000)]
Reformat parser table (cosmetic only).
Bruce Momjian [Fri, 14 Nov 1997 06:09:07 +0000 (06:09 +0000)]
FIx for indexing regex stuff. Change rowoid to objoid.
Bruce Momjian [Fri, 14 Nov 1997 05:57:46 +0000 (05:57 +0000)]
FIx for indexing regex stuff. Change rowoid to objoid.
Bruce Momjian [Thu, 13 Nov 1997 03:36:42 +0000 (03:36 +0000)]
pg_description cleanup.
Bruce Momjian [Thu, 13 Nov 1997 03:23:18 +0000 (03:23 +0000)]
Add pg_description table for info on tables, columns, operators, types, and aggregates. Modify psql with new \dd operator to access description
Bruce Momjian [Wed, 12 Nov 1997 03:30:33 +0000 (03:30 +0000)]
File has moved to include/catalog.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:43:26 +0000 (15:43 +0000)]
Remove unnecessary inclusion of <ctype.h>.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:41:58 +0000 (15:41 +0000)]
Add PGTZ environment variable to initialization code.
Rename PG_DATESTYLE to PGDATESTYLE environment variable.
Move environment variable code to a different place so it now works!
Note that regression tests can now run with "setenv PGTZ PST8PDT"
at the frontend rather than requiring the backend to have TZ set.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:37:15 +0000 (15:37 +0000)]
Do a more complete job of supporting time zone information.
Try to save pre-existing TZ environment variable if possible.
Includes code from Keith Parks.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:24:56 +0000 (15:24 +0000)]
Change quickdie elog notice to a single message.
Clean up FloatExceptionHandler elog message source code.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:22:36 +0000 (15:22 +0000)]
Change messages regarding "TimeRange" to say that time travel is no longer
available.
Remove lots of #ifdef'd debugging print statements.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:17:44 +0000 (15:17 +0000)]
Clean up path handling esp. when interpreting environment variables.
Remove unused old code.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:15:40 +0000 (15:15 +0000)]
Add errormsg initialization from patch by Keith Parks.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:14:34 +0000 (15:14 +0000)]
Clean up handling of environment variables in path names.
Bruce Momjian [Mon, 10 Nov 1997 05:16:00 +0000 (05:16 +0000)]
Clean up indenting.
Bruce Momjian [Mon, 10 Nov 1997 05:10:50 +0000 (05:10 +0000)]
Fix case issues with quotes.
Marc G. Fournier [Mon, 10 Nov 1997 03:31:49 +0000 (03:31 +0000)]
From: "Gillies, Robert" <GilliesR@Nichols.com>
Add: Stratus computer (a fault tolerant Unix box running an Intel I960
processor).
Bruce Momjian [Mon, 10 Nov 1997 02:21:18 +0000 (02:21 +0000)]
Patch from Goran Thyni
Marc G. Fournier [Sun, 9 Nov 1997 04:47:09 +0000 (04:47 +0000)]
From: Bryan Henderson <bryanh@giraffe.netgate.net>
My analysis of the formerly mentioned IPC reinitialization problem was
hampered by an imprecise error message. I have rewritten it so it is
clearer and more accurate.
Marc G. Fournier [Sun, 9 Nov 1997 04:43:35 +0000 (04:43 +0000)]
From: Bryan Henderson <bryanh@giraffe.netgate.net>
The attached patch makes elog() write the message to stderr if there is
no frontend to talk to.
Marc G. Fournier [Sun, 9 Nov 1997 03:58:20 +0000 (03:58 +0000)]
Oops, shouldn't have added that extra, it seems... :)
Marc G. Fournier [Sun, 9 Nov 1997 03:45:39 +0000 (03:45 +0000)]
Add i586-pc-sco3.2v5.0.2 to .similar file
Pointed out by: Pieter Huyser <pieter@inetsys.alt.za>
Bruce Momjian [Fri, 7 Nov 1997 21:35:41 +0000 (21:35 +0000)]
new alpha linux locking from Travis Melhiser <melhiser@viper.co.union.nc.us>
Bruce Momjian [Fri, 7 Nov 1997 21:25:07 +0000 (21:25 +0000)]
Update postmaster manual page.
Bruce Momjian [Fri, 7 Nov 1997 21:07:48 +0000 (21:07 +0000)]
Update of Java driver from Peter Mount.
Bruce Momjian [Fri, 7 Nov 1997 20:52:15 +0000 (20:52 +0000)]
Add Unix domain socket support, from Goran Thyni, goran@bildbasen.se
Bruce Momjian [Fri, 7 Nov 1997 20:41:17 +0000 (20:41 +0000)]
Remove .orig files.
Thomas G. Lockhart [Fri, 7 Nov 1997 18:39:38 +0000 (18:39 +0000)]
Include transam.h to get NullTransactionId defined
for use by recently created macros.
Thomas G. Lockhart [Fri, 7 Nov 1997 07:05:46 +0000 (07:05 +0000)]
Routines for database initial access info and support.
Thomas G. Lockhart [Fri, 7 Nov 1997 07:03:37 +0000 (07:03 +0000)]
Add database.c for database initial access info and support.
Thomas G. Lockhart [Fri, 7 Nov 1997 07:02:10 +0000 (07:02 +0000)]
Implement CREATE DATABASE/WITH LOCATION=.
Implement SET keyword = DEFAULT and SET TIME ZONE DEFAULT.
Re-enable JOIN= option in CREATE OPERATOR statement (damaged for v6.2).
Allow more SQL and/or Postgres reserved words as column identifiers
or, if there are shift/reduce problems, at least as column labels.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:47:41 +0000 (06:47 +0000)]
File is created by make from source in ../output
Thomas G. Lockhart [Fri, 7 Nov 1997 06:45:16 +0000 (06:45 +0000)]
Declare routines which support SET keyword = value SQL commands.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:43:16 +0000 (06:43 +0000)]
Enable SET value = DEFAULT by passing null parameter to parsers.
Enable SET TIME ZONE using TZ environment variable.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:40:45 +0000 (06:40 +0000)]
Describe new command to create alternate database locations.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:38:51 +0000 (06:38 +0000)]
Support alternate database locations.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:33:57 +0000 (06:33 +0000)]
Support "with location" capability for database creation.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:32:05 +0000 (06:32 +0000)]
Change error message for rejected input.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:30:20 +0000 (06:30 +0000)]
Change phrasing of input error message.
Add istrue() and isfalse() routines to implement SQL3 IS TRUE and IS FALSE.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:27:55 +0000 (06:27 +0000)]
Support "delimited identifiers" for \d tablename command.
This allows mixed-case identifiers if surrounded by double quotes.
Add mention of "with location" clause for "create database" in help.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:25:25 +0000 (06:25 +0000)]
Add "-D location" to specify alternate database location.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:24:33 +0000 (06:24 +0000)]
Add initlocation.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:22:36 +0000 (06:22 +0000)]
Change "more" to "cat" to allow typeahead while making backend.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:21:39 +0000 (06:21 +0000)]
Create alternate location(s) for databases.
Bruce Momjian [Wed, 5 Nov 1997 21:38:25 +0000 (21:38 +0000)]
Update of contrib stuff from massimo.
Bruce Momjian [Wed, 5 Nov 1997 21:18:59 +0000 (21:18 +0000)]
Remove NOT_USED for Massimo.
Bruce Momjian [Tue, 4 Nov 1997 11:30:51 +0000 (11:30 +0000)]
Remove duplicate text.
Bruce Momjian [Mon, 3 Nov 1997 04:47:08 +0000 (04:47 +0000)]
Remove time travel from manuals.
Bruce Momjian [Mon, 3 Nov 1997 04:21:49 +0000 (04:21 +0000)]
Add paging for \d, and fix \i.
Bruce Momjian [Sun, 2 Nov 1997 18:15:20 +0000 (18:15 +0000)]
Portability fix for pg_passwd.
Vadim B. Mikheev [Sun, 2 Nov 1997 15:27:14 +0000 (15:27 +0000)]
Good Bye, Time Travel!
Bruce Momjian [Sat, 1 Nov 1997 05:21:57 +0000 (05:21 +0000)]
Fix acl error, and remove duplicate pqtrace.
Bruce Momjian [Fri, 31 Oct 1997 00:50:39 +0000 (00:50 +0000)]
Indexes for LIKE and ~, !~ operations.
Bruce Momjian [Thu, 30 Oct 1997 23:37:01 +0000 (23:37 +0000)]
No more warnings on macros, thanks VAdim.
Bruce Momjian [Thu, 30 Oct 1997 22:37:28 +0000 (22:37 +0000)]
Remember release.txt change.
Bruce Momjian [Thu, 30 Oct 1997 22:09:04 +0000 (22:09 +0000)]
Update version to 6.3. dump/reload for 6.1 version users.
Bruce Momjian [Thu, 30 Oct 1997 18:41:03 +0000 (18:41 +0000)]
We have multi-column indexes, so update manual.
Bruce Momjian [Thu, 30 Oct 1997 18:31:47 +0000 (18:31 +0000)]
FIx for SCO compiles.
Bruce Momjian [Thu, 30 Oct 1997 18:24:44 +0000 (18:24 +0000)]
Fix for java to allow password, european dates,from Peter T Mount
Bruce Momjian [Thu, 30 Oct 1997 17:36:58 +0000 (17:36 +0000)]
FIx for libptcl make, from Tatsuo Ishii.
Bruce Momjian [Thu, 30 Oct 1997 17:29:57 +0000 (17:29 +0000)]
Patch for tcl library crash, from Jan Wieck.
Bruce Momjian [Thu, 30 Oct 1997 17:23:59 +0000 (17:23 +0000)]
Remove duplocate lock_timeout value.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:53:51 +0000 (16:53 +0000)]
Update for modified quoting style in some error messages.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:52:11 +0000 (16:52 +0000)]
Add initial backend support for SET/SHOW/RESET TIME ZONE.
Uses TZ environment variable.
Needs additional schemes for brain-dead SQL92 time offsets.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:48:03 +0000 (16:48 +0000)]
Support SQL92 delimited identifiers by checking some attribute names
for mixed-case and surrounding with double quotes.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:45:12 +0000 (16:45 +0000)]
Add routines istrue() and isfalse() to directly evaluate boolean type.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:39:27 +0000 (16:39 +0000)]
Add support for SQL92 delimited identifiers.
Add support for SQL3 IS TRUE and IS FALSE.
Augment support for SQL92 SET TIME ZONE...
Thomas G. Lockhart [Thu, 30 Oct 1997 16:36:39 +0000 (16:36 +0000)]
Add support for delimited identifiers. Include new exclusive state "xd".
Remove unused ScanString variable and code.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:34:22 +0000 (16:34 +0000)]
Fix up elog messages for consistant usage of quotes around arguments.
Bruce Momjian [Thu, 30 Oct 1997 15:28:25 +0000 (15:28 +0000)]
Fix for international identifiers, from Tatsuo Ishii
Bruce Momjian [Thu, 30 Oct 1997 14:06:47 +0000 (14:06 +0000)]
Fix for when POSIX time not defined.