Re: Best way to use indexes for partial match at

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Andrus" <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to use indexes for partial match at
Date: 2005-11-10 13:45:54
Message-ID: 200511101445.55086.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Maik Trömel 2005-11-10 13:58:14 time zone - timestamp
Previous Message Richard Sydney-Smith 2005-11-10 13:25:41 pgdump from 8.0.4 not valid for import into 8.1.0