Re: Best way to use indexes for partial match at - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Best way to use indexes for partial match at
Date
Msg-id 200511101445.55086.peter_e@gmx.net
Whole thread Raw
In response to Re: Best way to use indexes for partial match at  ("Andrus" <eetasoft@online.ee>)
Responses Re: Best way to use indexes for partial match at  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Am Donnerstag, 10. November 2005 10:19 schrieb Andrus:
> thank you. I don't understand how to delete primary key index without
> removing primary key constraint or how to force primary key to use foo_bar
> index.

You cannot drop the primary key index without dropping the primary key, and
you cannot change the primary key to use a different index.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Richard Sydney-Smith
Date:
Subject: pgdump from 8.0.4 not valid for import into 8.1.0
Next
From: Maik Trömel
Date:
Subject: time zone - timestamp