Re: hstores in pl/python

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