Linked Server OPENQUERY fails - SAVEPOINT Error

Report PGNP bugs.

Linked Server OPENQUERY fails - SAVEPOINT Error

Postby bcyb » Mon Oct 10, 2011 2:25 pm

We're occasionally getting the following error on linked server open query statements:

ERROR: SAVEPOINT may only be used in transaction blocks

This error has occurred 4 times in the past month. Searching the postgres log history, I can't find a successful SAVEPOINT issued by the driver. Each occurrence was outside of a transaction.

Please advise.

Source database: Greenplum version 4.0.5 (PG version 8.2)


Thank you,
-Brad
bcyb
 
Posts: 1
Joined: Mon Oct 10, 2011 12:45 pm

Re: Linked Server OPENQUERY fails - SAVEPOINT Error

Postby Moderator » Mon Oct 10, 2011 7:43 pm

Have you tried to reproduce the issue with build 2254 or later?

In case you are still able to reproduce the issue with the latest build, would you send more details about your environment to "Support"?
User avatar
Moderator
Site Admin
 
Posts: 279
Joined: Wed Oct 29, 2008 11:27 pm


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest

cron