Re: Affected rows count by rule as condtition

Поиск
Список
Период
Сортировка
От mito
Тема Re: Affected rows count by rule as condtition
Дата
Msg-id grvr16$jtc$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Affected rows count by rule as condtition  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы Re: Affected rows count by rule as condtition  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
I am using rules as layer to save every version of row in shadow table, 
so i cant use unique constraint on column, because of many versions may 
have same value.

mito

Jaime Casanova wrote:
> On Mon, Apr 13, 2009 at 11:12 AM, mito <milos.orszag@gmail.com> wrote:
>> It need to simulate unique constraint on field s_users.new_id, so it should
>> deny to update multiple rows with same value.
>>
>> Any suggestions are welcome.
>>
> 
> why not simply create a UNIQUE constraint?
> 
> 


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: New trigger option of pg_standby
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Affected rows count by rule as condtition