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

From Oliver Fromme
Subject Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Date
Msg-id 200405061322.i46DMMeF008128@lurza.secnetix.de
Whole thread Raw
In response to Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tom Lane wrote:
 > Gastón Simone wrote:
 > > 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.

Oops ...  Please disregard my previous mail.

I was obviously confusing SQL CURSORs and the cursor objects
used in the API of some programming languages (like Python).
Those are really somewhat different thigns.

Regards
   Oliver

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"Documentation is like sex; when it's good, it's very, very good,
and when it's bad, it's better than nothing."
        -- Dick Brandon

pgsql-novice by date:

Previous
From: Oliver Fromme
Date:
Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Next
From: Pei-Chieh Shen
Date:
Subject: Psql syntax run within java code