]> granicus.if.org Git - postgresql/log
postgresql
26 years agoDefine prototype for ExecutorLimit() to avoid compiler complaints.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:41:04 +0000 (16:41 +0000)]
Define prototype for ExecutorLimit() to avoid compiler complaints.

26 years agoAdd DTK_DOY to help decode day of year fields.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:39:58 +0000 (16:39 +0000)]
Add DTK_DOY to help decode day of year fields.

26 years agoInclude first text in some type descriptions (~29 entries).
Thomas G. Lockhart [Mon, 17 Nov 1997 16:39:16 +0000 (16:39 +0000)]
Include first text in some type descriptions (~29 entries).

26 years agoUpdate UNION and subselect syntax.
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.

26 years agoUpdate generated source for scan.l.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:33:21 +0000 (16:33 +0000)]
Update generated source for scan.l.

26 years agoImplement SQL92 binary and hexadecimal string decoding (b'10' and x'1F').
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).

26 years agoUse limits.h for INT, SHRT, and SCHAR min and max values rather than
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.

26 years agoUse SHRT_MIN and SHRT_MAX for 2-byte integer limits.
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.

26 years agoAllow fractional values for delta times (e.g. '2.5 days').
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().

26 years agoInclude unistd.h to get read/write function declarations.
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.

26 years agoAdd storage/ipc.h include file to get read/write function declarations.
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.

26 years agoFix compiler complaints about mismatched pointer args using coersions.
Thomas G. Lockhart [Mon, 17 Nov 1997 16:10:06 +0000 (16:10 +0000)]
Fix compiler complaints about mismatched pointer args using coersions.

26 years agoFix for \e on empty file.
Bruce Momjian [Mon, 17 Nov 1997 05:23:11 +0000 (05:23 +0000)]
Fix for \e on empty file.

26 years agoApply Bryan's IPC Patches
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>

26 years agoRe-ordeer new \d command output.
Bruce Momjian [Sun, 16 Nov 1997 05:32:16 +0000 (05:32 +0000)]
Re-ordeer new \d command output.

26 years agoNew \dS psql command. initdb cleanup.
Bruce Momjian [Sun, 16 Nov 1997 04:36:52 +0000 (04:36 +0000)]
New \dS psql command.  initdb cleanup.

26 years agoRemove pg_magic, defaults, server, hosts, and demon tables. unused.
Bruce Momjian [Sat, 15 Nov 1997 20:58:05 +0000 (20:58 +0000)]
Remove pg_magic, defaults, server, hosts, and demon tables.  unused.

26 years agoFix problem of COPY before vacuum.
Bruce Momjian [Sat, 15 Nov 1997 17:15:35 +0000 (17:15 +0000)]
Fix problem of COPY before vacuum.

26 years agoAdd new \df psql option and oid8types() function.
Bruce Momjian [Sat, 15 Nov 1997 16:32:25 +0000 (16:32 +0000)]
Add new \df psql option and oid8types() function.

26 years agoFix testing problem when 'current' equal to 'now' for separate inserts
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.

26 years agoAdd mention of new environment variables for session initialization.
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).

26 years agoMake flowchart file smaller.
Bruce Momjian [Fri, 14 Nov 1997 22:00:32 +0000 (22:00 +0000)]
Make flowchart file smaller.

26 years agoAdd new psql \da, \do, and \dT options.
Bruce Momjian [Fri, 14 Nov 1997 21:38:25 +0000 (21:38 +0000)]
Add new psql \da, \do, and \dT options.

26 years agoSet time zone and date style environment variables.
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.

26 years agoInclude flex output in the standard distribution to fix problems with
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).

26 years agoSupress cleaning scan.c since we will try to include it in the distribution.
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".

26 years agoAdd flag to supress one compiler warning regarding unused "unput" function
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.

26 years agoAdd mention of PGDATESTYLE, PGTZ, PGCOSTHEAP, PGCOSTINDEX, PGRPLANS, PGGEQO
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.

26 years agoAdd other 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)

26 years agoReformat parser table (cosmetic only).
Thomas G. Lockhart [Fri, 14 Nov 1997 15:34:09 +0000 (15:34 +0000)]
Reformat parser table (cosmetic only).

26 years agoFIx for indexing regex stuff. Change rowoid to objoid.
Bruce Momjian [Fri, 14 Nov 1997 06:09:07 +0000 (06:09 +0000)]
FIx for indexing regex stuff.  Change rowoid to objoid.

26 years agoFIx 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.

26 years agopg_description cleanup.
Bruce Momjian [Thu, 13 Nov 1997 03:36:42 +0000 (03:36 +0000)]
pg_description cleanup.

26 years agoAdd pg_description table for info on tables, columns, operators, types, and aggregate...
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

26 years agoFile has moved to include/catalog.
Bruce Momjian [Wed, 12 Nov 1997 03:30:33 +0000 (03:30 +0000)]
File has moved to include/catalog.

27 years agoRemove unnecessary inclusion of <ctype.h>.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:43:26 +0000 (15:43 +0000)]
Remove unnecessary inclusion of <ctype.h>.

27 years agoAdd PGTZ environment variable to initialization code.
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.

27 years agoDo a more complete job of supporting time zone information.
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.

27 years agoChange quickdie elog notice to a single message.
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.

27 years agoChange messages regarding "TimeRange" to say that time travel is no longer
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.

27 years agoClean up path handling esp. when interpreting environment variables.
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.

27 years agoAdd errormsg initialization from patch by Keith Parks.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:15:40 +0000 (15:15 +0000)]
Add errormsg initialization from patch by Keith Parks.

27 years agoClean up handling of environment variables in path names.
Thomas G. Lockhart [Mon, 10 Nov 1997 15:14:34 +0000 (15:14 +0000)]
Clean up handling of environment variables in path names.

27 years agoClean up indenting.
Bruce Momjian [Mon, 10 Nov 1997 05:16:00 +0000 (05:16 +0000)]
Clean up indenting.

27 years agoFix case issues with quotes.
Bruce Momjian [Mon, 10 Nov 1997 05:10:50 +0000 (05:10 +0000)]
Fix case issues with quotes.

27 years agoFrom: "Gillies, Robert" <GilliesR@Nichols.com>
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).

27 years agoPatch from Goran Thyni
Bruce Momjian [Mon, 10 Nov 1997 02:21:18 +0000 (02:21 +0000)]
Patch from Goran Thyni

27 years agoFrom: Bryan Henderson <bryanh@giraffe.netgate.net>
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.

27 years agoFrom: Bryan Henderson <bryanh@giraffe.netgate.net>
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.

27 years agoOops, shouldn't have added that extra, it seems... :)
Marc G. Fournier [Sun, 9 Nov 1997 03:58:20 +0000 (03:58 +0000)]
Oops, shouldn't have added that extra, it seems... :)

27 years agoAdd i586-pc-sco3.2v5.0.2 to .similar file
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>

27 years agonew alpha linux locking from Travis Melhiser <melhiser@viper.co.union.nc.us>
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>

27 years agoUpdate postmaster manual page.
Bruce Momjian [Fri, 7 Nov 1997 21:25:07 +0000 (21:25 +0000)]
Update postmaster manual page.

27 years agoUpdate of Java driver from Peter Mount.
Bruce Momjian [Fri, 7 Nov 1997 21:07:48 +0000 (21:07 +0000)]
Update of Java driver from Peter Mount.

27 years agoAdd Unix domain socket support, from Goran Thyni, goran@bildbasen.se
Bruce Momjian [Fri, 7 Nov 1997 20:52:15 +0000 (20:52 +0000)]
Add Unix domain socket support, from Goran Thyni, goran@bildbasen.se

27 years agoRemove .orig files.
Bruce Momjian [Fri, 7 Nov 1997 20:41:17 +0000 (20:41 +0000)]
Remove .orig files.

27 years agoInclude transam.h to get NullTransactionId defined
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.

27 years agoRoutines for database initial access info and support.
Thomas G. Lockhart [Fri, 7 Nov 1997 07:05:46 +0000 (07:05 +0000)]
Routines for database initial access info and support.

27 years agoAdd database.c 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.

27 years agoImplement CREATE DATABASE/WITH LOCATION=.
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.

27 years agoFile is created by make from source in ../output
Thomas G. Lockhart [Fri, 7 Nov 1997 06:47:41 +0000 (06:47 +0000)]
File is created by make from source in ../output

27 years agoDeclare routines which support SET keyword = value SQL commands.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:45:16 +0000 (06:45 +0000)]
Declare routines which support SET keyword = value SQL commands.

27 years agoEnable SET value = DEFAULT by passing null parameter to parsers.
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.

27 years agoDescribe new command to create alternate database locations.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:40:45 +0000 (06:40 +0000)]
Describe new command to create alternate database locations.

27 years agoSupport alternate database locations.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:38:51 +0000 (06:38 +0000)]
Support alternate database locations.

27 years agoSupport "with location" capability for database creation.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:33:57 +0000 (06:33 +0000)]
Support "with location" capability for database creation.

27 years agoChange error message for rejected input.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:32:05 +0000 (06:32 +0000)]
Change error message for rejected input.

27 years agoChange phrasing of input error message.
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.

27 years agoSupport "delimited identifiers" for \d tablename command.
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.

27 years agoAdd "-D location" to specify alternate database location.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:25:25 +0000 (06:25 +0000)]
Add "-D location" to specify alternate database location.

27 years agoAdd initlocation.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:24:33 +0000 (06:24 +0000)]
Add initlocation.

27 years agoChange "more" to "cat" to allow typeahead while making backend.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:22:36 +0000 (06:22 +0000)]
Change "more" to "cat" to allow typeahead while making backend.

27 years agoCreate alternate location(s) for databases.
Thomas G. Lockhart [Fri, 7 Nov 1997 06:21:39 +0000 (06:21 +0000)]
Create alternate location(s) for databases.

27 years agoUpdate of contrib stuff from massimo.
Bruce Momjian [Wed, 5 Nov 1997 21:38:25 +0000 (21:38 +0000)]
Update of contrib stuff from massimo.

27 years agoRemove NOT_USED for Massimo.
Bruce Momjian [Wed, 5 Nov 1997 21:18:59 +0000 (21:18 +0000)]
Remove NOT_USED for Massimo.

27 years agoRemove duplicate text.
Bruce Momjian [Tue, 4 Nov 1997 11:30:51 +0000 (11:30 +0000)]
Remove duplicate text.

27 years agoRemove time travel from manuals.
Bruce Momjian [Mon, 3 Nov 1997 04:47:08 +0000 (04:47 +0000)]
Remove time travel from manuals.

27 years agoAdd paging for \d, and fix \i.
Bruce Momjian [Mon, 3 Nov 1997 04:21:49 +0000 (04:21 +0000)]
Add paging for \d, and fix \i.

27 years agoPortability fix for pg_passwd.
Bruce Momjian [Sun, 2 Nov 1997 18:15:20 +0000 (18:15 +0000)]
Portability fix for pg_passwd.

27 years agoGood Bye, Time Travel!
Vadim B. Mikheev [Sun, 2 Nov 1997 15:27:14 +0000 (15:27 +0000)]
Good Bye, Time Travel!

27 years agoFix acl error, and remove duplicate pqtrace.
Bruce Momjian [Sat, 1 Nov 1997 05:21:57 +0000 (05:21 +0000)]
Fix acl error, and remove duplicate pqtrace.

27 years agoIndexes for LIKE and ~, !~ operations.
Bruce Momjian [Fri, 31 Oct 1997 00:50:39 +0000 (00:50 +0000)]
Indexes for LIKE and ~, !~ operations.

27 years agoNo more warnings on macros, thanks VAdim.
Bruce Momjian [Thu, 30 Oct 1997 23:37:01 +0000 (23:37 +0000)]
No more warnings on macros, thanks VAdim.

27 years agoRemember release.txt change.
Bruce Momjian [Thu, 30 Oct 1997 22:37:28 +0000 (22:37 +0000)]
Remember release.txt change.

27 years agoUpdate version to 6.3. dump/reload for 6.1 version users.
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.

27 years agoWe have multi-column indexes, so update manual.
Bruce Momjian [Thu, 30 Oct 1997 18:41:03 +0000 (18:41 +0000)]
We have multi-column indexes, so update manual.

27 years agoFIx for SCO compiles.
Bruce Momjian [Thu, 30 Oct 1997 18:31:47 +0000 (18:31 +0000)]
FIx for SCO compiles.

27 years agoFix for java to allow password, european dates,from Peter T Mount
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

27 years agoFIx for libptcl make, from Tatsuo Ishii.
Bruce Momjian [Thu, 30 Oct 1997 17:36:58 +0000 (17:36 +0000)]
FIx for libptcl make, from Tatsuo Ishii.

27 years agoPatch for tcl library crash, from Jan Wieck.
Bruce Momjian [Thu, 30 Oct 1997 17:29:57 +0000 (17:29 +0000)]
Patch for tcl library crash, from Jan Wieck.

27 years agoRemove duplocate lock_timeout value.
Bruce Momjian [Thu, 30 Oct 1997 17:23:59 +0000 (17:23 +0000)]
Remove duplocate lock_timeout value.

27 years agoUpdate for modified quoting style in some error messages.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:53:51 +0000 (16:53 +0000)]
Update for modified quoting style in some error messages.

27 years agoAdd initial backend support for SET/SHOW/RESET TIME ZONE.
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.

27 years agoSupport SQL92 delimited identifiers by checking some attribute names
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.

27 years agoAdd routines istrue() and isfalse() to directly evaluate boolean type.
Thomas G. Lockhart [Thu, 30 Oct 1997 16:45:12 +0000 (16:45 +0000)]
Add routines istrue() and isfalse() to directly evaluate boolean type.

27 years agoAdd support for SQL92 delimited identifiers.
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...

27 years agoAdd support for delimited identifiers. Include new exclusive state "xd".
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.

27 years agoFix up elog messages for consistant usage of quotes around arguments.
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.

27 years agoFix for international identifiers, from Tatsuo Ishii
Bruce Momjian [Thu, 30 Oct 1997 15:28:25 +0000 (15:28 +0000)]
Fix for international identifiers, from Tatsuo Ishii

27 years agoFix for when POSIX time not defined.
Bruce Momjian [Thu, 30 Oct 1997 14:06:47 +0000 (14:06 +0000)]
Fix for when POSIX time not defined.