Bug in pg_describe_object (was: Re: [HACKERS] obj_unique_identifier(oid))
| От | Andreas Karlsson |
|---|---|
| Тема | Bug in pg_describe_object (was: Re: [HACKERS] obj_unique_identifier(oid)) |
| Дата | |
| Msg-id | 1294688330.27439.59.camel@jansson обсуждение исходный текст |
| Ответ на | Re: obj_unique_identifier(oid) (Andreas Karlsson <andreas@proxel.se>) |
| Ответы |
Re: Bug in pg_describe_object (was: Re: [HACKERS] obj_unique_identifier(oid))
Re: Bug in pg_describe_object (was: Re: [HACKERS] obj_unique_identifier(oid)) Re: Bug in pg_describe_object, patch v2 |
| Список | pgsql-hackers |
Here is the bug-fix patch again with a description of the context so I
can add it to the commit fest.
Joel Jacobson discovered a bug in the function pg_describe_object where
it does not produce unique identifiers for some entries in pg_amproc.
This patch fixes the bug where when two entries in pg_amproc only differ
in amproclefttype or amprocrighttype the same description will be
produced by pg_describe_object, by simply adding the two fields
(amproclefttype, amprocrighttype) to the description.
== Before patch
SELECT pg_describe_object('pg_amproc'::regclass,oid,0)
FROM pg_amproc WHERE oid IN (10608,10612);
pg_describe_object
------------------------------------------------------------------------------------
function 1 bttextcmp(text,text) of operator family array_ops for access method gin
function 1 bttextcmp(text,text) of operator family array_ops for access method gin
(2 rows)
== After patch
SELECT pg_describe_object('pg_amproc'::regclass,oid,0)
FROM pg_amproc WHERE oid IN (10608,10612);
pg_describe_object
----------------------------------------------------------------------------------------------------------------------------------
function 1 bttextcmp(text,text) of operator family array_ops for access method gin for (text[],text[])
function 1 bttextcmp(text,text) of operator family array_ops for access method gin for (character varying[],character
varying[])
(2 rows)
Regards,
Andreas
Вложения
В списке pgsql-hackers по дате отправления: