[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

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