Re: Affected rows count by rule as condtition

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: mito <milos(dot)orszag(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Affected rows count by rule as condtition
Date: 2009-04-13 17:28:07
Message-ID: 603c8f070904131028o3509cfc1s81b1a6235300ab36@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Apr 13, 2009 at 12:59 PM, mito <milos(dot)orszag(at)gmail(dot)com> wrote:
> 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.

Use a partial index.

...Robert

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2009-04-13 18:07:29 proposal: add columns created and altered to pg_proc and pg_class
Previous Message mito 2009-04-13 17:20:02 Re: Affected rows count by rule as condtition