Re: Affected rows count by rule as condtition - Mailing list pgsql-hackers

From mito
Subject Re: Affected rows count by rule as condtition
Date
Msg-id grvr16$jtc$1@news.hub.org
Whole thread Raw
In response to Re: Affected rows count by rule as condtition  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: Affected rows count by rule as condtition  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: New trigger option of pg_standby
Next
From: Robert Haas
Date:
Subject: Re: Affected rows count by rule as condtition