On Sun, May 11, 2003 at 18:46:32 +0200, Peter Eisentraut <peter_e@gmx.net> wrote:
> SET CONSTRAINTS doesn't allow you to schema-qualify a constraint name.
> Here's an example:
>
> create schema test;
> create table test.foo (a int primary key);
> create table test.bar (b int primary key, c int constraint myconstraint references test.foo);
>
> -- This succeeds even though schema "test" is not in the search path:
> set constraints myconstraint immediate;
>
> -- This is what should work:
> set constraints test.myconstraint immediate;
> ERROR: parser: parse error at or near "." at character 21
>
> Comments?
I am pretty sure I saw some comments in the discussion about sequence
naming that constraints are per table and giving them a schema name
makes no sense. The table they are for has the schema name in it.