On Wed, Jun 23, 2010 at 10:55 PM, Konstantin Izmailov <pgfizm@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general