Re: Primary key vs unique index

From: rverghese <riyav(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Primary key vs unique index
Date: 2012-07-06 18:07:16
Message-ID: 1341598036875-5715729.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-07-06 18:11:27 Re: index and data tablespaces on two separate drives or one RAID 0?
Previous Message Gurjeet Singh 2012-07-06 17:54:05 Re: Primary key vs unique index