Re: Use Declare/Fetch and PG 7.4

Поиск
Список
Период
Сортировка
От Cyrille Chepelov
Тема Re: Use Declare/Fetch and PG 7.4
Дата
Msg-id 20031110211302.GA21247@chepelov.org
обсуждение исходный текст
Ответ на Use Declare/Fetch and PG 7.4  ("alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>)
Ответы Re: Use Declare/Fetch and PG 7.4  ("alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>)
Список pgsql-odbc
Le Mon, Nov 10, 2003, à 04:30:42PM -0200, alexandre :: aldeia digital a écrit:

> When the ODBC´s "Use Declare/Fetch" option is enabled the automatic
> declaration of cursor great improve the performence for me.

I second this observation with the workloads I'm confronted with.

> In PG 7.3, this causes a WARNING only, but the behavior of this event is
> changed to ERROR in PG 7.4, aborting the application.

I'm not going to contribute much here, except express interest in seeing
a solution to this (I didn't plan to move to 7.4 very quickly, but this
would be a showstopper to me -- it's not a totally rare event for me to
need datasets beyond what 32-bit Win32 will allow a single process to
allocate, thus killing postgres.exe (ouch!)).

    -- Cyrille

--
FRA: 61-18(FIJ) 51-29(JPN) 51-9(SCO) 41-14(USA) >> 43-21(IRL)

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

Предыдущее
От: "alexandre :: aldeia digital"
Дата:
Сообщение: Use Declare/Fetch and PG 7.4
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Help with hang on empty query (PG 7.3.2,