[EMAIL PROTECTED] writes:

> 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??

Postgres does not support UNIQUE constraints (and PRIMARY KEY implies a UNIQUE
constraint) without an index. In Postgres the index is necessary to implement
the constraint.

In practice this doesn't usually cause any problem. Why do you want to do
this?

-- 
greg


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to