Re: Creating unique constraints on OID

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> 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 <peter_e@gmx.net> 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.

> In 7.2 you mean?  Or did you just fix it then?

I just fixed it moments before sending that message.
        regards, tom lane