]>
granicus.if.org Git - postgresql/log
Thomas G. Lockhart [Tue, 16 Dec 1997 16:01:05 +0000 (16:01 +0000)]
Mention PST8PDT explicitly in the banner message (rather than PST/PDT).
Thomas G. Lockhart [Tue, 16 Dec 1997 15:59:11 +0000 (15:59 +0000)]
Define text, varchar, and bpchar string length functions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:58:14 +0000 (15:58 +0000)]
Use MAXPGPATH to declare size of socket name storage.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:57:00 +0000 (15:57 +0000)]
Use environment variable PGDATESTYLE on backend startup to initialize
date/time formats and conventions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:55:17 +0000 (15:55 +0000)]
Add declarations for text, bpchar, and varchar length functions.
Remove declarations in builtins.h duplicated in dt.h.
Change a few return type declarations to use "type *"
rather than "struct ...".
Thomas G. Lockhart [Tue, 16 Dec 1997 15:53:17 +0000 (15:53 +0000)]
Add declarations for text, bpchar, and varchar length functions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:50:54 +0000 (15:50 +0000)]
Allow multiple-argument functions in constraint clauses.
Formerly allowed only single arguments.
Declare column constraints using the usual list mechanism rather
than explicit itemized lists.
Remove NOTNULL from default clause syntax (retain "NOT NULL").
NOTNULL is not SQL92; eventually remove it from expressions too?
Move ISNULL, NOTNULL to Postgres-specific token declarations.
Fix up tabs and indenting on new CREATE USER commands.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:45:46 +0000 (15:45 +0000)]
Improve (well, ok, fix) generated constraint name for column CHECK clause.
Bruce Momjian [Tue, 16 Dec 1997 05:04:00 +0000 (05:04 +0000)]
Fix order of keywords, must be alphabetical.
Bruce Momjian [Mon, 15 Dec 1997 22:03:59 +0000 (22:03 +0000)]
Fix for user password packet processing, from Goran Thyni.
Bruce Momjian [Fri, 12 Dec 1997 16:26:36 +0000 (16:26 +0000)]
Make password null on startup.
Bruce Momjian [Thu, 11 Dec 1997 17:36:58 +0000 (17:36 +0000)]
Rename pg_plan and pg_eval to be more meaningful.
Bruce Momjian [Thu, 11 Dec 1997 17:03:52 +0000 (17:03 +0000)]
Remove PGDATA setting and use DataDir.
Bruce Momjian [Tue, 9 Dec 1997 20:55:33 +0000 (20:55 +0000)]
Spark/Linux patch for locking, from Tom Szybist
Marc G. Fournier [Tue, 9 Dec 1997 03:11:25 +0000 (03:11 +0000)]
Major code cleanup following the pg_password insertion...
...malloc/free -> palloc/pfree
...fopen/fclose -> AllocateFile/FreeFile
Thomas G. Lockhart [Tue, 9 Dec 1997 01:46:31 +0000 (01:46 +0000)]
Include informational messages added for implicit index creation.
Thomas G. Lockhart [Tue, 9 Dec 1997 01:44:14 +0000 (01:44 +0000)]
Add information message about implicitly created indices.
Check for duplicate implicit index names and generate unique names.
Thomas G. Lockhart [Tue, 9 Dec 1997 01:40:30 +0000 (01:40 +0000)]
Remove trailing period from an elog message.
Most other messages do not have one.
Bruce Momjian [Mon, 8 Dec 1997 04:42:48 +0000 (04:42 +0000)]
More VARHDRSZ additions.
Marc G. Fournier [Sun, 7 Dec 1997 20:57:45 +0000 (20:57 +0000)]
Add error check on getenv("DATADIR")
Add code to set DATADIR in postmaster.c if -D is used
Bruce Momjian [Sat, 6 Dec 1997 22:57:36 +0000 (22:57 +0000)]
Add VARHDRSZ where needed. Many places just used 4.
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.
Thomas G. Lockhart [Fri, 5 Dec 1997 01:14:55 +0000 (01:14 +0000)]
Add test for multi-character char().
Bruce Momjian [Fri, 5 Dec 1997 01:13:24 +0000 (01:13 +0000)]
Fix tolower loops to go in proper direction for cache.
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>
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.
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.
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.
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).
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.
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.
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).
Thomas G. Lockhart [Thu, 4 Dec 1997 23:17:13 +0000 (23:17 +0000)]
Add 'GERMAN' option to DateStyle.
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.
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.
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.
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.
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.
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
Marc G. Fournier [Thu, 4 Dec 1997 00:34:01 +0000 (00:34 +0000)]
Missed a few files from Todd's patch...oops :)
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
Bruce Momjian [Tue, 2 Dec 1997 16:09:15 +0000 (16:09 +0000)]
Fix vacuum analyze syntax problem.
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
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
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.
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>
Bruce Momjian [Mon, 1 Dec 1997 22:02:49 +0000 (22:02 +0000)]
Fix pg_dump, and libpq changes.
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.
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.
Thomas G. Lockhart [Mon, 1 Dec 1997 02:48:47 +0000 (02:48 +0000)]
Add tests for varchar() and combinations of string types.
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.
Thomas G. Lockhart [Mon, 1 Dec 1997 02:44:53 +0000 (02:44 +0000)]
Adjust output to reflect changes in tests.
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.
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!
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.
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).
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.
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.
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.
Bruce Momjian [Sun, 30 Nov 1997 17:46:01 +0000 (17:46 +0000)]
Fix for \dd on types.
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.
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().
Bruce Momjian [Thu, 27 Nov 1997 03:11:55 +0000 (03:11 +0000)]
Salt fix for password, from Tatsuo Ishii.
Bruce Momjian [Thu, 27 Nov 1997 03:01:12 +0000 (03:01 +0000)]
Prevent flushing from packets, by Massimo.
Bruce Momjian [Thu, 27 Nov 1997 02:23:02 +0000 (02:23 +0000)]
Cleaups of comments.
Bruce Momjian [Wed, 26 Nov 1997 15:36:00 +0000 (15:36 +0000)]
Add README for parser directory
Bruce Momjian [Wed, 26 Nov 1997 04:50:47 +0000 (04:50 +0000)]
Re-order args for TypeCreate() to be clearer.
Bruce Momjian [Wed, 26 Nov 1997 04:37:53 +0000 (04:37 +0000)]
Fix from Zeugswetter Andreas DBT for Sendproc.
Bruce Momjian [Wed, 26 Nov 1997 03:54:23 +0000 (03:54 +0000)]
Make parser functions static where possible.
Bruce Momjian [Wed, 26 Nov 1997 03:43:18 +0000 (03:43 +0000)]
Make parser functions static where possible.
Bruce Momjian [Wed, 26 Nov 1997 02:34:28 +0000 (02:34 +0000)]
\dd fix.
Bruce Momjian [Wed, 26 Nov 1997 01:26:13 +0000 (01:26 +0000)]
Cleanup up include files.
Bruce Momjian [Wed, 26 Nov 1997 01:14:33 +0000 (01:14 +0000)]
Cleanup up include files.
Bruce Momjian [Tue, 25 Nov 1997 22:07:18 +0000 (22:07 +0000)]
Break parser functions into smaller files, group together.
Bruce Momjian [Mon, 24 Nov 1997 16:55:22 +0000 (16:55 +0000)]
Remove gram problems with archive.
Bruce Momjian [Mon, 24 Nov 1997 14:15:11 +0000 (14:15 +0000)]
Change heading.
Bruce Momjian [Mon, 24 Nov 1997 14:05:02 +0000 (14:05 +0000)]
Cleanup wrapping in \d commands.
Bruce Momjian [Mon, 24 Nov 1997 13:43:29 +0000 (13:43 +0000)]
Move descriptions to pg_proc, add descriptions.
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.
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.
Bruce Momjian [Mon, 24 Nov 1997 05:09:50 +0000 (05:09 +0000)]
Remove tqual.h includes not needed.
Bruce Momjian [Sun, 23 Nov 1997 21:39:12 +0000 (21:39 +0000)]
Fix for textcat on varchar() fields.
Bruce Momjian [Fri, 21 Nov 1997 19:59:39 +0000 (19:59 +0000)]
Archive cleanups.
Bruce Momjian [Fri, 21 Nov 1997 19:12:41 +0000 (19:12 +0000)]
More archive cleanup.
Bruce Momjian [Fri, 21 Nov 1997 19:02:59 +0000 (19:02 +0000)]
More archive cleanup.
Bruce Momjian [Fri, 21 Nov 1997 18:22:04 +0000 (18:22 +0000)]
Remove unused files.
Bruce Momjian [Fri, 21 Nov 1997 18:12:58 +0000 (18:12 +0000)]
Remove archive stuff.
Bruce Momjian [Fri, 21 Nov 1997 18:04:26 +0000 (18:04 +0000)]
Remove archive stuff.
Bruce Momjian [Thu, 20 Nov 1997 23:24:03 +0000 (23:24 +0000)]
Remove all time travel stuff. Small parser cleanup.
Bruce Momjian [Wed, 19 Nov 1997 18:28:59 +0000 (18:28 +0000)]
Fix socket file permissions, from Goran Thyni.
Bruce Momjian [Wed, 19 Nov 1997 17:57:42 +0000 (17:57 +0000)]
Add to .similar file, Tatsuo Ishii
Bruce Momjian [Wed, 19 Nov 1997 17:52:00 +0000 (17:52 +0000)]
FIx for unix domain sockets, from Goran Thyni.
Vadim B. Mikheev [Wed, 19 Nov 1997 05:28:14 +0000 (05:28 +0000)]
Call ExecEvalExpr with &isDone (not with NULL).
Bruce Momjian [Wed, 19 Nov 1997 03:14:19 +0000 (03:14 +0000)]
Change \df order.
Bruce Momjian [Tue, 18 Nov 1997 23:04:27 +0000 (23:04 +0000)]
Remove stuff that is now in psql \d.
Vadim B. Mikheev [Tue, 18 Nov 1997 07:58:10 +0000 (07:58 +0000)]
Get rid of unused variable 'address'.
Bruce Momjian [Tue, 18 Nov 1997 06:46:31 +0000 (06:46 +0000)]
Make \d commands not wrap over 80 cols.
Bruce Momjian [Tue, 18 Nov 1997 05:22:51 +0000 (05:22 +0000)]
Add descriptions for types and operators.
Bruce Momjian [Mon, 17 Nov 1997 22:15:03 +0000 (22:15 +0000)]
Clean out pgbuiltin now that new psql \d commands exist.
Bruce Momjian [Mon, 17 Nov 1997 17:54:24 +0000 (17:54 +0000)]
Fix \e for empty file.