UNIQUE contraint that is initially deferred in Postgres 8.4.13

Поиск
Список
Период
Сортировка
От Johannes Bauer
Тема UNIQUE contraint that is initially deferred in Postgres 8.4.13
Дата
Msg-id 53219DA1.40602@gmx.de
обсуждение исходный текст
Ответы Re: UNIQUE contraint that is initially deferred in Postgres 8.4.13  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
Hi list,

I'm having trouble with a UNIQUE constraint that I need to have
DEFERRABLE INITIALLY DEFERRED. On my Dev machine (Postgres 9.1) it works
fine:

alter table foo drop constraint bar;
ALTER TABLE

alter table foo add constraint bar UNIQUE (col1, col2) deferrable
initially deferred;
ALTER TABLE


In Production (Postgres 8.4.13) this blows up in my face although it
should be supported according to the docs:


alter table foo drop constraint bar;
ALTER TABLE

alter table foo add constraint bar UNIQUE (col1, col2) deferrable
initially deferred;
FEHLER:  Syntaxfehler bei »DEFERRABLE«
LINE 1: bar UNIQUE (col1, col2) DEFERRABLE...
                                ^

(i.e. syntax error at "DEFERRABLE", psql seems to ignore my locale
setting).

Does somebody know what the reason for this could be? I'm kind of puzzled.

Thanks in advance,
Best regards,
Joe


В списке pgsql-general по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: FATAL: the database system is starting up
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: UNIQUE contraint that is initially deferred in Postgres 8.4.13