Postgres Pro
Downloads
Home   >   mailing lists

Re: schemas and paths with the alter statement - Mailing list pgsql-sql

From Tom Lane
Subject Re: schemas and paths with the alter statement
Date
Msg-id 11540.1109099765@sss.pgh.pa.us
Whole thread Raw
In response to schemas and paths with the alter statement  (Theodore Petrosky <tedpet5@yahoo.com>)
Responses Re: schemas and paths with the alter statement  (Theodore Petrosky <tedpet5@yahoo.com>)
List pgsql-sql
Tree view 
Theodore Petrosky <tedpet5@yahoo.com> writes:
> ALTER TABLE public.test ADD CONSTRAINT public.test_PK
> PRIMARY KEY (test);

Constraints don't have schema-qualified names.  Try

ALTER TABLE public.test ADD CONSTRAINT test_PK PRIMARY KEY (test);

The error message was pointing to the correct place BTW.
        regards, tom lane

pgsql-sql by date:

Previous
From: Theodore Petrosky
Date:
Subject: schemas and paths with the alter statement
Next
From: Richard Huxton
Date:
Subject: Re: schemas and paths with the alter statement