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 19:12:32 +0100
- Message-id: <48920090.1030105@archonet.com> <text/plain>
Christophe wrote:
My apologies if this is in the docs and I missed it, but is there a PL/pgSQL function equivalent for the pglib function PQtransactionStatus (i.e., a way to find out if we're in an open transaction block, and if that transaction is in an error status)?
A pl/pgsql function *always* executes within a transaction.If an error occurs while that function is executing you can catch the exception (see the "Trapping Errors" section of the pl/pgsql docs).
If an error occurs before the function executes then no other statements will be executed.
HTH -- Richard Huxton Archonet Ltd
- Follow-Ups:
- Re: PL/pgSQL equivalent to PQtransactionStatus?
- From: Christophe
- Re: PL/pgSQL equivalent to PQtransactionStatus?
- References:
- PL/pgSQL equivalent to PQtransactionStatus?
- From: Christophe
- PL/pgSQL equivalent to PQtransactionStatus?
- Prev by Date: Re: Partitioned tables and views
- Next by Date: Re: Doing an LDAP lookup from a SQL SELECT
- Previous by thread: PL/pgSQL equivalent to PQtransactionStatus?
- Next by thread: Re: PL/pgSQL equivalent to PQtransactionStatus?
- Indexes: