On 09/11/14 22:23, Tom Lane wrote:
regression=# select pg_describe_object(classid,objid,objsubid) as obj, pg_describe_object(refclassid,refobjid,refobjsubid) as ref, deptype from pg_depend where refobjid = 'droppabletype1'::regtype; obj | ref | deptype --------------------------------------+---------------------+--------- composite type droppabletype1 | type droppabletype1 | i type droppabletype1[] | type droppabletype1 | i table testtable column droppablecol1 | type droppabletype1 | n (3 rows)regression=# select pg_describe_object(classid,objid,objsubid) as obj, pg_describe_object(refclassid,refobjid,refobjsubid) as ref, deptype from pg_depend where refobjid = 'droppabletype2'::regtype; obj | ref | deptype -------------------------------+---------------------+--------- composite type droppabletype2 | type droppabletype2 | i type droppabletype2[] | type droppabletype2 | i table testtable column f3 | type droppabletype2 | n (3 rows) The dependencies look just the same to me ...
Hmm actually you are correct, I somehow missed it when I looked manually (I didn't use pg_describe_object).
But the problem with the extension persists, I will try to dig more to find what is the real cause.
-- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
