Re: default index created for primary key

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: vinita bansal <sagivini(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: default index created for primary key
Date: 2004-12-22 15:48:41
Message-ID: 20041222154841.GA72452@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message srini vasan 2004-12-22 15:50:56 Re: Problem with Select output
Previous Message Ned Lilly 2004-12-22 15:41:31 nice work on the new site