Quick Links

Recreating unique index for primary key

From:	Ryan Ho <ryanho(at)pacific(dot)net(dot)sg>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Recreating unique index for primary key
Date:	2001-09-28 05:37:47
Message-ID:	01092813374700.01744@ryan
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi,

I've dropped an primary key index in order to re-create it. but i realized
that i can't recreate a primary key index. Will a unique index be an adequate
replacement? will the database integrity be at risk as a result?

Thanks!
--
Ho Siaw Ping, Ryan

In response to

Reference users for postgresql at 2001-09-22 17:20:19 from Frank Albert Ekern

Responses

Re: Recreating unique index for primary key at 2001-09-29 08:07:49 from Tod McQuillin
Re: Recreating unique index for primary key at 2001-09-29 14:41:44 from Tom Lane

Browse pgsql-general by date

	From	Date	Subject
Next Message	Janning Vygen	2001-09-28 07:27:59	Re: showing also value '0' with aggregate count()
Previous Message	Sameer Maggon	2001-09-28 05:24:45	TRIGGER and function