Re: Constraint problem

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Constraint problem
Дата
Msg-id 200205161230.23619.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Constraint problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Constraint problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Constraint problem  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Scott Shattuck
Дата:
Сообщение: Re: trigger question
Следующее
От: "Joel Burton"
Дата:
Сообщение: Re: SQL over my head...