Skip site navigation (1) Skip section navigation (2)

default index for primary key of a table

From: Vinita(dot)Bansal(at)trilogy(dot)com
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: default index for primary key of a table
Date: 2004-12-22 13:25:29
Message-ID: OFA1A0B8BB.1A510F75-ON86256F72.0049798F@trilogy.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Hi,

Postgres automatically creates index for Primary key of a table. I want to 
turn this off, so that the default index is not created for primary key. 
How can I do this??

Regards,
Vinita Bansal

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-12-22 16:14:36
Subject: Re: VACUUMing for 30 minutes
Previous:From: Joshua D. DrakeDate: 2004-12-22 06:38:11
Subject: Re: VACUUMing for 30 minutes

pgsql-general by date

Next:From: vinita bansalDate: 2004-12-22 13:32:14
Subject: default index created for primary key
Previous:From: Postgres LearnerDate: 2004-12-22 13:00:42
Subject: Re: weird run-times with pg_autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group