Possible bug in pg_settings/pg_depend
От | Joel Jacobson |
---|---|
Тема | Possible bug in pg_settings/pg_depend |
Дата | |
Msg-id | AANLkTikszqFsnCMegodKdqDgiG23ezeQnjQYOZVAFB6H@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Possible bug in pg_settings/pg_depend
|
Список | 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.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
В списке pgsql-hackers по дате отправления: