Questions about 9.2 unique constraints

From: "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Cc: ac(at)hsk(dot)hk
Subject: Questions about 9.2 unique constraints
Date: 2013-01-08 12:56:20
Message-ID: B1845AC9-9D71-4E97-AC0C-83708B389BEB@hsk.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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

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

Thanks

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wolf Schwurack 2013-01-08 15:09:07 Error: absolute path not allowed
Previous Message Anjali Arora 2013-01-08 12:45:15 When to run Vacuum in postgres 9.0.4