From: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Column/type dependency recording inconsistencies |
Date: | 2014-11-09 21:41:45 |
Message-ID: | 545FDF99.6020500@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-11-09 21:47:55 | Re: WAL format and API changes (9.5) |
Previous Message | Tom Lane | 2014-11-09 21:23:22 | Re: Column/type dependency recording inconsistencies |