Postgres Pro
Downloads
Home   >   mailing lists

Re: SET CONSTRAINTS not schema-aware - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SET CONSTRAINTS not schema-aware
Date
Msg-id 10318.1053018951@sss.pgh.pa.us
Whole thread Raw
In response to Re: SET CONSTRAINTS not schema-aware  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: SET CONSTRAINTS not schema-aware  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
"scott.marlowe" <scott.marlowe@ihs.com> writes:
> S is the schema, so it would appear they do mean that constraints are 
> "contained" so to speak by a schema.

Right.  In SQL92 constraint names have to be unique within the table's
schema.  Postgres allows two different tables to have similarly-named
constraints, and that difference is the root of the issue.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: SET CONSTRAINTS not schema-aware
Next
From: Kurt Roeckx
Date:
Subject: Re: Win32, compiles, under, MinGW/Msys!