Re: ECPG dynamic cursor fix for UPDATE/DELETE ... WHERE CURRENT OF :curname

Поиск
Список
Период
Сортировка
От Boszormenyi Zoltan
Тема Re: ECPG dynamic cursor fix for UPDATE/DELETE ... WHERE CURRENT OF :curname
Дата
Msg-id 4C585209.1030300@cybertec.at
обсуждение исходный текст
Ответ на Re: ECPG dynamic cursor fix for UPDATE/DELETE ... WHERE CURRENT OF :curname  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Kevin Grittner írta:
> Boszormenyi Zoltan <zb@cybertec.at> wrote:
>  
>   
>> attached is a patch that adds the missing feature
>>     
>  
>   
>> I certainly feel that this should be applied to 9.0 as a bugfix.
>>     
>  
> Those two statements seem to contradict one another.

PostgreSQL 8.3 or so added WHERE CURRENT OF <curname> at the SQL level.

9.0 added ECPG's dynamic cursorname (a char variable carries the actual
cursor name)
but the WHERE CURRENT OF part was not converted, which was definitely an
oversight. Whether this is a "missing feature" or a "bugfix", it's only
a difference in
points of view. I think this patch belongs to 9.0.

>   Is there some
> bug manifestation beyond an unimplemented feature this fixes? 
> Without this, is there some regression going from 8.4 to 9.0?
>   

I haven't looked at 8.4's regression tests but pgtypeslib/numeric.c in
8.4.4 has
the same problem, so the second patch (at least the numeric.c part) can be
applied there as well, maybe in even older branches.

Best regards,
Zoltán Böszörményi



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: ECPG dynamic cursor fix for UPDATE/DELETE ... WHERE CURRENT OF :curname
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info.