From: | Joel Jacobson <joel(at)gluefinance(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Possible bug in pg_settings/pg_depend |
Date: | 2011-01-13 10:13:54 |
Message-ID: | AANLkTikszqFsnCMegodKdqDgiG23ezeQnjQYOZVAFB6H@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2011-01-13 10:19:42 | Re: Add function dependencies |
Previous Message | Shigeru HANADA | 2011-01-13 10:00:57 | Re: SQL/MED - file_fdw |