]>
granicus.if.org Git - postgresql/log
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.
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.
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.
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".
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".
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.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:31:55 +0000 (05:31 +0000)]
Reassign cash/float4 arithmetic operator oids to avoid duplicate oids.
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.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:25:10 +0000 (05:25 +0000)]
Rename column to avoid "action" SQL92 reserved word.
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.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:21:54 +0000 (05:21 +0000)]
Add conversion routines for oid to and from text.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:21:10 +0000 (05:21 +0000)]
Clean up comments.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:19:22 +0000 (05:19 +0000)]
Add conversions for int2 and int4 to and from text.
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.
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).
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.
Thomas G. Lockhart [Sat, 25 Oct 1997 05:11:06 +0000 (05:11 +0000)]
Add debugging statement enabled by CASHDEBUG symbol definition.
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.
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...
Bruce Momjian [Sat, 25 Oct 1997 02:14:22 +0000 (02:14 +0000)]
StrNCpy cleanup.
Bruce Momjian [Sat, 25 Oct 1997 01:10:58 +0000 (01:10 +0000)]
Rename strNcpy to StrNCpy, and change third parameter.
Bruce Momjian [Fri, 24 Oct 1997 15:51:37 +0000 (15:51 +0000)]
Fix alignment of source.
Vadim B. Mikheev [Wed, 22 Oct 1997 19:04:43 +0000 (19:04 +0000)]
Debug stuff added to BlowawayRelationBuffers().
Vadim B. Mikheev [Wed, 22 Oct 1997 19:02:52 +0000 (19:02 +0000)]
Fix multi-column index scans in internal pages.
Bruce Momjian [Wed, 22 Oct 1997 02:08:38 +0000 (02:08 +0000)]
Fix \. in manual page.
Bruce Momjian [Sat, 18 Oct 1997 16:59:06 +0000 (16:59 +0000)]
Update for 6.2.1
Bruce Momjian [Sat, 18 Oct 1997 16:40:53 +0000 (16:40 +0000)]
Update for 6.2.1.
Bruce Momjian [Fri, 17 Oct 1997 14:30:26 +0000 (14:30 +0000)]
Update TODO with html changes.
Bruce Momjian [Fri, 17 Oct 1997 12:21:56 +0000 (12:21 +0000)]
Update TODO to reflect new HISTORY file.
Vadim B. Mikheev [Fri, 17 Oct 1997 11:46:02 +0000 (11:46 +0000)]
Last (?) updations.
Vadim B. Mikheev [Fri, 17 Oct 1997 11:35:33 +0000 (11:35 +0000)]
DEFAULT fixed
Vadim B. Mikheev [Fri, 17 Oct 1997 09:59:09 +0000 (09:59 +0000)]
Changes due to fixed DEFAULT behaviour.
Vadim B. Mikheev [Fri, 17 Oct 1997 09:55:34 +0000 (09:55 +0000)]
Trigger function for inserting user names.
Install compiled functions into $(LIBDIR)/contrib.
(Thanks to Brook Milligan <brook@trillium.NMSU.Edu>)
Thomas G. Lockhart [Fri, 17 Oct 1997 05:38:32 +0000 (05:38 +0000)]
Accept additional values for TRUE: y, Y, 1.
Leave all other input values to return FALSE.
In next version, do more checking for valid inputs for both TRUE and FALSE.
Thomas G. Lockhart [Fri, 17 Oct 1997 05:36:01 +0000 (05:36 +0000)]
Fix delta time decoding for 12 AM/PM.
Thomas G. Lockhart [Fri, 17 Oct 1997 05:34:58 +0000 (05:34 +0000)]
Include recipe for updating pg_aggregate to fix avg(money) function.
Bruce Momjian [Fri, 17 Oct 1997 02:11:49 +0000 (02:11 +0000)]
New function PQcmdTuples.
Bruce Momjian [Thu, 16 Oct 1997 17:32:07 +0000 (17:32 +0000)]
Updates for 6.2.1. Update pgaccess to 0.61. Add to HISTORY.
Vadim B. Mikheev [Thu, 16 Oct 1997 06:59:23 +0000 (06:59 +0000)]
DROP TRIGGER.
Vadim B. Mikheev [Thu, 16 Oct 1997 06:58:38 +0000 (06:58 +0000)]
Ignore copies of columns specified in ORDER/GROUP BY
Bruce Momjian [Thu, 16 Oct 1997 04:14:30 +0000 (04:14 +0000)]
Cleanups for 6.2.1.
Vadim B. Mikheev [Wed, 15 Oct 1997 06:36:36 +0000 (06:36 +0000)]
Fix for backward cursors with ORDER BY.
Thomas G. Lockhart [Wed, 15 Oct 1997 02:34:51 +0000 (02:34 +0000)]
Small updates for v6.2.1.
Thomas G. Lockhart [Wed, 15 Oct 1997 02:32:29 +0000 (02:32 +0000)]
Put in some migration guides. Should have had these for each release.
Thomas G. Lockhart [Wed, 15 Oct 1997 01:12:21 +0000 (01:12 +0000)]
Include SQL/92 string continuation across newlines.
Allows the following example:
select 'first string'
'---'
'last string';
to be output as 'first string---last string'.
Thomas G. Lockhart [Wed, 15 Oct 1997 01:08:25 +0000 (01:08 +0000)]
Fix final function for cash avg() aggregate.
Wrong function referenced in previous versions.
Vadim B. Mikheev [Sun, 12 Oct 1997 07:12:03 +0000 (07:12 +0000)]
Decrement relation reference count incremented in
RelationIdCacheGetRelation() to flush relations from cache
in commit time.
Vadim B. Mikheev [Sun, 12 Oct 1997 07:09:20 +0000 (07:09 +0000)]
DEFAULT is handled by analyze.c now.
Thomas G. Lockhart [Thu, 9 Oct 1997 05:43:59 +0000 (05:43 +0000)]
Use P_TYPE rather than TYPE_P (which will be the name in the next release).
Thomas G. Lockhart [Thu, 9 Oct 1997 05:35:30 +0000 (05:35 +0000)]
Allow both TIME and TYPE as column and table names.
Thomas G. Lockhart [Thu, 9 Oct 1997 05:07:25 +0000 (05:07 +0000)]
Clean up function declarations for the boolean type package
to use bool as the type for arguments and return values.
Thomas G. Lockhart [Thu, 9 Oct 1997 05:06:12 +0000 (05:06 +0000)]
Allow 't', 'T', and even/odd ASCII characters to denote true/false
rather than just 't' and 'T'. This allows yes/no and 1/0
to be interpreted as one might expect.
Clean up function declarations to use bool as the type for arguments
and return values.
Thomas G. Lockhart [Thu, 9 Oct 1997 05:02:17 +0000 (05:02 +0000)]
Support special values 'now', 'current', etc on output.
Thomas G. Lockhart [Thu, 9 Oct 1997 05:00:54 +0000 (05:00 +0000)]
Allow TIME in column and table names (SQL/92 non-reserved word).
Thomas G. Lockhart [Thu, 9 Oct 1997 04:59:37 +0000 (04:59 +0000)]
Fix error in ordering of arguments.
Bruce Momjian [Fri, 3 Oct 1997 23:11:26 +0000 (23:11 +0000)]
Update to version 0.51.
Marc G. Fournier [Fri, 3 Oct 1997 17:31:29 +0000 (17:31 +0000)]
We never do remember to up the PG_VERSION number, do we? :(
Bruce Momjian [Fri, 3 Oct 1997 15:47:17 +0000 (15:47 +0000)]
Update to 0.5.
Bruce Momjian [Fri, 3 Oct 1997 15:38:31 +0000 (15:38 +0000)]
Update machine-specific FAQs. Too late.
Bruce Momjian [Fri, 3 Oct 1997 15:27:18 +0000 (15:27 +0000)]
Linux/alpha patch from Dan Maynard
Thomas G. Lockhart [Fri, 3 Oct 1997 13:10:06 +0000 (13:10 +0000)]
From JM de Lauwereyns (jmlauwer@icdc.caissedesdepots.fr):
lconv is already taken as a struct identifier defined in a /usr/include file.
Only has an effect with USE_LOCALE enabled.
(Apparently unique to AIX and/or AIX compiler? thomas)
Bruce Momjian [Thu, 2 Oct 1997 18:32:58 +0000 (18:32 +0000)]
Sparc lock fix for Linux/netbsd.
Vadim B. Mikheev [Thu, 2 Oct 1997 18:17:56 +0000 (18:17 +0000)]
Updates for release
Vadim B. Mikheev [Thu, 2 Oct 1997 18:03:09 +0000 (18:03 +0000)]
New edition by D'Arcy and me.
Vadim B. Mikheev [Thu, 2 Oct 1997 18:01:57 +0000 (18:01 +0000)]
General function for SERIAL/IDENTITY/AUTOINCREMENT feature.
Handle INSERT event in timetravel().
Vadim B. Mikheev [Thu, 2 Oct 1997 18:00:34 +0000 (18:00 +0000)]
Last changes.
Vadim B. Mikheev [Thu, 2 Oct 1997 13:58:06 +0000 (13:58 +0000)]
+ MOVE
+ CREATE TRIGGER
Little changes for create table.
Vadim B. Mikheev [Thu, 2 Oct 1997 13:57:07 +0000 (13:57 +0000)]
Dump DEFAULT, CHECK, Triggers.
Fix BASETYPE for aggregates with sfunc2 only.
Vadim B. Mikheev [Thu, 2 Oct 1997 13:52:29 +0000 (13:52 +0000)]
Fix \ handling
Vadim B. Mikheev [Thu, 2 Oct 1997 03:15:11 +0000 (03:15 +0000)]
MOVE command
Vadim B. Mikheev [Thu, 2 Oct 1997 02:50:22 +0000 (02:50 +0000)]
A word about constraint nature of DEFAULT.
Marc G. Fournier [Thu, 2 Oct 1997 01:52:25 +0000 (01:52 +0000)]
Space pad it a little bit...improve readability...
Thomas G. Lockhart [Thu, 2 Oct 1997 01:05:16 +0000 (01:05 +0000)]
First attempt at an installation completion message suggesting to keep
in touch with the Web site for updates etc.
Marc G. Fournier [Thu, 2 Oct 1997 00:59:35 +0000 (00:59 +0000)]
Bring in a "registration" file to be printed out after the user has
performed a 'make install'
Uses 'more', which should be standard across all systems, I hope?
Marc G. Fournier [Thu, 2 Oct 1997 00:50:28 +0000 (00:50 +0000)]
Document which is default for:
enable-hba/enable-cassert/enable-locale
Bruce Momjian [Wed, 1 Oct 1997 19:42:53 +0000 (19:42 +0000)]
Update manuals for 6.2 release.
Bruce Momjian [Wed, 1 Oct 1997 19:30:59 +0000 (19:30 +0000)]
Update manuals for 6.2 release.
Bruce Momjian [Wed, 1 Oct 1997 19:24:21 +0000 (19:24 +0000)]
Update manuals for 6.2 release.
Bruce Momjian [Wed, 1 Oct 1997 19:14:35 +0000 (19:14 +0000)]
Update manuals for 6.2 release.
Bruce Momjian [Wed, 1 Oct 1997 19:08:48 +0000 (19:08 +0000)]
Update manuals for 6.2 release.
Bruce Momjian [Wed, 1 Oct 1997 18:57:48 +0000 (18:57 +0000)]
Update manuals for 6.2 release.
Bruce Momjian [Wed, 1 Oct 1997 18:53:28 +0000 (18:53 +0000)]
Update manuals for 6.2 release.
Bruce Momjian [Wed, 1 Oct 1997 18:14:53 +0000 (18:14 +0000)]
Update PQntuples now returns rows affected.
Thomas G. Lockhart [Wed, 1 Oct 1997 17:05:16 +0000 (17:05 +0000)]
Document NOT NULL for table creation.
Clarify usage of date_part() for timespan data type.
Bruce Momjian [Wed, 1 Oct 1997 15:38:59 +0000 (15:38 +0000)]
Update to 0.4.
Bruce Momjian [Wed, 1 Oct 1997 15:13:14 +0000 (15:13 +0000)]
Update to 0.4 version.
Bruce Momjian [Tue, 30 Sep 1997 18:40:37 +0000 (18:40 +0000)]
Fix permits.
Bruce Momjian [Tue, 30 Sep 1997 16:21:42 +0000 (16:21 +0000)]
Add support for NetBSD/sparc.
Bruce Momjian [Tue, 30 Sep 1997 15:19:32 +0000 (15:19 +0000)]
HPUX 10 fix.
Vadim B. Mikheev [Tue, 30 Sep 1997 09:50:28 +0000 (09:50 +0000)]
Little changes.
Vadim B. Mikheev [Tue, 30 Sep 1997 09:49:54 +0000 (09:49 +0000)]
STATEMENT triggers are not implemented - elog (WARN).
Vadim B. Mikheev [Tue, 30 Sep 1997 09:49:10 +0000 (09:49 +0000)]
Trigger programming guide.
Description of data changes visibility added.
Bruce Momjian [Tue, 30 Sep 1997 03:28:02 +0000 (03:28 +0000)]
Cleanup.
Bruce Momjian [Tue, 30 Sep 1997 03:12:43 +0000 (03:12 +0000)]
Vadim's updates to HISTORY file.
Bruce Momjian [Tue, 30 Sep 1997 03:01:39 +0000 (03:01 +0000)]
Update for 6.2 release.
Bruce Momjian [Tue, 30 Sep 1997 02:47:27 +0000 (02:47 +0000)]
Update readme.
Bruce Momjian [Tue, 30 Sep 1997 00:22:43 +0000 (00:22 +0000)]
Update pgtcl to 0.3. Update README.
Marc G. Fournier [Mon, 29 Sep 1997 21:06:48 +0000 (21:06 +0000)]
Update to the newest version before beta12, and add a README file
from Constantin...
Marc G. Fournier [Mon, 29 Sep 1997 20:11:51 +0000 (20:11 +0000)]
From: Peter T Mount <patches@maidast.demon.co.uk>
This patch fixes a few results in DatabaseMetaData, and updates the README
and TODO files (the later being a new file).
The TODO file lists the things that need to be looked into after 6.2 is
released, and describes the problem with Large Objects.
Marc G. Fournier [Mon, 29 Sep 1997 20:06:06 +0000 (20:06 +0000)]
Bring in Constantin's PGaccess TCL interface (v0.21)