Re: UNIQUE contraint that is initially deferred in Postgres 8.4.13 - Mailing list pgsql-general

From Johannes Bauer
Subject Re: UNIQUE contraint that is initially deferred in Postgres 8.4.13
Date
Msg-id 5321A17C.5000204@gmx.de
Whole thread Raw
In response to Re: UNIQUE contraint that is initially deferred in Postgres 8.4.13  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: UNIQUE contraint that is initially deferred in Postgres 8.4.13
Next
From: fluxh
Date:
Subject: Re: FATAL: the database system is starting up