Re: psqlodbc && nested transaction
От | Inoue, Hiroshi |
---|---|
Тема | Re: psqlodbc && nested transaction |
Дата | |
Msg-id | 5dd5709a-3dae-f892-17ee-80b30b617232@dream.email.ne.jp обсуждение исходный текст |
Ответ на | psqlodbc && nested transaction (狐狸的面包雨 <jzy12081003@163.com>) |
Список | pgsql-odbc |
Hi,
ODBC doesn't provide the way to handle subtransactions.
It is up to users to call SQLExecDirect('savepoint xxxxx'/'release xxxxx'/'rollback to xxxxx' etc).
regards,
Hiroshi Inoue
On 2018/09/25 18:30, 狐狸的面包雨 wrote:
Hi,I have got some problems about psqlodbc.1. I have read documents about odbc(Microsoft) https://docs.microsoft.com/zh-cn/cpp/data/odbc/transaction-performing-a-transaction-in-a-recordset-odbc?view=vs-2017It mentions that " Only one level of transactions is supported; you cannot nest transactions. " What about postgresodbc ???2. I have tried the test directory and i also found some file that used transactions, such as the document i uploaded( /test/cursor-block-delete-test.c).in this file i can only see the SQLEndTran(), and i am wandering whether there is something methods that i can use to create subtransaction like what i do in the postgres.ovid
ODBC doesn't provide the way to handle subtransactions.
It is up to users to call SQLExecDirect('savepoint xxxxx'/'release xxxxx'/'rollback to xxxxx' etc).
regards,
Hiroshi Inoue
3. In the file , i can only find the method(SQLExecDirect()) that can handle the tranaction. Is there anyother functions that i can use to handle the transaction?I am a beginner of the pogramming, and my English is very poor. Thank you very much for occupying your time reading this mail. And your any advice will help me a lot!Thanks a lot!
В списке pgsql-odbc по дате отправления: