Re: Feature request - function-based deferrable uniques. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Feature request - function-based deferrable uniques.
Date
Msg-id 15876.1270132825@sss.pgh.pa.us
Whole thread Raw
In response to Re: Feature request - function-based deferrable uniques.  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> The reason it's not supported in table_constraint, IIUC, is that the
> standard doesn't allow it, and that syntax is standards-mandated.

The real problem is not so much extending the syntax as that there'd be
no way to represent the constraint in information_schema.  Exclusion
constraints are outside the standard already, so omitting them from the
information_schema views is less bad than missing unique constraints
would be.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Alias to rollback keyword
Next
From: Robert Haas
Date:
Subject: Re: missing schema qualifications in psql