On Wed, 2009-02-11 at 12:43 +0300, Igor Katson wrote: > ERROR: XX000: SPI_execute_plan failed executing query "PREPARE > TRANSACTION '2pctest'": SPI_ERROR_TRANSACTION It's probably treating the word PREPARE specially. You can avoid this problem by using EXECUTE and specifying the command as a string. > Is there a way to achieve the needed behaviour with two-phase commmit, > plpgsql and plproxy ? You can't begin or end a transaction inside a function. If that was allowed, what would the function do after the transaction was prepared? I think you need to do PREPARE TRANSACTION separately, somehow. You might need to modify plproxy to do that the way you want. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
