SET CONSTRAINTS not schema-aware

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: SET CONSTRAINTS not schema-aware
Date: 2003-05-11 16:46:32
Message-ID: Pine.LNX.4.44.0305111812500.2399-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

--
Peter Eisentraut peter_e(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ron Johnson 2003-05-11 16:54:50 Re: realtime data inserts
Previous Message Tilo Schwarz 2003-05-11 16:21:28 ERROR: Memory exhausted in AllocSetAlloc(188)