Re: Can this be done?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ashley Clark <aclark(at)ghoti(dot)org>
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can this be done?
Date: 2000-11-15 05:42:27
Message-ID: 12105.974266947@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ashley Clark <aclark(at)ghoti(dot)org> writes:
> Can I defer constraint checking on unique indexes?

No, not at present. Consider restructuring your UPDATE into sequential
steps so that the intermediate states can't cause index failures. Or
just don't make the index unique...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Janssen 2000-11-15 05:43:56 Use of variables within a select statement in a function
Previous Message Ashley Clark 2000-11-15 05:32:40 Can this be done?