Postgres Pro
Downloads
Home   >   mailing lists

Questions about 9.2 unique constraints - Mailing list pgsql-general

From ac@hsk.hk
Subject Questions about 9.2 unique constraints
Date
Msg-id B1845AC9-9D71-4E97-AC0C-83708B389BEB@hsk.hk
Whole thread Raw
In response to Re: PostgreSQL 9.2 and PGBOUNCER  ("ac@hsk.hk" <ac@hsk.hk>)
List pgsql-general
Tree view 
Hi,

In PostgreSQL 9.0.x we must define a constraint as DEFERRABLE on the "create table", we cannot define DEFERRABLE on
"createtable as select", how is this restriction in 9.2 now? 

Also, in 9.2 can deferrable uniqueness be mixed with Foreign keys?

Thanks

pgsql-general by date:

Previous
From: Anjali Arora
Date:
Subject: When to run Vacuum in postgres 9.0.4
Next
From: Graeme Hinchliffe
Date:
Subject: Using composite types within PLPGSQL Function