From: Ragnar Hafstað <gnari@simnet.is>
To: Theodore Petrosky <tedpet5@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: schemas and paths with the alter statement
Date: Tue, 22 Feb 2005 19:26:07 +0000
Message-ID: <1109100367.17839.134.camel@localhost.localdomain> (raw)
In-Reply-To: <20050222190604.90402.qmail@web41005.mail.yahoo.com>
References: <20050222190604.90402.qmail@web41005.mail.yahoo.com>
On Tue, 2005-02-22 at 11:06 -0800, Theodore Petrosky wrote:
> I have to first admit that I am very green at this. I
> thought that one could refer to a table in a fully
> qualified path... public.testtable
> ...
> ALTER TABLE public.test ADD CONSTRAINT public.test_PK
> PRIMARY KEY (test);
> ...
> aswebtest=# ALTER TABLE public.test ADD CONSTRAINT
> public.test_PK PRIMARY KEY (test);
> ERROR: syntax error at or near "." at character 46
it not the first public that is the problem, but the
second one, as you might discover if you count 46
characters.
you cannot put the constraint in a different schema than
the table, it seems.
gnari
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gnari@simnet.is, tedpet5@yahoo.com
Subject: Re: schemas and paths with the alter statement
In-Reply-To: <1109100367.17839.134.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox