ERROR: cursor 'xxx' does not exist

Поиск
Список
Период
Сортировка
От ngoncalves81@cantv.net
Тема ERROR: cursor 'xxx' does not exist
Дата
Msg-id 410-22005931416152762@cantv.net
обсуждение исходный текст
Список pgsql-general
  I had a problem with a program that load about 2 MB of information from
de DB with a rate of data transfer about 80K. I don´t know why the 'top' of
80K, but is not harware. I still have this problem.
 Then I set the "Use Declare/Fetch" opcion on the ODBC. This opcion take
the information to transfer from 2MB to about 100K. But I have a BIG
problem, this opcion activate the use of cursors and the use of commit and
rollback. The problem is that I get the message  'ERROR: cursor "xxx" does
not exist' when it makes the close cursor (I see this on the CommLog of
ODBC), but the cursor was declared previously. The really problem is
'ERROR:  current transaction is aborted, commands ignored until end of
transaction block' because of cursor's problem. Since I set the "Use
Declare/Fetch" the ODBC use transactions (BEGIN,COMMIT,ETC).
 I do not want the use of transactions. Can I use Cursors and 'Disable'
Transactions ?. I'm using postgresql 8.0 windows native.

                                        Nuno Goncalves


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

Предыдущее
От: Marco Colombo
Дата:
Сообщение: Re: Block Size and various FS settings
Следующее
От: William Leite Araújo
Дата:
Сообщение: TSearch2 snowball version error