PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)

From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)
Date: 2010-06-24 02:55:32
Message-ID: AANLkTikRplDtA-WS1VCoKkFBXiQEbPvOZhkNskv5WVWE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to prevent transaction abort when preparing command in
version 7.4?

I googled but haven't been able to find the answer. The issue occurs when
our software trys to prepare a command that is already prepared (by the same
or different app). PQprepare returns error and aborts current transaction.
The company is not willing to upgrade from 7.4 to a later version due to
risk.

SAVEPOINTs are not available in v.7.4. I'm looking at PQdescribePrepared
function. What is the right solution?

Thank you
Konstantin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-06-24 03:25:44 Re: PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)
Previous Message Kenichiro Tanaka 2010-06-24 01:29:39 Re: SQL error: could not connect to database