diff options
| author | Marc G. Fournier <scrappy@hub.org> | 1996-11-13 20:56:15 +0000 |
|---|---|---|
| committer | Marc G. Fournier <scrappy@hub.org> | 1996-11-13 20:56:15 +0000 |
| commit | 07a65b22554d54455de5bc791a48fb0542f48791 (patch) | |
| tree | 8320f9bb483ac60e34af929036a1a5a36c19d827 /src/backend/commands | |
| parent | 0cec8fe26c4c76bcc72b78c194a1aa026748c6dc (diff) | |
| download | postgresql-07a65b22554d54455de5bc791a48fb0542f48791.tar.gz postgresql-07a65b22554d54455de5bc791a48fb0542f48791.zip | |
Commit of a *MAJOR* patch from Dan McGuirk <djm@indirect.com>
Changes:
* Unique index capability works using the syntax 'create unique
index'.
* Duplicate OID's in the system tables are removed. I put
little scripts called 'duplicate_oids' and 'find_oid' in
include/catalog that help to find and remove duplicate OID's.
I also moved 'unused_oids' from backend/catalog to
include/catalog, since it has to be in the same directory
as the include files in order to work.
* The backend tries converting the name of a function or aggregate
to all lowercase if the original name given doesn't work (mostly
for compatibility with ODBC).
* You can 'SELECT NULL' to your heart's content.
* I put my _bt_updateitem fix in instead, which uses
_bt_insertonpg so that even if the new key is so big that
the page has to be split, everything still works.
* All literal references to system catalog OID's have been
replaced with references to define'd constants from the catalog
header files.
* I added a couple of node copy functions. I think this was a
preliminary attempt to get rules to work.
Diffstat (limited to 'src/backend/commands')
| -rw-r--r-- | src/backend/commands/cluster.c | 6 | ||||
| -rw-r--r-- | src/backend/commands/copy.c | 4 | ||||
| -rw-r--r-- | src/backend/commands/defind.c | 7 |
3 files changed, 10 insertions, 7 deletions
diff --git a/src/backend/commands/cluster.c b/src/backend/commands/cluster.c index 4d82e2c8645..3e8dcd549d2 100644 --- a/src/backend/commands/cluster.c +++ b/src/backend/commands/cluster.c @@ -14,7 +14,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/cluster.c,v 1.8 1996/11/06 08:21:29 scrappy Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/cluster.c,v 1.9 1996/11/13 20:48:12 scrappy Exp $ * *------------------------------------------------------------------------- */ @@ -298,7 +298,9 @@ copy_index(Oid OIDOldIndex, Oid OIDNewHeap) natts, Old_pg_index_Form->indkey, Old_pg_index_Form->indclass, - (uint16)0, (Datum) NULL, NULL, Old_pg_index_Form->indislossy); + (uint16)0, (Datum) NULL, NULL, + Old_pg_index_Form->indislossy, + Old_pg_index_Form->indisunique); heap_close(OldIndex); heap_close(NewHeap); diff --git a/src/backend/commands/copy.c b/src/backend/commands/copy.c index 258376ee8ba..6777455be9f 100644 --- a/src/backend/commands/copy.c +++ b/src/backend/commands/copy.c @@ -6,7 +6,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.16 1996/11/10 02:59:34 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.17 1996/11/13 20:48:18 scrappy Exp $ * *------------------------------------------------------------------------- */ @@ -578,7 +578,7 @@ CopyFrom(Relation rel, bool binary, bool oids, FILE *fp, char *delim) index_nulls, finfoP[i]); indexRes = index_insert(index_rels[i], &idatum, index_nulls, - &(tuple->t_ctid)); + &(tuple->t_ctid), false); if (indexRes) pfree(indexRes); } } diff --git a/src/backend/commands/defind.c b/src/backend/commands/defind.c index cd1bbc14747..0618be3e20a 100644 --- a/src/backend/commands/defind.c +++ b/src/backend/commands/defind.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/Attic/defind.c,v 1.8 1996/11/06 08:21:33 scrappy Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/Attic/defind.c,v 1.9 1996/11/13 20:48:22 scrappy Exp $ * *------------------------------------------------------------------------- */ @@ -69,6 +69,7 @@ DefineIndex(char *heapRelationName, char *accessMethodName, List *attributeList, List *parameterList, + bool unique, Expr *predicate, List *rangetable) { @@ -176,7 +177,7 @@ DefineIndex(char *heapRelationName, &fInfo, NULL, accessMethodId, numberOfAttributes, attributeNumberA, classObjectId, parameterCount, parameterA, (Node*)cnfPred, - lossy); + lossy, unique); }else { attributeNumberA = (AttrNumber *)palloc(numberOfAttributes * @@ -192,7 +193,7 @@ DefineIndex(char *heapRelationName, ((IndexElem*)lfirst(attributeList))->tname, accessMethodId, numberOfAttributes, attributeNumberA, classObjectId, parameterCount, parameterA, (Node*)cnfPred, - lossy); + lossy, unique); } } |