I assumed that it would work. Did I miss something in the docs that say you can not do this? Does "ALTER TABLE" not work with 'public.' before the table name?
on 7.4.6
aswebtest=# ALTER TABLE public.test ADD CONSTRAINT public.test_PK PRIMARY KEY (test); ERROR: syntax error at or near "." at character 46
Are you sure it's not the constraint that is causing the problem (he says, counting 46 characters in). I think a table constraint is by definition in the same schema as its table.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
