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