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