Re: Column/type dependency recording inconsistencies

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