Re: Get TransactionID using ODBC API

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Nik Tek <niktek2005(at)gmail(dot)com>,pgsql-odbc(at)postgresql(dot)org
Subject: Re: Get TransactionID using ODBC API
Date: 2016-10-13 04:56:31
Message-ID: B0FF0DDD-D2C7-4370-AC90-0079E99AC068@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 13 October 2016 01:28:28 EEST, Nik Tek <niktek2005(at)gmail(dot)com> wrote:
>I'm looking for getting transactionID using pgsqlODBC APIs. Is there a
>way,
>I goggled but not much of help.
>
>I know in pg/sql, I can use txid_current()

There's no special API for that in the driver, but you can run a query: "select txid_current()".

- Heikki

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2016-10-13 06:48:24 Re: Re: ODBC isolationi level SQL_TXN_SERIALIZABLE -> "08001 Already connected."
Previous Message Nik Tek 2016-10-12 22:28:28 Get TransactionID using ODBC API