Re: [GENERAL] UNIQUE contraint that is initially deferred in Postgres 8.4.13

2014-03-13 Thread Johannes Bauer
On 13.03.2014 13:02, Magnus Hagander wrote: > My guess is you're looking in the wrong place in the docs - can you specify > where you are looking? If you are in the right place then the docs are > wrong. Here: http://www.postgresql.org/docs/8.4/static/sql-createtable.html > Deferrable unique con

[GENERAL] UNIQUE contraint that is initially deferred in Postgres 8.4.13

2014-03-13 Thread Johannes Bauer
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 TAB