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

From: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
To: gaston(at)apraful(dot)com(dot)uy (=?iso-8859-1?Q?Gast=F3n_Simone?=)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!
Date: 2004-05-05 19:03:43
Message-ID: 200405051903.i45J3hMe075610@lurza.secnetix.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

Browse pgsql-novice by date

  From Date Subject
Next Message Pei-Chieh Shen 2004-05-06 04:21:35 Psql syntax run within java code
Previous Message Gastón Simone 2004-05-05 18:10:40 Hey Mr. PG! End my transaction, BUT KEEP MY CURSORS OPEN!!