On Wed, Dec 15, 2010 at 10:15 AM, Dimitri Fontaine <[email protected]> wrote: > Robert Haas <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
