Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED

2017-06-19 Thread Michael Paquier
On Tue, Jun 20, 2017 at 11:12 AM, Computer Study wrote: > The UI application is to add/remove some permissions through a listbox for > a certain user. For any add/remove, it will first delete all records for > this certain user in the table, then insert the values chose from UI. > > In my code sn

Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED

2017-06-19 Thread Computer Study
Thanks Tom. The version of Postgres is: 9.4.7 The UI application is to add/remove some permissions through a listbox for a certain user. For any add/remove, it will first delete all records for this certain user in the table, then insert the values chose from UI. In my code snippet, it first ex

Re: [GENERAL] Error with DefineSavepoint:Unexpected state STARTED

2017-06-19 Thread Tom Lane
Computer Study 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: SAV

[GENERAL] Error with DefineSavepoint:Unexpected state STARTED

2017-06-19 Thread Computer Study
Hi, 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;DEALLOCA