Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: Schema search for default operator classes (was: [ADMIN] Cross schema Primary Key Indexes problem with datatype in the public schema)
Date
Msg-id 20060209124248.GC5234@surnet.cl
Whole thread Raw
In response to Schema search for default operator classes (was: [ADMIN] Cross schema Primary Key Indexes problem with datatype in the public schema)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Schema search for default operator classes (was: [ADMIN] Cross schema Primary Key Indexes problem with datatype in the public schema)
List pgsql-hackers
Tree view 
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.  I can think of some corner
> cases involving multiple binary-compatible-datatype matches where the
> restriction might give a unique answer when an unrestricted search would
> not, but I kinda doubt this would ever arise in practice.

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

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: User Defined Types in Java
Next
From: Thomas Hallgren
Date:
Subject: Re: User Defined Types in Java