RE: Transaction control in procedures

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: RE: Transaction control in procedures
Date: 2017-11-16 12:04:59
Message-ID: HE1PR0301MB1979A0357C0557358ED98591902E0@HE1PR0301MB1979.eurprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rafia Sabih 2017-11-16 12:05:22 Re: [HACKERS] [POC] Faster processing at Gather node
Previous Message Etsuro Fujita 2017-11-16 11:53:33 Typo in comment