Re: Schema search for default operator classes (was: [ADMIN] Cross schema Primary Key Indexes problem with datatype in the public schema)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org, cgg007(at)yahoo(dot)com
Subject: Re: Schema search for default operator classes (was: [ADMIN] Cross schema Primary Key Indexes problem with datatype in the public schema)
Date: 2006-02-09 14:09:45
Message-ID: 523.1139494185@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> Given that we only allow one default opclass for a datatype regardless
>> of schema (see DefineOpClass), it's not really necessary for
>> GetDefaultOpClass to restrict its search.

> How about doing the constrained search first, and revert to the
> unconstrained behavior if it doesn't find the desired opclass?

Seems like rather a lot of work to preserve a behavior that (AFAICS)
isn't even documented anywhere.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Erik G. Burrows 2006-02-09 15:13:16 Statement duration reporting
Previous Message Alvaro Herrera 2006-02-09 12:42:48 Re: Schema search for default operator classes (was: [ADMIN] Cross schema Primary Key Indexes problem with datatype in the public schema)

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-02-09 14:24:56 Re: User Defined Types in Java
Previous Message Thomas Hallgren 2006-02-09 13:27:42 Re: User Defined Types in Java