]>
granicus.if.org Git - postgresql/log
Vadim B. Mikheev [Mon, 1 Sep 1997 08:09:09 +0000 (08:09 +0000)]
#define TriggerRelationName "pg_trigger"
Vadim B. Mikheev [Mon, 1 Sep 1997 08:06:17 +0000 (08:06 +0000)]
trigger_dynamic()->handle_load() func for loading SPI-triggers
Vadim B. Mikheev [Mon, 1 Sep 1997 08:04:38 +0000 (08:04 +0000)]
Calls of RelationBuildTriggers() & FreeTriggerDesc()
Vadim B. Mikheev [Mon, 1 Sep 1997 08:01:46 +0000 (08:01 +0000)]
BEFORE/AFTER ROW INSERT/DELETE/UPDATE triggers startup.
Vadim B. Mikheev [Mon, 1 Sep 1997 07:59:06 +0000 (07:59 +0000)]
BEFORE/AFTER ROW INSERT triggers startup from CopyFrom()
RelationBuildTriggers() & FreeTriggerDesc() in trigger.c
Thomas G. Lockhart [Mon, 1 Sep 1997 06:21:00 +0000 (06:21 +0000)]
Update information and query results for upcoming v6.2 release.
Thomas G. Lockhart [Mon, 1 Sep 1997 06:19:43 +0000 (06:19 +0000)]
Test new intersection and closest point operators.
Fix up results labels on queries.
Update existing queries which now return good results.
Thomas G. Lockhart [Mon, 1 Sep 1997 06:18:45 +0000 (06:18 +0000)]
Test new intersection and closest point operators.
Fix up results labels on queries.
Thomas G. Lockhart [Mon, 1 Sep 1997 06:16:08 +0000 (06:16 +0000)]
Test for "current" time by comparing against "now".
Thomas G. Lockhart [Mon, 1 Sep 1997 06:13:21 +0000 (06:13 +0000)]
Shift time zone to GMT to correctly evaluate "current" time.
Thomas G. Lockhart [Mon, 1 Sep 1997 06:09:53 +0000 (06:09 +0000)]
Rearrange scanning code to support extended comments.
Use #define symbols rather than integers for scanning states.
Thomas G. Lockhart [Mon, 1 Sep 1997 06:04:59 +0000 (06:04 +0000)]
Add structure for subselects.
Add field to support "WITH TIME ZONE".
Thomas G. Lockhart [Mon, 1 Sep 1997 06:00:35 +0000 (06:00 +0000)]
Add SQL92 string handling features (SUBSTRING, TRIM, EXTRACT).
Add parsing for UNION and outer JOINs.
Implement SQL92 "WITH TIME ZONE".
Allow some reserved words as identifiers and column labels.
Clean up indentation and "orphan spaces and tabs".
Thomas G. Lockhart [Mon, 1 Sep 1997 05:56:34 +0000 (05:56 +0000)]
Add detection and warnings for UNION and HAVING clauses.
Generate non-fatal warning only and proceed by ignoring clauses.
Thomas G. Lockhart [Mon, 1 Sep 1997 05:53:31 +0000 (05:53 +0000)]
Add more reserved words, mostly for SQL92 compliance.
Include reserved words for string handling, outer joins, and unions.
Thomas G. Lockhart [Mon, 1 Sep 1997 05:51:52 +0000 (05:51 +0000)]
Use exclusive states for parsing quoted strings.
Implement extended comments ("/* ... */") using exclusive states.
Modify definitions of operators to remove some restrictions on characters
and character order.
Thomas G. Lockhart [Mon, 1 Sep 1997 05:46:09 +0000 (05:46 +0000)]
Fix return value data type declarations for box_circle() and poly_circle().
Vadim B. Mikheev [Sun, 31 Aug 1997 11:43:09 +0000 (11:43 +0000)]
CREATE/DROP TRIGGER statement nodes
Vadim B. Mikheev [Sun, 31 Aug 1997 11:42:21 +0000 (11:42 +0000)]
CREATE/DROP TRIGGER functions
Vadim B. Mikheev [Sun, 31 Aug 1997 11:41:55 +0000 (11:41 +0000)]
CREATE/DROP TRIGGER
Vadim B. Mikheev [Sun, 31 Aug 1997 11:41:20 +0000 (11:41 +0000)]
Get rid of #include "../backend/parser/parse.h
Vadim B. Mikheev [Sun, 31 Aug 1997 11:40:13 +0000 (11:40 +0000)]
Workplace for CREATE/DROP TRIGGER
Vadim B. Mikheev [Sun, 31 Aug 1997 09:56:18 +0000 (09:56 +0000)]
Indexing of pg_trigger
Vadim B. Mikheev [Sun, 31 Aug 1997 09:55:24 +0000 (09:55 +0000)]
Welcome, triggers
Marc G. Fournier [Sun, 31 Aug 1997 08:15:13 +0000 (08:15 +0000)]
Update patch from Peter <patches@maidast.demon.co.uk>
Vadim B. Mikheev [Sat, 30 Aug 1997 10:28:47 +0000 (10:28 +0000)]
Add spi.o
Bruce Momjian [Fri, 29 Aug 1997 21:41:33 +0000 (21:41 +0000)]
indent flag change.
Bruce Momjian [Fri, 29 Aug 1997 21:20:09 +0000 (21:20 +0000)]
Cleanup.
Bruce Momjian [Fri, 29 Aug 1997 21:13:00 +0000 (21:13 +0000)]
Add PGINDENT and support program.
Vadim B. Mikheev [Fri, 29 Aug 1997 09:12:20 +0000 (09:12 +0000)]
TupleUpdatedByCurXactAndCmd () changed due to
Fix very old bug which made tuples changed/inserted by a commnd
visible to command itself (so we had multiple update of updated tuples,
etc).
Vadim B. Mikheev [Fri, 29 Aug 1997 09:06:27 +0000 (09:06 +0000)]
New results destination for SPI manager.
Vadim B. Mikheev [Fri, 29 Aug 1997 09:05:57 +0000 (09:05 +0000)]
SPI manager.
Vadim B. Mikheev [Fri, 29 Aug 1997 09:05:25 +0000 (09:05 +0000)]
Fix very old bug which made tuples changed/inserted by a commnd
visible to command itself (so we had multiple update of updated tuples,
etc).
Bruce Momjian [Fri, 29 Aug 1997 00:44:55 +0000 (00:44 +0000)]
heap_getattr fix for aix.
Vadim B. Mikheev [Thu, 28 Aug 1997 05:06:29 +0000 (05:06 +0000)]
Fix time_cmp
Vadim B. Mikheev [Thu, 28 Aug 1997 05:05:43 +0000 (05:05 +0000)]
Clean CommandInfo after posting to client.
Vadim B. Mikheev [Thu, 28 Aug 1997 05:02:01 +0000 (05:02 +0000)]
Fix for "default = '...'" in CREATE TYPE
Vadim B. Mikheev [Thu, 28 Aug 1997 04:49:34 +0000 (04:49 +0000)]
Tests for CHECK/DEFAULT
Vadim B. Mikheev [Wed, 27 Aug 1997 09:05:24 +0000 (09:05 +0000)]
Number of tuples inserted/affected by INSERT/UPDATE/DELETE...
Vadim B. Mikheev [Wed, 27 Aug 1997 09:03:47 +0000 (09:03 +0000)]
heap_delete returns int now (for non-functional deletes).
Marc G. Fournier [Wed, 27 Aug 1997 05:06:20 +0000 (05:06 +0000)]
Only need to check for strerror once :)
Bruce Momjian [Wed, 27 Aug 1997 03:48:50 +0000 (03:48 +0000)]
Remove unneeded stat calls.
Bruce Momjian [Tue, 26 Aug 1997 23:31:58 +0000 (23:31 +0000)]
Inlined heap_getattr().
Bruce Momjian [Tue, 26 Aug 1997 19:24:36 +0000 (19:24 +0000)]
Fix for pointer arithmetic.
Bruce Momjian [Tue, 26 Aug 1997 17:39:32 +0000 (17:39 +0000)]
rename sections.
Bruce Momjian [Tue, 26 Aug 1997 17:30:09 +0000 (17:30 +0000)]
unix.1 renamed to pgintro.1.
Bruce Momjian [Tue, 26 Aug 1997 17:00:23 +0000 (17:00 +0000)]
Manual page renaming.
Bruce Momjian [Tue, 26 Aug 1997 14:05:47 +0000 (14:05 +0000)]
Change void * to Dllist*.
Bruce Momjian [Mon, 25 Aug 1997 23:28:04 +0000 (23:28 +0000)]
pg_passwd cleanup.
Bruce Momjian [Mon, 25 Aug 1997 23:11:21 +0000 (23:11 +0000)]
pg_passwd cleanup.
Bruce Momjian [Mon, 25 Aug 1997 20:00:03 +0000 (20:00 +0000)]
pg_passwd cleanup
Bruce Momjian [Mon, 25 Aug 1997 19:41:52 +0000 (19:41 +0000)]
pg_password utility. Cleanup for psql passwords. New datetime contrib stuff for new version. Fix for strutils needing config.h.
Bruce Momjian [Mon, 25 Aug 1997 04:15:40 +0000 (04:15 +0000)]
Small cleanup.
Bruce Momjian [Sun, 24 Aug 1997 23:08:01 +0000 (23:08 +0000)]
Major patch to speed up backend startup after profiling analysis.
Bruce Momjian [Fri, 22 Aug 1997 18:48:25 +0000 (18:48 +0000)]
Update .similar version file.
Bruce Momjian [Fri, 22 Aug 1997 17:15:41 +0000 (17:15 +0000)]
Fix for no NULL in CREATE TABLE.
Bruce Momjian [Fri, 22 Aug 1997 16:48:14 +0000 (16:48 +0000)]
Remove compile warning.
Bruce Momjian [Fri, 22 Aug 1997 16:38:33 +0000 (16:38 +0000)]
Warning in makefile added from DArcy.
Vadim B. Mikheev [Fri, 22 Aug 1997 14:39:33 +0000 (14:39 +0000)]
+ ExecConstraints ()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:33:21 +0000 (14:33 +0000)]
Restore CONSTRAINT keyword (was lost ... by unknown way)
Vadim B. Mikheev [Fri, 22 Aug 1997 14:28:20 +0000 (14:28 +0000)]
+ ExecConstraints()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:22:14 +0000 (14:22 +0000)]
Turn constraints off for sequences & views
elog(WARN,"ADD ATTRIBUTE: DEFAULT is not implemented, yet");
Call ExecConstraints in CopyFrom
Vadim B. Mikheev [Fri, 22 Aug 1997 14:10:26 +0000 (14:10 +0000)]
Remove DEFAULT/CHECK infos from catalog on DROP TABLE
Store CHECK infos on CREATE TABLE
Bruce Momjian [Fri, 22 Aug 1997 07:13:01 +0000 (07:13 +0000)]
We store Cash/money as int of size 4, so make it an int rather than a long.
Bruce Momjian [Fri, 22 Aug 1997 04:13:18 +0000 (04:13 +0000)]
Fix for psql pager when no tty, cleanup for vacuum attdisbursion type.
Vadim B. Mikheev [Fri, 22 Aug 1997 04:05:27 +0000 (04:05 +0000)]
ConstraintDef changed
Vadim B. Mikheev [Fri, 22 Aug 1997 04:04:19 +0000 (04:04 +0000)]
Set attbyval for attdisbursion to FALSE
Set atttype for relchecks to 21 (int2)
Set relkind for pg_attrdef & pg_relcheck to 'n'
Vadim B. Mikheev [Fri, 22 Aug 1997 03:55:39 +0000 (03:55 +0000)]
+ CreateTupleDescCopyConstr
+ FreeTupleDesc
Vadim B. Mikheev [Fri, 22 Aug 1997 03:35:44 +0000 (03:35 +0000)]
Fetch information about DEFAULT/CHECK while openning a relation.
Vadim B. Mikheev [Fri, 22 Aug 1997 03:17:55 +0000 (03:17 +0000)]
There is no NULL constraint in CREATE TABLE - only NOT NULL one.
Vadim B. Mikheev [Fri, 22 Aug 1997 03:12:19 +0000 (03:12 +0000)]
DEFAULT handling
Use for 'selct .. into ..' copy of TupleDesc (without constraints)
#ifdef NOT_USED for resetVarAttrLenForCreateTable (just free tupdesc copy)
Vadim B. Mikheev [Fri, 22 Aug 1997 03:03:56 +0000 (03:03 +0000)]
DefineRelation: DEFAULT/CHECK handling
Vadim B. Mikheev [Fri, 22 Aug 1997 02:58:51 +0000 (02:58 +0000)]
Store attr DEFAULT info in heap_create
Vadim B. Mikheev [Fri, 22 Aug 1997 02:55:39 +0000 (02:55 +0000)]
CreateTupleDescCopy don't copy constraints now!
+ CreateTupleDescCopyConstr to copy them too.
+ FreeTupleDesc
Bruce Momjian [Fri, 22 Aug 1997 00:17:26 +0000 (00:17 +0000)]
Make psql use pager only when it has a tty.
Bruce Momjian [Fri, 22 Aug 1997 00:02:19 +0000 (00:02 +0000)]
Allow functions and operators on internally-identical types to succeed.
Bruce Momjian [Thu, 21 Aug 1997 23:57:00 +0000 (23:57 +0000)]
Change time function names to be more consistent, and check for zero divides, from Michael Reifenberg.
Bruce Momjian [Thu, 21 Aug 1997 14:33:05 +0000 (14:33 +0000)]
Name change cleanup.
Bruce Momjian [Thu, 21 Aug 1997 13:43:46 +0000 (13:43 +0000)]
Remove unused spin function when no spinlocks.
Vadim B. Mikheev [Thu, 21 Aug 1997 04:33:20 +0000 (04:33 +0000)]
#definitions for pg_attrdef & pg_relcheck names
Vadim B. Mikheev [Thu, 21 Aug 1997 04:10:25 +0000 (04:10 +0000)]
AttrConstr --> TupleConstr
Bruce Momjian [Thu, 21 Aug 1997 03:02:13 +0000 (03:02 +0000)]
Rename pg_attribute.attnvals to attdisbursion.
Bruce Momjian [Thu, 21 Aug 1997 02:28:55 +0000 (02:28 +0000)]
Change pg_attribute.attnvals to float4, change #ifdef 0 to #if 0, fix aix call to strNcpy, fix pg_super_user_id in pg_dumpall, change pg_database.dtadba from oid to int4.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:40:30 +0000 (01:40 +0000)]
+ extern double *box_area(BOX *box);
Vadim B. Mikheev [Thu, 21 Aug 1997 01:39:25 +0000 (01:39 +0000)]
+ struct ConstaintDef - for constraints.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:37:55 +0000 (01:37 +0000)]
New system relations to store DEFAULT/CHECK expressions.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:36:09 +0000 (01:36 +0000)]
Read info for DEFAULT from pg_attrdef.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:34:44 +0000 (01:34 +0000)]
Syntax for [CONSTRAINT name] CHECK ...
Vadim B. Mikheev [Thu, 21 Aug 1997 01:32:19 +0000 (01:32 +0000)]
Get rid of attproc, atttyparg, attcanindex, attdefrel, attbound
from pg_attribute. atthasdef added.
Bruce Momjian [Wed, 20 Aug 1997 15:06:48 +0000 (15:06 +0000)]
Portability fix for pg_dumpall.
Bruce Momjian [Wed, 20 Aug 1997 14:54:35 +0000 (14:54 +0000)]
More NOT_USEDs
Bruce Momjian [Wed, 20 Aug 1997 02:10:47 +0000 (02:10 +0000)]
Add static finding script.
Vadim B. Mikheev [Wed, 20 Aug 1997 02:01:42 +0000 (02:01 +0000)]
HTNegate/HTCommute/HTNegateCommute are not used.
Vadim B. Mikheev [Wed, 20 Aug 1997 01:50:06 +0000 (01:50 +0000)]
CHECK/DEFAULT syntax (some tricks to get current scan position).
Vadim B. Mikheev [Wed, 20 Aug 1997 01:12:38 +0000 (01:12 +0000)]
CHECK/DEFAULT syntax
Marc G. Fournier [Wed, 20 Aug 1997 00:50:11 +0000 (00:50 +0000)]
Changes for Digital Unix
Bruce Momjian [Tue, 19 Aug 1997 21:47:07 +0000 (21:47 +0000)]
Fix for sunos4 difftime() call.
Bruce Momjian [Tue, 19 Aug 1997 21:40:56 +0000 (21:40 +0000)]
Make functions static where possible, enclose unused functions in #ifdef NOT_USED.
Vadim B. Mikheev [Tue, 19 Aug 1997 04:46:15 +0000 (04:46 +0000)]
NOT NULL implementation (submitted by Robson Paniago de Miranda).
Bruce Momjian [Mon, 18 Aug 1997 20:53:48 +0000 (20:53 +0000)]
Now that names are null terminated, no need to do all that NAMEDATALEN stuff.