On 08/09/2011 01:27 AM, Tom Lane wrote: > Another approach is to check pg_depend. A cast installed by initdb will > match a "pin" entry in pg_depend (refclassid = pg_cast, refobjid = > cast's OID, deptype = 'p'). You're still out of luck for distinguishing > extension members in existing releases, but in 9.1 and up it'll be > possible to identify casts belonging to extensions from pg_depend > entries.
Intriguing alternative. The query is for my dbtoyaml utility which is sort of equivalent to pg_dump -s --format=y (yaml). So for now, I'll stick to emulating what dumpCast in pg_dump.c does. Joe -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
