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

Wow...in less than 5 minutes....

Thanks

Ted

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> 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
> 

    
__________________________________ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo