]> granicus.if.org Git - postgresql/log
postgresql
26 years agoAllow logging of output to syslog or /tmp/postgres.log.
Thomas G. Lockhart [Sat, 6 Dec 1997 03:02:34 +0000 (03:02 +0000)]
Allow logging of output to syslog or /tmp/postgres.log.
Put all configurable parameters near top of file.
Remove explicit path to postmaster executable.
More comments.

26 years agoAdd test for multi-character char().
Thomas G. Lockhart [Fri, 5 Dec 1997 01:14:55 +0000 (01:14 +0000)]
Add test for multi-character char().

26 years agoFix tolower loops to go in proper direction for cache.
Bruce Momjian [Fri, 5 Dec 1997 01:13:24 +0000 (01:13 +0000)]
Fix tolower loops to go in  proper direction for cache.

26 years agoI found one other change that I would like to make to the
Marc G. Fournier [Fri, 5 Dec 1997 01:04:25 +0000 (01:04 +0000)]
I found one other change that I would like to make to the
src. It is in the function ParseACL. When I find that I
can not allocate enough memory for the ACL structure I
return an NULL instead of doing an exit_nicely(g_conn);

From: Matthew C Aycock <maycock@scuba.pcpipeline.com>

26 years agoChange constraint syntax to SQL92 style.
Thomas G. Lockhart [Fri, 5 Dec 1997 00:01:22 +0000 (00:01 +0000)]
Change constraint syntax to SQL92 style.
Add tests for PRIMARY KEY and UNIQUE clauses.

26 years agoDefine USE_GERMAN_DATES for use in date/time I/O functions.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:58:01 +0000 (23:58 +0000)]
Define USE_GERMAN_DATES for use in date/time I/O functions.

26 years agoChange Constraint structure to be a full node structure.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:55:52 +0000 (23:55 +0000)]
Change Constraint structure to be a full node structure.
Add new constraint types PRIMARY, UNIQUE.

26 years agoAdd Constraint node type.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:43:59 +0000 (23:43 +0000)]
Add Constraint node type.
Remove TimeRange node type tag (everything else already gone).

26 years agoAdd 'GERMAN' style to date/time output.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:30:52 +0000 (23:30 +0000)]
Add 'GERMAN' style to date/time output.
 Probably have it wrong (dd.mm/yyyy) but can change it when we know.
 Input routines always handled it.

26 years agoRun through toupper() conversion in the forward direction.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:28:20 +0000 (23:28 +0000)]
Run through toupper() conversion in the forward direction.
 Most processors should optimize this a bit better wrt cache prefetch.

26 years agoAdd some printing capability for a few more node types (CreateStmt,
Thomas G. Lockhart [Thu, 4 Dec 1997 23:20:32 +0000 (23:20 +0000)]
Add some printing capability for a few more node types (CreateStmt,
 IndexStmt, IndexElem, ColumnDef).

26 years agoAdd 'GERMAN' option to DateStyle.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:17:13 +0000 (23:17 +0000)]
Add 'GERMAN' option to DateStyle.

26 years agoChange Constraint structure name from ConstraintDef to Constraint.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:15:28 +0000 (23:15 +0000)]
Change Constraint structure name from ConstraintDef to Constraint.
Change reference to field inside to be compatible with new definition
 as a "node" structure rather than a specialty structure.

26 years agoAdd SQL92-compliant syntax for constraints.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:07:23 +0000 (23:07 +0000)]
Add SQL92-compliant syntax for constraints.
Implement PRIMARY KEY and UNIQUE clauses using indices.

26 years agoBackend code redefinitions to allow read/write
Thomas G. Lockhart [Thu, 4 Dec 1997 23:04:08 +0000 (23:04 +0000)]
Backend code redefinitions to allow read/write
 of integer Unix system times.

26 years agoUpdate description for PGHOST and unix domain sockets. Add warning for failed connec...
Bruce Momjian [Thu, 4 Dec 1997 20:32:35 +0000 (20:32 +0000)]
Update description for PGHOST and unix domain sockets.  Add warning for failed connections.

26 years agoUpdate description for PGHOST and unix domain sockets. Add warning for failed connec...
Bruce Momjian [Thu, 4 Dec 1997 20:26:37 +0000 (20:26 +0000)]
Update description for PGHOST and unix domain sockets.  Add warning for failed connections.

26 years agoIncorporate patch from Matt(maycock@intelliquest.com) for dumping ACLs
Marc G. Fournier [Thu, 4 Dec 1997 01:31:28 +0000 (01:31 +0000)]
Incorporate patch from Matt(maycock@intelliquest.com) for dumping ACLs

Clean up formatting of code

Integrate new functions into dumpTable

This is not tested yet...have to recompile server due to patches from
Todd...but this compiles cleanly as it stands now

26 years agoMissed a few files from Todd's patch...oops :)
Marc G. Fournier [Thu, 4 Dec 1997 00:34:01 +0000 (00:34 +0000)]
Missed a few files from Todd's patch...oops :)

26 years agoFrom: todd brandys <brandys@eng3.hep.uiuc.edu>
Marc G. Fournier [Thu, 4 Dec 1997 00:28:15 +0000 (00:28 +0000)]
From: todd brandys <brandys@eng3.hep.uiuc.edu>

An extension to the code to allow for a pg_password authentication database
that is *seperate* from the system password file

26 years agoFix vacuum analyze syntax problem.
Bruce Momjian [Tue, 2 Dec 1997 16:09:15 +0000 (16:09 +0000)]
Fix vacuum analyze syntax problem.

26 years agothe -l option doesn't take a port option, so the man page shouldn't say it
Marc G. Fournier [Tue, 2 Dec 1997 03:43:54 +0000 (03:43 +0000)]
the -l option doesn't take a port option, so the man page shouldn't say it
does

26 years agogmake distclean wasn't removing the configure generated Makefile in
Marc G. Fournier [Tue, 2 Dec 1997 03:19:42 +0000 (03:19 +0000)]
gmake distclean wasn't removing the configure generated Makefile in
pg_version...

...fixed

26 years agoRemove premature code in constraint parsing.
Thomas G. Lockhart [Tue, 2 Dec 1997 02:54:15 +0000 (02:54 +0000)]
Remove premature code in constraint parsing.
Change elog WARN to NOTICE for unimplemented constraints.

26 years agoLinux related change to .similar to handle 'a.out' files...
Marc G. Fournier [Tue, 2 Dec 1997 02:43:08 +0000 (02:43 +0000)]
Linux related change to .similar to handle 'a.out' files...

From: Herb Richter <hgr@buynet.com>

26 years agoFix pg_dump, and libpq changes.
Bruce Momjian [Mon, 1 Dec 1997 22:02:49 +0000 (22:02 +0000)]
Fix pg_dump, and libpq changes.

26 years agoDocument pg_dump -z, clean up option list. Fix problem with libpq handling of field...
Bruce Momjian [Mon, 1 Dec 1997 21:01:24 +0000 (21:01 +0000)]
Document pg_dump -z, clean up option list.  Fix problem with libpq handling of field names uppercase code.

26 years agoDeep-six tests using time travel, which has been removed from Postgres.
Thomas G. Lockhart [Mon, 1 Dec 1997 02:51:07 +0000 (02:51 +0000)]
Deep-six tests using time travel, which has been removed from Postgres.

26 years agoAdd tests for varchar() and combinations of string types.
Thomas G. Lockhart [Mon, 1 Dec 1997 02:48:47 +0000 (02:48 +0000)]
Add tests for varchar() and combinations of string types.

26 years agoAdjust tests to reflect removal of time travel.
Thomas G. Lockhart [Mon, 1 Dec 1997 02:46:13 +0000 (02:46 +0000)]
Adjust tests to reflect removal of time travel.
Add tests for strings and varchar.

26 years agoAdjust output to reflect changes in tests.
Thomas G. Lockhart [Mon, 1 Dec 1997 02:44:53 +0000 (02:44 +0000)]
Adjust output to reflect changes in tests.

26 years agoChange elog WARN messages for UNIQUE and PRIMARY, FOREIGN KEY
Thomas G. Lockhart [Sun, 30 Nov 1997 23:11:10 +0000 (23:11 +0000)]
Change elog WARN messages for UNIQUE and PRIMARY, FOREIGN KEY
 to NOTICE messages so that execution proceeds rather than halting.
 These clauses are ignored as stated in the messages.
Allow NOT NULL UNIQUE syntax (both were allowed individually before).
Allow Postgres-style casting ("::") of non-constants.

26 years agoAdd comments and move a few declaration blocks to help readability.
Thomas G. Lockhart [Sun, 30 Nov 1997 23:05:39 +0000 (23:05 +0000)]
Add comments and move a few declaration blocks to help readability.
 No functional changes this time!

26 years agoSpecify hash table support functions for float8 and int4 rather than using
Thomas G. Lockhart [Sun, 30 Nov 1997 23:03:28 +0000 (23:03 +0000)]
Specify hash table support functions for float8 and int4 rather than using
 btree support functions. Don't know why this was that way, but would
 assume that these should be consistant with all other types with
 hash support. Regression tests OK.
Change a few comments and field alignment to make things more readable.

26 years agoAdd datetime and timespan hash index declarations. Use float8 for both;
Thomas G. Lockhart [Sun, 30 Nov 1997 22:58:07 +0000 (22:58 +0000)]
Add datetime and timespan hash index declarations. Use float8 for both;
 certainly OK for datetime since it is a float8 and should be OK for
 timespan since the first field within timespan is a float8.
Use float8 hash function for time type (rather than char8).

26 years agoRemove duplicate block of declarations. Must have been introduced recently
Thomas G. Lockhart [Sun, 30 Nov 1997 22:52:24 +0000 (22:52 +0000)]
Remove duplicate block of declarations. Must have been introduced recently
 since I've run ./duplicate_oids (and found no problems) in the last
 couple of months.
Add and modify some DESCR() entries to describe functions.

26 years agoChange hash field for a few equality operators so all have it set.
Thomas G. Lockhart [Sun, 30 Nov 1997 22:49:22 +0000 (22:49 +0000)]
Change hash field for a few equality operators so all have it set.
 Don't know why these few were not already this way, and don't know if
  there is some hidden problem with this, but assume it was done
  accidentally as entries were copied from other operators.
 Regression tests are OK, but...
Move one block of declaration source to keep OIDs in increasing order.
 Did not change OID values, just moved source code.

26 years agoAdd pg_type.h to include list to regain declaration of type OID assignments.
Thomas G. Lockhart [Sun, 30 Nov 1997 22:42:58 +0000 (22:42 +0000)]
Add pg_type.h to include list to regain declaration of type OID assignments.
 Lost these when some include files were reorganized.
 Regression test could not compile.

26 years agoFix for \dd on types.
Bruce Momjian [Sun, 30 Nov 1997 17:46:01 +0000 (17:46 +0000)]
Fix for \dd on types.

26 years agoRename heap_destroyr to heap_destroy, heap_destroy to heap_destroy_with_catalog.
Bruce Momjian [Fri, 28 Nov 1997 17:28:02 +0000 (17:28 +0000)]
Rename heap_destroyr to heap_destroy, heap_destroy to heap_destroy_with_catalog.

26 years agoRename heap_create to heap_create_and_catatlog, rename heap_creatr to heap_create().
Bruce Momjian [Fri, 28 Nov 1997 04:40:40 +0000 (04:40 +0000)]
Rename heap_create to heap_create_and_catatlog, rename heap_creatr to heap_create().

26 years agoSalt fix for password, from Tatsuo Ishii.
Bruce Momjian [Thu, 27 Nov 1997 03:11:55 +0000 (03:11 +0000)]
Salt fix for password, from Tatsuo Ishii.

26 years agoPrevent flushing from packets, by Massimo.
Bruce Momjian [Thu, 27 Nov 1997 03:01:12 +0000 (03:01 +0000)]
Prevent flushing from packets, by Massimo.

26 years agoCleaups of comments.
Bruce Momjian [Thu, 27 Nov 1997 02:23:02 +0000 (02:23 +0000)]
Cleaups of comments.

26 years agoAdd README for parser directory
Bruce Momjian [Wed, 26 Nov 1997 15:36:00 +0000 (15:36 +0000)]
Add README for parser directory

26 years agoRe-order args for TypeCreate() to be clearer.
Bruce Momjian [Wed, 26 Nov 1997 04:50:47 +0000 (04:50 +0000)]
Re-order args for TypeCreate() to be clearer.

26 years agoFix from Zeugswetter Andreas DBT for Sendproc.
Bruce Momjian [Wed, 26 Nov 1997 04:37:53 +0000 (04:37 +0000)]
Fix from Zeugswetter Andreas DBT for Sendproc.

26 years agoMake parser functions static where possible.
Bruce Momjian [Wed, 26 Nov 1997 03:54:23 +0000 (03:54 +0000)]
Make parser functions static where possible.

26 years agoMake parser functions static where possible.
Bruce Momjian [Wed, 26 Nov 1997 03:43:18 +0000 (03:43 +0000)]
Make parser functions static where possible.

26 years ago\dd fix.
Bruce Momjian [Wed, 26 Nov 1997 02:34:28 +0000 (02:34 +0000)]
\dd fix.

26 years agoCleanup up include files.
Bruce Momjian [Wed, 26 Nov 1997 01:26:13 +0000 (01:26 +0000)]
Cleanup up include files.

26 years agoCleanup up include files.
Bruce Momjian [Wed, 26 Nov 1997 01:14:33 +0000 (01:14 +0000)]
Cleanup up include files.

26 years agoBreak parser functions into smaller files, group together.
Bruce Momjian [Tue, 25 Nov 1997 22:07:18 +0000 (22:07 +0000)]
Break parser functions into smaller files, group together.

26 years agoRemove gram problems with archive.
Bruce Momjian [Mon, 24 Nov 1997 16:55:22 +0000 (16:55 +0000)]
Remove gram problems with archive.

26 years agoChange heading.
Bruce Momjian [Mon, 24 Nov 1997 14:15:11 +0000 (14:15 +0000)]
Change heading.

26 years agoCleanup wrapping in \d commands.
Bruce Momjian [Mon, 24 Nov 1997 14:05:02 +0000 (14:05 +0000)]
Cleanup wrapping in \d commands.

26 years agoMove descriptions to pg_proc, add descriptions.
Bruce Momjian [Mon, 24 Nov 1997 13:43:29 +0000 (13:43 +0000)]
Move descriptions to pg_proc, add descriptions.

26 years agoMove dbcommands.c to commands/. It should not be in the parser directory.
Bruce Momjian [Mon, 24 Nov 1997 05:32:56 +0000 (05:32 +0000)]
Move dbcommands.c to commands/.  It should not be in the parser directory.

26 years agoMove dbcommands.c to commands/. It should not be in the parser directory.
Bruce Momjian [Mon, 24 Nov 1997 05:21:03 +0000 (05:21 +0000)]
Move dbcommands.c to commands/.  It should not be in the parser directory.

26 years agoRemove tqual.h includes not needed.
Bruce Momjian [Mon, 24 Nov 1997 05:09:50 +0000 (05:09 +0000)]
Remove tqual.h includes not needed.

26 years agoFix for textcat on varchar() fields.
Bruce Momjian [Sun, 23 Nov 1997 21:39:12 +0000 (21:39 +0000)]
Fix for textcat on varchar() fields.

26 years agoArchive cleanups.
Bruce Momjian [Fri, 21 Nov 1997 19:59:39 +0000 (19:59 +0000)]
Archive cleanups.

26 years agoMore archive cleanup.
Bruce Momjian [Fri, 21 Nov 1997 19:12:41 +0000 (19:12 +0000)]
More archive cleanup.

26 years agoMore archive cleanup.
Bruce Momjian [Fri, 21 Nov 1997 19:02:59 +0000 (19:02 +0000)]
More archive cleanup.

26 years agoRemove unused files.
Bruce Momjian [Fri, 21 Nov 1997 18:22:04 +0000 (18:22 +0000)]
Remove unused files.

26 years agoRemove archive stuff.
Bruce Momjian [Fri, 21 Nov 1997 18:12:58 +0000 (18:12 +0000)]
Remove archive stuff.

26 years agoRemove archive stuff.
Bruce Momjian [Fri, 21 Nov 1997 18:04:26 +0000 (18:04 +0000)]
Remove archive stuff.

26 years agoRemove all time travel stuff. Small parser cleanup.
Bruce Momjian [Thu, 20 Nov 1997 23:24:03 +0000 (23:24 +0000)]
Remove all time travel stuff.  Small parser cleanup.

26 years agoFix socket file permissions, from Goran Thyni.
Bruce Momjian [Wed, 19 Nov 1997 18:28:59 +0000 (18:28 +0000)]
Fix socket file permissions, from Goran Thyni.

26 years agoAdd to .similar file, Tatsuo Ishii
Bruce Momjian [Wed, 19 Nov 1997 17:57:42 +0000 (17:57 +0000)]
Add to .similar file, Tatsuo Ishii

26 years agoFIx for unix domain sockets, from Goran Thyni.
Bruce Momjian [Wed, 19 Nov 1997 17:52:00 +0000 (17:52 +0000)]
FIx for unix domain sockets, from Goran Thyni.

26 years agoCall ExecEvalExpr with &isDone (not with NULL).
Vadim B. Mikheev [Wed, 19 Nov 1997 05:28:14 +0000 (05:28 +0000)]
Call ExecEvalExpr with &isDone (not with NULL).

26 years agoChange \df order.
Bruce Momjian [Wed, 19 Nov 1997 03:14:19 +0000 (03:14 +0000)]
Change \df order.

26 years agoRemove stuff that is now in psql \d.
Bruce Momjian [Tue, 18 Nov 1997 23:04:27 +0000 (23:04 +0000)]
Remove stuff that is now in psql \d.

26 years agoGet rid of unused variable 'address'.
Vadim B. Mikheev [Tue, 18 Nov 1997 07:58:10 +0000 (07:58 +0000)]
Get rid of unused variable 'address'.

26 years agoMake \d commands not wrap over 80 cols.
Bruce Momjian [Tue, 18 Nov 1997 06:46:31 +0000 (06:46 +0000)]
Make \d commands not wrap over 80 cols.

26 years agoAdd descriptions for types and operators.
Bruce Momjian [Tue, 18 Nov 1997 05:22:51 +0000 (05:22 +0000)]
Add descriptions for types and operators.

26 years agoClean out pgbuiltin now that new psql \d commands exist.
Bruce Momjian [Mon, 17 Nov 1997 22:15:03 +0000 (22:15 +0000)]
Clean out pgbuiltin now that new psql \d commands exist.

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

26 years agoRemove 16 char limit on system table/index names. Rename system indexes.
Bruce Momjian [Mon, 17 Nov 1997 16:59:36 +0000 (16:59 +0000)]
Remove 16 char limit on system table/index names.  Rename system indexes.

26 years agoUnscramble port selection logic to avoid compiler complaints about
Thomas G. Lockhart [Mon, 17 Nov 1997 16:42:39 +0000 (16:42 +0000)]
Unscramble port selection logic to avoid compiler complaints about
 uninitialized variables. I _think_ the logic is preserved...

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.