Re: Questions about indexes - Mailing list pgsql-general

From Frank Bax
Subject Re: Questions about indexes
Date
Msg-id 3.0.6.32.20010509074619.01dff100@pop6.sympatico.ca
Whole thread Raw
In response to Re: Questions about indexes  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
At 11:10 AM 5/9/01 +0200, DaVinci wrote:
>On Wed, May 09, 2001 at 10:31:27AM +0200, Renaud Thonnart wrote:
>> How can I delete them in keeping integrity in the database?
>
> drop index?...

Dropping the index will not maintain the PK integrity...

http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-createtable
.html
says:
PRIMARY KEY Constraint
Notes:
Postgres automatically creates a unique index to assure data integrity (see
CREATE INDEX statement).

Frank

pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: Auto-timestamp generator (attached)
Next
From: Tatsuo Ishii
Date:
Subject: Re: Charset and encoding