]> granicus.if.org Git - postgresql/log
postgresql
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.

27 years agoFix for java timestamp type from teunis@sigil.computersupportcentre.com
Bruce Momjian [Thu, 30 Oct 1997 13:55:41 +0000 (13:55 +0000)]
Fix for java timestamp type from teunis@sigil.computersupportcentre.com

27 years agoCREATE PROCEDURAL LANGUAGE mans (Jan).
Vadim B. Mikheev [Thu, 30 Oct 1997 05:38:20 +0000 (05:38 +0000)]
CREATE PROCEDURAL LANGUAGE mans (Jan).

27 years agoIrix LORDER addition.
Bruce Momjian [Thu, 30 Oct 1997 05:36:38 +0000 (05:36 +0000)]
Irix LORDER addition.

27 years agoFix for netbsd locking, from Henry B. Hotz.
Bruce Momjian [Thu, 30 Oct 1997 05:24:19 +0000 (05:24 +0000)]
Fix for netbsd locking, from Henry B. Hotz.

27 years agoFix for compile warning, from Ernst Molitor.
Bruce Momjian [Thu, 30 Oct 1997 05:07:58 +0000 (05:07 +0000)]
Fix for compile warning, from Ernst Molitor.

27 years agoFix for array handling, from Gerhard Hintermayer
Bruce Momjian [Thu, 30 Oct 1997 05:00:56 +0000 (05:00 +0000)]
Fix for array handling, from Gerhard Hintermayer

27 years agoMake configure more automated, from Brook Milligan.
Bruce Momjian [Thu, 30 Oct 1997 04:46:45 +0000 (04:46 +0000)]
Make configure more automated, from Brook Milligan.

27 years agoFix for perl from Brook Milligan
Bruce Momjian [Thu, 30 Oct 1997 04:38:30 +0000 (04:38 +0000)]
Fix for perl from Brook Milligan

27 years agoAdd script to check regression tests.
Bruce Momjian [Thu, 30 Oct 1997 04:27:14 +0000 (04:27 +0000)]
Add script to check regression tests.

27 years agoRename pg_dump -H option to -h.
Bruce Momjian [Thu, 30 Oct 1997 03:59:59 +0000 (03:59 +0000)]
Rename pg_dump -H option to -h.

27 years agoAIX patch from Darren King.
Bruce Momjian [Thu, 30 Oct 1997 03:37:28 +0000 (03:37 +0000)]
AIX patch from Darren King.

27 years agoRemove strcasecmp for univel.
Bruce Momjian [Thu, 30 Oct 1997 03:28:18 +0000 (03:28 +0000)]
Remove strcasecmp for univel.

27 years agoGenerate error on large integer.
Bruce Momjian [Thu, 30 Oct 1997 01:55:49 +0000 (01:55 +0000)]
Generate error on large integer.

27 years agoNew backend_dir html source.
Bruce Momjian [Wed, 29 Oct 1997 23:48:18 +0000 (23:48 +0000)]
New backend_dir html source.

27 years agoAdded support for shlib for BSD44_derived & i386_solaris.
Vadim B. Mikheev [Tue, 28 Oct 1997 15:13:10 +0000 (15:13 +0000)]
Added support for shlib for BSD44_derived & i386_solaris.

27 years agoNow we are able to CREATE PROCEDURAL LANGUAGE (Thanks, Jan).
Vadim B. Mikheev [Tue, 28 Oct 1997 15:11:45 +0000 (15:11 +0000)]
Now we are able to CREATE PROCEDURAL LANGUAGE (Thanks, Jan).

27 years agoRename postgres95 to postgresql.
Bruce Momjian [Tue, 28 Oct 1997 03:20:31 +0000 (03:20 +0000)]
Rename postgres95 to postgresql.

27 years agoNew backend dirs html file.
Bruce Momjian [Mon, 27 Oct 1997 17:53:38 +0000 (17:53 +0000)]
New backend dirs html file.

27 years agoAdd new html development tools, and flow chart.
Bruce Momjian [Mon, 27 Oct 1997 16:59:20 +0000 (16:59 +0000)]
Add new html development tools, and flow chart.

27 years agoc.h:
Vadim B. Mikheev [Mon, 27 Oct 1997 12:07:13 +0000 (12:07 +0000)]
c.h:
#define StrNCpy(dst,src,len)    \
(strncpy((dst),(src),(len)),(len > 0) ? *((dst)+(len)-1)='\0' : \
NULL,(void)(dst))
     ^^^^^^ - to avoid "value computed is not used" from gcc
in ma-a-any places (should to fix thouse places instead, but ...
time)

config.h.in:
/*
 * TBL_FREE_CMD_MEMORY: free memory allocated for an user query inside
 * transaction block after this query is done.
 */
#define TBL_FREE_CMD_MEMORY
- this is default now.

27 years agoFree ascii representations of compared values!
Vadim B. Mikheev [Mon, 27 Oct 1997 12:00:43 +0000 (12:00 +0000)]
Free ascii representations of compared values!

27 years agoUse shared lock when building indices
Vadim B. Mikheev [Mon, 27 Oct 1997 11:52:43 +0000 (11:52 +0000)]
Use shared lock when building indices

27 years agoFix binary cursors broken by MOVE implementation.
Vadim B. Mikheev [Mon, 27 Oct 1997 08:55:16 +0000 (08:55 +0000)]
Fix binary cursors broken by MOVE implementation.
(Thanks to Bruce for finding what caused problem).

27 years agoModify to reflect changes in boolean input behavior (rejects bad input
Thomas G. Lockhart [Sat, 25 Oct 1997 06:03:08 +0000 (06:03 +0000)]
Modify to reflect changes in boolean input behavior (rejects bad input
 rather than assuming FALSE).

27 years agoRemove extraneous row from user_relns table. Don't know where it came from...
Thomas G. Lockhart [Sat, 25 Oct 1997 06:01:21 +0000 (06:01 +0000)]
Remove extraneous row from user_relns table. Don't know where it came from...

27 years agoHave compiler use 486 instruction set. (Should add item in linux FAQ).
Thomas G. Lockhart [Sat, 25 Oct 1997 05:58:56 +0000 (05:58 +0000)]
Have compiler use 486 instruction set. (Should add item in linux FAQ).

27 years agoAdd SQL92 "constants" CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP,
Thomas G. Lockhart [Sat, 25 Oct 1997 05:56:41 +0000 (05:56 +0000)]
Add SQL92 "constants" CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP,
 CURRENT_USER.
Add syntax for primary and foreign keys.
Change optional syntax in CREATE INDEX to avoid parsing conflict with
 TIMESTAMP WITH TIME ZONE data type (use USING <class> rather than WITH...).
Decouple various categories of data type syntax to allow the most possible
 non-ambiguous extensions to SQL92 for column names and labels. This should
 make the parser a bit more understandable, or at least easier to find
 where and how the data types are handled.
Support syntax for IN and EXISTS clauses with subselects.
Support SQL92 syntax for IS TRUE/IS FALSE/IS NOT TRUE/IS NOT FALSE.

27 years agoAdd SQL92 reserved words for primary and foreign keys.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:44:11 +0000 (05:44 +0000)]
Add SQL92 reserved words for primary and foreign keys.
Add keywords for national character types.
Shorted date/time keyword token names for convenience.
Add SQL3 reserved words TRUE and FALSE.

27 years agoAdd conversion routines for int2, int4, and oid to and from text.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:40:43 +0000 (05:40 +0000)]
Add conversion routines for int2, int4, and oid to and from text.
Change a few routine names to ensure <= 16 characters in name
 to fit correctly into pg_proc.

27 years agoChange column number constant to reflect change in column name
Thomas G. Lockhart [Sat, 25 Oct 1997 05:38:52 +0000 (05:38 +0000)]
Change column number constant to reflect change in column name
 from "action" to "ev_action".

27 years agoChange embedded query to reflect column name change from "action"
Thomas G. Lockhart [Sat, 25 Oct 1997 05:37:07 +0000 (05:37 +0000)]
Change embedded query to reflect column name change from "action"
 to "ev_action".

27 years agoRename "TYPE" parser keyword token from P_TYPE to TYPE_P to conform
Thomas G. Lockhart [Sat, 25 Oct 1997 05:34:07 +0000 (05:34 +0000)]
Rename "TYPE" parser keyword token from P_TYPE to TYPE_P to conform
to changes in parser.

27 years agoReassign cash/float4 arithmetic operator oids to avoid duplicate oids.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:31:55 +0000 (05:31 +0000)]
Reassign cash/float4 arithmetic operator oids to avoid duplicate oids.

27 years agoAdd conversion functions for int2, int4, oid to and from text.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:29:48 +0000 (05:29 +0000)]
Add conversion functions for int2, int4, oid to and from text.
Shorten a few routine names to <= 16 characters long to fit in table.

27 years agoRename column to avoid "action" SQL92 reserved word.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:25:10 +0000 (05:25 +0000)]
Rename column to avoid "action" SQL92 reserved word.

27 years agoShorten routine names to <= 16 characters to fit in pg_proc table.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:22:58 +0000 (05:22 +0000)]
Shorten routine names to <= 16 characters to fit in pg_proc table.

27 years agoAdd conversion routines for oid to and from text.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:21:54 +0000 (05:21 +0000)]
Add conversion routines for oid to and from text.

27 years agoClean up comments.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:21:10 +0000 (05:21 +0000)]
Clean up comments.

27 years agoAdd conversions for int2 and int4 to and from text.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:19:22 +0000 (05:19 +0000)]
Add conversions for int2 and int4 to and from text.

27 years agoFix occasional uninitialized variable fractional seconds
Thomas G. Lockhart [Sat, 25 Oct 1997 05:18:17 +0000 (05:18 +0000)]
Fix occasional uninitialized variable fractional seconds
 in DecodeTimeOnly(). Only present when seconds are not specified
 for input.

27 years agoAdd conversion from datetime to time data type.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:16:09 +0000 (05:16 +0000)]
Add conversion from datetime to time data type.
Rename date+time conversion to datetime to ensure less than 16 characters
 in routine name (required to fit in pg_proc table).

27 years agoModify one last line to complete changes for StrNCpy() macro addition.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:12:38 +0000 (05:12 +0000)]
Modify one last line to complete changes for StrNCpy() macro addition.
Before, char16 was missing last character for output.

27 years agoAdd debugging statement enabled by CASHDEBUG symbol definition.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:11:06 +0000 (05:11 +0000)]
Add debugging statement enabled by CASHDEBUG symbol definition.

27 years agoCheck explicitly for valid input strings for both TRUE and FALSE.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:09:58 +0000 (05:09 +0000)]
Check explicitly for valid input strings for both TRUE and FALSE.
Allow true/false, yes/no, 1/0. Throw elog warning if anything else.
Allow shorter strings, so "t", "tr", "tru" and "true" match "true".
Old behavior accepted anything starting with "t" as TRUE,
 everything else as FALSE.

27 years agoInclude explicit SQL update instructions.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:05:06 +0000 (05:05 +0000)]
Include explicit SQL update instructions.
Should have been here in time for 6.2.1 release...

27 years agoStrNCpy cleanup.
Bruce Momjian [Sat, 25 Oct 1997 02:14:22 +0000 (02:14 +0000)]
StrNCpy cleanup.

27 years agoRename strNcpy to StrNCpy, and change third parameter.
Bruce Momjian [Sat, 25 Oct 1997 01:10:58 +0000 (01:10 +0000)]
Rename strNcpy to StrNCpy, and change third parameter.

27 years agoFix alignment of source.
Bruce Momjian [Fri, 24 Oct 1997 15:51:37 +0000 (15:51 +0000)]
Fix alignment of source.

27 years agoDebug stuff added to BlowawayRelationBuffers().
Vadim B. Mikheev [Wed, 22 Oct 1997 19:04:43 +0000 (19:04 +0000)]
Debug stuff added to BlowawayRelationBuffers().

27 years agoFix multi-column index scans in internal pages.
Vadim B. Mikheev [Wed, 22 Oct 1997 19:02:52 +0000 (19:02 +0000)]
Fix multi-column index scans in internal pages.

27 years agoFix \. in manual page.
Bruce Momjian [Wed, 22 Oct 1997 02:08:38 +0000 (02:08 +0000)]
Fix \. in manual page.