Robert Haas <robertmh...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
