Feature request - function-based deferrable uniques.

From: Dmitry Fefelov <fozzy(at)ac-sw(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Feature request - function-based deferrable uniques.
Date: 2010-03-31 05:58:01
Message-ID: 201003311258.01376.fozzy@ac-sw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

For now Postgres able to create deferrable uniques with following syntax:

...
and table_constraint is:

[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) index_parameters |
PRIMARY KEY ( column_name [, ... ] ) index_parameters |
CHECK ( expression ) |
FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [,
... ] ) ]
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON
UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

So, deferrable uniques now can be based on column/columns list only. It will
be very useful if there will be possibility to specify functions in this list.
Is it possible?

Regards,
Dmitry

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message MUHAMMAD ASIF 2010-03-31 06:40:33 Re: UUIDs generated using ossp-uuid on windows not unique
Previous Message Stefan Kaltenbrunner 2010-03-31 05:57:56 Re: Alpha release this week?