From: | "ngoncalves81(at)cantv(dot)net" <ngoncalves81(at)cantv(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org |
Subject: | ERROR: cursor 'xxx' does not exist |
Date: | 2005-09-14 16:15:02 |
Message-ID: | 410-22005931416152762@cantv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Colombo | 2005-09-14 16:18:30 | Re: Block Size and various FS settings |
Previous Message | Scott Marlowe | 2005-09-14 15:23:42 | Re: Speed problems |