Postgres Pro
Downloads
Home   >   mailing lists

Re: default index created for primary key - Mailing list pgsql-general

From Michael Fuhr
Subject Re: default index created for primary key
Date
Msg-id 20041222154841.GA72452@winnie.fuhr.org
Whole thread Raw
In response to default index created for primary key  ("vinita bansal" <sagivini@hotmail.com>)
List pgsql-general
Tree view 
On Wed, Dec 22, 2004 at 01:32:14PM +0000, vinita bansal wrote:

> I want to turn off the default setting in postgres for index creation on
> primary key of a table. Is it possible and how?

PostgreSQL uses the index to enforce the primary key's uniqueness.
What problem are you trying to solve by removing it?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Ned Lilly
Date:
Subject: nice work on the new site
Next
From: srini vasan
Date:
Subject: Re: Problem with Select output