Re: [HACKERS] Creating unique constraints on OID

2001-10-22 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > So the result of all this is that the behaviour of my ADD UNIQUE code is > correct in this case? The AlterTable code wasn't broken; the error was in parser/analyze.c, which was prematurely rejecting the command. >> Peter Eisentraut <[EMAIL

Re: [HACKERS] Creating unique constraints on OID

2001-10-22 Thread Christopher Kings-Lynne
So the result of all this is that the behaviour of my ADD UNIQUE code is correct in this case? > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Shouldn't this work? > > create table test ( a int, unique (oid) ); > > ERROR: CREATE TABLE: column "oid" named in key does not exist > > Now it does.

Re: [HACKERS] Creating unique constraints on OID

2001-10-22 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Shouldn't this work? > create table test ( a int, unique (oid) ); > ERROR: CREATE TABLE: column "oid" named in key does not exist Now it does. regression=# create table test ( a int, unique (oid) ); NOTICE: CREATE TABLE/UNIQUE will create implicit