Re: UNIQUE contraint that is initially deferred in Postgres 8.4.13

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 constraints are a new feature in PostgreSQL 9.0, so it
> shouldn't be working in 8.4.

Ah! Okay, thanks for the info. That would explain it :-)

> (And as a sidenote, a reminder that 8.4 will go end of life in just a
> couple of months, so if you aren't already planning an upgrade of your
> production environment, it's probably a good idea to start doing that, see
> http://www.postgresql.org/support/versioning/)

I'm going to roll up my sleeves and tackle that then...

Thanks for the help,
Joe