Possible bug in pg_settings/pg_depend

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

Responses

Browse pgsql-hackers by date

  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