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.1alpha3 on 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
