Re: Constraint problem - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Constraint problem
Date
Msg-id 200205161230.23619.josh@agliodbs.com
Whole thread Raw
In response to Re: Constraint problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Constraint problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Constraint problem  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-sql
Stephan,
> > I don't seem to be able to create a UNIQUE constraint as DEFERRABLE.  Is
this
> > not supported?
>
> Not currently.

Hmm ... my workaround didn't work.   I need to impose a unique constraint on
an INT column in a table, but make sure that the constraint isn't checked
until the end of an UPDATE statement, so that I can swap values when I need
to.

How can I do this?

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology     josh@agliodbs.com   and data management solutions     (415) 565-7293  for law firms, small
businesses     fax 621-2533   and non-profit organizations.     San Francisco 



pgsql-sql by date:

Previous
From: Scott Shattuck
Date:
Subject: Re: trigger question
Next
From: "Joel Burton"
Date:
Subject: Re: SQL over my head...