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

From Peter Eisentraut
Subject Re: SET CONSTRAINTS not schema-aware
Date
Msg-id Pine.LNX.4.44.0305121203280.6441-100000@peter.localdomain
Whole thread Raw
In response to Re: SET CONSTRAINTS not schema-aware  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SET CONSTRAINTS not schema-aware
List pgsql-hackers
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?  The comments say it's for
SQL compatibility, so where else does it need to be compatible besides
this case?

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Sailesh Krishnamurthy
Date:
Subject: Re: compliling postgresql
Next
From: "geekmalda"
Date:
Subject: unsubscribe-pattern-allmatching greenback frog