Postgres Pro
Downloads
Home   >   mailing lists

Re: Primary key vs unique index - Mailing list pgsql-general

From rverghese
Subject Re: Primary key vs unique index
Date
Msg-id 1341598036875-5715729.post@n5.nabble.com
Whole thread Raw
In response to Re: Primary key vs unique index  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Responses Re: Primary key vs unique index  (Gurjeet Singh <singh.gurjeet@gmail.com>)
List pgsql-general
Tree view 
Yes I am using that option for one of my POstgres 9.1 database and it works
well. But its still an issue with Foreign keys, which you need to drop and
recreate . Also I use Slony for replication and it uses the primary key to
check repl. So I don't want that to be interrupted by dropping PK and
recreating PK.
Thanks
RV

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Primary-key-vs-unique-index-tp3883778p5715729.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Primary key vs unique index
Next
From: John R Pierce
Date:
Subject: Re: index and data tablespaces on two separate drives or one RAID 0?