Re: Constraint problem

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