Postgres Pro
Downloads
Home   >   mailing lists

PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs) - Mailing list pgsql-general

From Konstantin Izmailov
Subject PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)
Date
Msg-id AANLkTikRplDtA-WS1VCoKkFBXiQEbPvOZhkNskv5WVWE@mail.gmail.com
Whole thread Raw
Responses Re: PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Kenichiro Tanaka
Date:
Subject: Re: SQL error: could not connect to database
Next
From: Scott Marlowe
Date:
Subject: Re: PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)