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

From Tom Lane
Subject Re: SET CONSTRAINTS not schema-aware
Date
Msg-id 8589.1052747052@sss.pgh.pa.us
Whole thread Raw
In response to Re: SET CONSTRAINTS not schema-aware  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>> Yeah.  We had that discussion at some point during the 7.3 development
>> cycle, and concluded we liked table-local naming for constraints better
>> than the SQL spec's global constraint names.

> Then why does pg_constraint store a schema OID?

I think we left it there for possible future use with assertions, which
are not tied to any particular table.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Christoph Haller
Date:
Subject: Re: PostgreSQL Cookbook Site Down
Next
From: Lamar Owen
Date:
Subject: Re: PostgreSQL Cookbook Site Down