Feature request - function-based deferrable uniques.

Поиск
Список
Период
Сортировка
От Dmitry Fefelov
Тема Feature request - function-based deferrable uniques.
Дата
Msg-id 201003311258.01376.fozzy@ac-sw.com
обсуждение исходный текст
Ответы Re: Feature request - function-based deferrable uniques.  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
Re: Feature request - function-based deferrable uniques.  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Parameter name standby_mode
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Alpha release this week?