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