pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedauto-commit
5+ messages / 4 participants
[nested] [flat]
* auto-commit
@ 2003-04-03 07:23 Hugh Krenske <hkrenske@tellsystems.com.au>
0 siblings, 2 replies; 5+ messages in thread
From: Hugh Krenske @ 2003-04-03 07:23 UTC (permalink / raw)
To: pgsql-sql
I have a need to turn auto-commit off. I am using windows programs and my
code has to run against other DBMS as well.
How can I turn auto-commit off. I can find no reference to this in the
documentation.
Thank you
Hubert Krenske
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: auto-commit
@ 2003-04-03 17:09 chester c young <chestercyoung@yahoo.com>
parent: Hugh Krenske <hkrenske@tellsystems.com.au>
1 sibling, 1 reply; 5+ messages in thread
From: chester c young @ 2003-04-03 17:09 UTC (permalink / raw)
To: pgsql-sql
> I have a need to turn auto-commit off.
>
> Thank you
>
> Hubert Krenske
bracket your transaction with:
begin
<dml>
end;
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: auto-commit
@ 2003-04-03 17:34 Victor Yegorov <viy@pirmabanka.lv>
parent: chester c young <chestercyoung@yahoo.com>
0 siblings, 1 reply; 5+ messages in thread
From: Victor Yegorov @ 2003-04-03 17:34 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; +Cc: pgsql-sql
* chester c young <chestercyoung@yahoo.com> [03.04.2003 20:23]:
> > I have a need to turn auto-commit off.
> >
> > Thank you
> >
> > Hubert Krenske
>
> bracket your transaction with:
>
> begin
> <dml>
> end;
May be
begin
<dml>
<commit>|<rollback> ?!
--
Victor Yegorov
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: auto-commit
@ 2003-04-03 18:38 Victor Yegorov <viy@pirmabanka.lv>
parent: Victor Yegorov <viy@pirmabanka.lv>
0 siblings, 0 replies; 5+ messages in thread
From: Victor Yegorov @ 2003-04-03 18:38 UTC (permalink / raw)
To: chester c young <chestercyoung@yahoo.com>; +Cc: pgsql-sql
* chester c young <chestercyoung@yahoo.com> [03.04.2003 21:02]:
> thanks! (duh)
Take a glance at configuration (postgresql.conf), it's possible to
disable auto-commit there. In that case you'll need to commit/rollback all
queries (just like in Oracle).
--
Victor Yegorov
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: auto-commit
@ 2003-04-10 09:12 Olleg Samojlov <olleg@telecom.mipt.ru>
parent: Hugh Krenske <hkrenske@tellsystems.com.au>
1 sibling, 0 replies; 5+ messages in thread
From: Olleg Samojlov @ 2003-04-10 09:12 UTC (permalink / raw)
To: pgsql-sql
May be you have old version. In 7.3 exist set autocommit off
Hugh Krenske wrote:
> I have a need to turn auto-commit off. I am using windows programs and my
> code has to run against other DBMS as well.
>
> How can I turn auto-commit off. I can find no reference to this in the
> documentation.
>
> Thank you
>
> Hubert Krenske
>
>
--
Olleg Samojlov
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-04-10 09:12 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-03 07:23 auto-commit Hugh Krenske <hkrenske@tellsystems.com.au>
2003-04-03 17:09 ` chester c young <chestercyoung@yahoo.com>
2003-04-03 17:34 ` Victor Yegorov <viy@pirmabanka.lv>
2003-04-03 18:38 ` Victor Yegorov <viy@pirmabanka.lv>
2003-04-10 09:12 ` Olleg Samojlov <olleg@telecom.mipt.ru>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox