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

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.