Postgres Pro
Downloads
Home   >   mailing lists

Re: Can this be done? - Mailing list pgsql-general

From Tom Lane
Subject Re: Can this be done?
Date
Msg-id 12105.974266947@sss.pgh.pa.us
Whole thread Raw
In response to Can this be done?  (Ashley Clark <aclark@ghoti.org>)
Responses Re: Can this be done?  (Ashley Clark <aclark@ghoti.org>)
List pgsql-general
Tree view 
Ashley Clark <aclark@ghoti.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

pgsql-general by date:

Previous
From: Ashley Clark
Date:
Subject: Can this be done?
Next
From: Ashley Clark
Date:
Subject: Re: Can this be done?