Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PL/pgSQL equivalent to PQtransactionStatus?
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: Christophe <xof(at)thebuild(dot)com>
- Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
- Subject: Re: PL/pgSQL equivalent to PQtransactionStatus?
- Date: Thu, 31 Jul 2008 20:09:50 +0100
- Message-id: <48920DFE.1010909@archonet.com> <text/plain>
Christophe wrote:
On Jul 31, 2008, at 11:12 AM, Richard Huxton wrote:A pl/pgsql function *always* executes within a transaction.Indeed so. What I'm looking for is a way of detecting if a transaction block has been opened (i.e., we're within a BEGIN).
There is no difference between a transaction explicitly started with BEGIN...COMMIT and one wrapping a single statement.
What were you planning to do differently if a BEGIN was issued? -- Richard Huxton Archonet Ltd
- References:
- PL/pgSQL equivalent to PQtransactionStatus?
- From: Christophe
- Re: PL/pgSQL equivalent to PQtransactionStatus?
- From: Richard Huxton
- Re: PL/pgSQL equivalent to PQtransactionStatus?
- From: Christophe
- PL/pgSQL equivalent to PQtransactionStatus?
- Prev by Date: Re: PL/pgSQL equivalent to PQtransactionStatus?
- Next by Date: Using PostGres general distribution
- Previous by thread: Re: PL/pgSQL equivalent to PQtransactionStatus?
- Next by thread: Using PostGres general distribution
- Indexes: