RE: Transaction control in procedures - Mailing list pgsql-hackers

From legrand legrand
Subject RE: Transaction control in procedures
Date
Msg-id HE1PR0301MB1979A0357C0557358ED98591902E0@HE1PR0301MB1979.eurprd03.prod.outlook.com
Whole thread Raw
In response to Re: Transaction control in procedures  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Transaction control in procedures  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers

We are just opening the  "close cursors on/at commit" specification ;o)

- MS SQL server: cursor_close_on_commit
- Firebird: close_cursors_at_commit
- DB2: "with hold" syntax
- ...

I think it a plus to support keeping opened cursors at commit time,
but impacts have to be checked in details ...

Oracle Ora-1555 error comes in the extreme situation where rows used inside the cursor are modified, commited, before to be fetched.


pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Typo in comment
Next
From: Rafia Sabih
Date:
Subject: Re: [HACKERS] [POC] Faster processing at Gather node