Skip site navigation (1) Skip section navigation (2)

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

From: Gastón Simone <gaston(at)apraful(dot)com(dot)uy>
To: "Oliver Fromme" <olli(at)lurza(dot)secnetix(dot)de>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Date: 2004-05-06 12:47:53
Message-ID: 000b01c43368$59c64d40$4101070a@adinet (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)lurza(dot)secnetix(dot)de>
To: "Gastón Simone" <gaston(at)apraful(dot)com(dot)uy>
Cc: <pgsql-novice(at)postgresql(dot)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.


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2004-05-06 13:06:29
Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Previous:From: Pei-Chieh ShenDate: 2004-05-06 04:21:35
Subject: Psql syntax run within java code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group