Re: PQprepare in PostgreSQL 7.4 (lack of SAVEPOINTs)

On Wed, Jun 23, 2010 at 10:55 PM, Konstantin Izmailov <pgfizm@gmail.com> wrote:
> 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?

Upgrading to a later version of pgsql, or don't issue that command
twice in a transaction.

The risk of upgrading is less than the risk of staying on an
unsupported version of pgsql.  The company that won't upgrade is
making a poorly informed decision.