Computer Study <computerstudy2010@xxxxxxxxx> writes: > I am working on a project of DB migration from Oracle to Postgres. The > application is working well with Oracle. But when switch to Postgres, some > SQL executionss couldn't finish and got an error like: > FATAL: DefineSavepoint: unexpected state STARTED > STATEMENT: SAVEPOINT_per_query_svp;DEALLOCATE > "_PLAN04824560";RELEASE_per_query_SVP_ Well, that's pretty interesting, but you haven't provided nearly enough information for anyone else to reproduce the problem. (No, a snippet of C++ that depends on undescribed subroutines and uncertain context doesn't do it.) Perhaps you could turn on log_statement = all and capture the SQL that's actually being sent to the server by this program? Also, what version of Postgres is this exactly? > Any suggestions to fix this issue? https://wiki.postgresql.org/wiki/Guide_to_reporting_problems regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
