Re: psqlodbc && nested transaction

Hi,

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-2017 
>
>        It 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!



---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com