Re: Column/type dependency recording inconsistencies

Petr Jelinek  writes:
> But the problem with the extension persists, I will try to dig more to 
> find what is the real cause.

Hm ... I reproduced the problem here.  I can't see anything that looks
wrong about the pg_depend entries:
                 obj                   |                          ref                          | deptype 
----------------------------------------+-------------------------------------------------------+---------extension deptestext                   | schema public                                         | ncomposite type droppabletype1          | type droppabletype1                                   | itype droppabletype1[]                  | type droppabletype1                                   | itype droppabletype1                    | schema public                                         | ntype droppabletype1                    | extension deptestext                                  | etable testtable                        | schema public                                         | ntable testtable                        | extension deptestext                                  | etable testtable column droppablecol2   | type droppabletype1                                   | ntable testtable column droppablecol1   | type droppabletype1                                   | ntable testtable column undroppablecol1 | type undroppabletype                                  | ntable testtable column undroppablecol2 | type undroppabletype                                  | ntype testtable[]                       | type testtable                                        | itype testtable                         | table testtable                                       | icomposite type undroppabletype         | type undroppabletype                                  | itype undroppabletype[]                 | type undroppabletype                                  | itype undroppabletype                   | schema public                                         | ntype undroppabletype                   | extension deptestext                                  | etoast table pg_toast.pg_toast_162813   | table testtable                                       | itype pg_toast.pg_toast_162813          | toast table pg_toast.pg_toast_162813                  | iindex pg_toast.pg_toast_162813_index   | toast table pg_toast.pg_toast_162813 column chunk_id  | aindex pg_toast.pg_toast_162813_index   | toast table pg_toast.pg_toast_162813 column chunk_seq | a
(21 rows)

but sure enough:

d1=# drop extension deptestext;
ERROR:  cannot drop extension deptestext because other objects depend on it
DETAIL:  table testtable column undroppablecol2 depends on type undroppabletype
table testtable column undroppablecol1 depends on type undroppabletype
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

I suspect this is actually a bug in the dependency search logic in DROP.
Don't have the energy to chase it right now though.
		regards, tom lane