On Wed, Dec 15, 2010 at 10:15 AM, Dimitri Fontaine
<dimitri@2ndquadrant.fr> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> Wrong probem. What we need is a way to identify a type without
>> knowing in advance what its OID is. In other words, we need to
>> distinguish between the hstore type that is shipped in contrib, and
>> some stupid DBA who types "CREATE DOMAIN hstore as text".
>
> Yeah, yeah. Now, what's wrong with the query I sent?
>
> To ease discussion:
>
> =# select objid
> from pg_extension_objects('hstore')
> where class = 'pg_type'::regclass and objdesc ~ '(^|\.)hstore$';
> objid
> -------
> 16387
> (1 row)
OK, so I guess your point is that I should read the whole email before
replying. :-)
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company