Postgres Pro
Downloads
Home   >   mailing lists

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

From Sander Steffann
Subject Re: default index created for primary key
Date
Msg-id 2B1A983EDCEC3447B22632B64F7264601085AB@bill.office.computel.nl
Whole thread Raw
In response to default index created for primary key  ("vinita bansal" <sagivini@hotmail.com>)
Responses Re: default index created for primary key  ("vinita bansal" <sagivini@hotmail.com>)
List pgsql-general
Tree view 
Hi,

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

That is not possible, because the index is used to guarantee
the uniqueness of the primary key.

What is the reason you want to turn it off?
Sander.

pgsql-general by date:

Previous
From: srini vasan
Date:
Subject: Re: Problem with Select output
Next
From: Steve Wampler
Date:
Subject: Re: postgresql.conf