Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gastón Simone <gaston(at)apraful(dot)com(dot)uy>
Cc: "Oliver Fromme" <olli(at)lurza(dot)secnetix(dot)de>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Date: 2004-05-06 13:06:29
Message-ID: 26521.1083848789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

=?iso-8859-1?Q?Gast=F3n_Simone?= <gaston(at)apraful(dot)com(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Fromme 2004-05-06 13:18:10 Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Previous Message Gastón Simone 2004-05-06 12:47:53 Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!