| From: | Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!! |
| Date: | 2004-05-06 13:22:22 |
| Message-ID: | 200405061322.i46DMMeF008128@lurza.secnetix.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | joseph speigle | 2004-05-07 01:03:12 | Re: Psql syntax run within java code |
| Previous Message | Oliver Fromme | 2004-05-06 13:18:10 | Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!! |