Postgres Pro
Downloads
Home   >   mailing lists

Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!! - Mailing list pgsql-novice

From Tom Lane
Subject Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Date
Msg-id 26521.1083848789@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!  (Gastón Simone <gaston@apraful.com.uy>)
Responses Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
List pgsql-novice
Tree view 
=?iso-8859-1?Q?Gast=F3n_Simone?= <gaston@apraful.com.uy> writes:
> I thought the COMMIT SQL command closes every opened cursor when it's
> executed!!

It does.  But see the WITH HOLD option of DECLARE CURSOR.

Note using this option is NOT free.

            regards, tom lane

pgsql-novice by date:

Previous
From: Gastón Simone
Date:
Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Next
From: Oliver Fromme
Date:
Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!