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