I thought the COMMIT SQL command closes every opened cursor when it's
executed!!
Am I wrong?
So, what is the command that closes every opened cursor by default?
Thanks a lot!!
Regards,
Gastón.
----- Original Message -----
From: "Oliver Fromme" <olli@lurza.secnetix.de>
To: "Gastón Simone" <gaston@apraful.com.uy>
Cc: <pgsql-novice@postgresql.org>
Sent: Wednesday, May 05, 2004 4:03 PM
Subject: Re: [NOVICE] Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS
OPEN!!
>
> 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?).
>
> http://www.postgresql.org/docs/7.4/static/sql-commit.html
>
> Best 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.
>
> "C is quirky, flawed, and an enormous success."
> -- Dennis M. Ritchie.