Are multiple identical entires in pg_depend possible?
If so, how do they occur, and what is the purpose of representing
exactly the same dependency two times in pg_depend?
I expected the following query not to return any rows, but it did:
glue=# select count(*), * from pg_depend group by classid, objid,
objsubid, refclassid, refobjid, refobjsubid, deptype having count(*) >
1;count | classid | objid | objsubid | refclassid | refobjid |
refobjsubid | deptype
-------+---------+-------+----------+------------+----------+-------------+--------- 2 | 2618 | 11015 | 0
| 1259 | 11012 | 1 | n
(1 row)
Debug data:
glue=# select version(); version
-------------------------------------------------------------------------------------------------------------PostgreSQL
9.1alpha3on x86_64-unknown-linux-gnu, compiled by GCC gcc
(Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit
(1 row)
glue=# select pg_describe_object(2618,11015,0);
pg_describe_object
----------------------------------------rule pg_settings_u on view pg_settings
(1 row)
glue=# select pg_describe_object(1259,11012,1); pg_describe_object
------------------------------view pg_settings column name
(1 row)
--
Best regards,
Joel Jacobson
Glue Finance