I thought the COMMIT SQL command closes every opened cursor when it's
Am I wrong?
So, what is the command that closes every opened cursor by default?
Thanks a lot!!
----- Original Message -----
From: "Oliver Fromme" <olli(at)lurza(dot)secnetix(dot)de>
To: "Gastón Simone" <gaston(at)apraful(dot)com(dot)uy>
Sent: Wednesday, May 05, 2004 4:03 PM
Subject: Re: [NOVICE] Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS
> Gastón Simone wrote:
> > Can I Commit a transaction without closing my cursors??
> Maybe I'm totally misinterpreting your question, but what
> is wrong with using the "COMMIT" SQL command? It commits
> the current transaction, and of course it doesn't close
> the cursor (why should it?).
> Best regards
> 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.
> "C is quirky, flawed, and an enormous success."
> -- Dennis M. Ritchie.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-05-06 13:06:29|
|Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!! |
|Previous:||From: Pei-Chieh Shen||Date: 2004-05-06 04:21:35|
|Subject: Psql syntax run within java code|