Re: Problem close curser after rollback

2020-09-30 Thread Matthias Apitz
El día miércoles, septiembre 30, 2020 a las 02:37:23p. m. -0400, Tom Lane escribió: > Matthias Apitz writes: > > El día miércoles, septiembre 30, 2020 a las 05:26:39p. m. +0200, Laurenz > > Albe escribió: > >> On Wed, 2020-09-30 at 13:32 +, Wiltsch,Sigrid wrote: > >>> What can I do so that

Re: Problem close curser after rollback

2020-09-30 Thread Karsten Hilbert
On Wed, Sep 30, 2020 at 09:06:13PM +0200, Matthias Apitz wrote: > Btw: In all of the other DBS (Informix, Sybase, Oracle) we could define that > point with START TRANSACTION. You can always use SET SAVEPOINT. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Problem close curser after rollback

2020-09-30 Thread Matthias Apitz
On Wednesday, 30 September 2020 20:37:23 CEST, Tom Lane wrote: Matthias Apitz writes: El día miércoles, septiembre 30, 2020 a las 05:26:39p. m. +0200, Laurenz Albe escribió: On Wed, 2020-09-30 at 13:32 +, Wiltsch,Sigrid wrote: What can I do so that the cursor is retained despite rollback

Re: Problem close curser after rollback

2020-09-30 Thread Tom Lane
Matthias Apitz writes: > El día miércoles, septiembre 30, 2020 a las 05:26:39p. m. +0200, Laurenz Albe > escribió: >> On Wed, 2020-09-30 at 13:32 +, Wiltsch,Sigrid wrote: >>> What can I do so that the cursor is retained despite rollback? >> You cannot start a transaction while you are readin

Re: Problem close curser after rollback

2020-09-30 Thread Matthias Apitz
El día miércoles, septiembre 30, 2020 a las 05:26:39p. m. +0200, Laurenz Albe escribió: > On Wed, 2020-09-30 at 13:32 +, Wiltsch,Sigrid wrote: > > we use the following statements in our applications, as described on the > > site: > > > > https://www.postgresql.org/docs/11/ecpg-commands.htm

Re: Problem close curser after rollback

2020-09-30 Thread Laurenz Albe
On Wed, 2020-09-30 at 13:32 +, Wiltsch,Sigrid wrote: > we use the following statements in our applications, as described on the > site: > > https://www.postgresql.org/docs/11/ecpg-commands.html#ECPG-TRANSACTIONS > > EXEC SQL PREPARE stmt1 FROM "SELECT oid,datname FROM pg_database WHERE oid

Re: Problem close curser after rollback

2020-09-30 Thread Matthias Apitz
El día miércoles, septiembre 30, 2020 a las 01:32:41p. m. +, Wiltsch,Sigrid escribió: >   > Hi,  > > we use the following statements in our applications, as described on the > site: >   > https://www.postgresql.org/docs/11/ecpg-commands.html#ECPG-TRANSACTIONS >   > EXEC SQL PREPARE stmt1

Problem close curser after rollback

2020-09-30 Thread Wiltsch,Sigrid
  Hi,  we use the following statements in our applications, as described on the site:   https://www.postgresql.org/docs/11/ecpg-commands.html#ECPG-TRANSACTIONS   EXEC SQL PREPARE stmt1 FROM "SELECT oid,datname FROM pg_database WHERE oid > ?"; EXEC SQL DECLARE foo_bar CURSOR FOR stmt1;   /* when