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)
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support