Re: Affected rows count by rule as condtition

From: mito <milos(dot)orszag(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Affected rows count by rule as condtition
Date: 2009-04-13 16:59:18
Message-ID: grvr16$jtc$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)orszag(at)gmail(dot)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?
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message - - 2009-04-13 17:18:31 Unicode support
Previous Message Simon Riggs 2009-04-13 16:46:23 Re: New trigger option of pg_standby