"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 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. > In 7.2 you mean? Or did you just fix it then? I just fixed it moments before sending that message. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html