From: | "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org> |
---|---|
To: | Mario Weilguni <mweilguni(at)sime(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Query precompilation? |
Date: | 2001-02-27 21:56:47 |
Message-ID: | Pine.LNX.4.21.0102271549550.12003-100000@morannon.the-infinite.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Tue, 27 Feb 2001, Mario Weilguni wrote:
> Thanks for the answer, but that's not disabling autocommit, it committing by
> hand. What I mean ist Oracle-behaviour --> everthing is a transaction and
> must be commited by "COMMIT". What I ment was something like "SET autocommit
> to OFF" or something like this.
Everything _is_ a transaction - the BEGIN ... COMMIT is implied, if you
don't wrap your SQL statements in BEGIN ... COMMIT.
Compare:
dominic=# INSERT INTO pages ( page_from, page_to, page_data ) VALUES ( 'Dominic', '555-1212', 'This is a test page');
INSERT 945129 1
[ This was one transaction ]
dominic=# SELECT count(*) FROM pages;
count
-------
1
(1 row)
[ This was the second transaction ]
... for a total of two transactions, as opposed to:
dominic=# BEGIN;
BEGIN
dominic=# INSERT INTO pages ( page_from, page_to, page_data ) VALUES ( 'Dominic', '555-1212', 'Test page number two.' );
INSERT 945130 1
dominic=# SELECT count(*) FROM pages;
count
-------
2
(1 row)
dominic=# COMMIT;
COMMIT
[ This was just _one_ transaction ]
--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
From | Date | Subject | |
---|---|---|---|
Next Message | will trillich | 2001-02-27 22:06:03 | upgrade broke stuff, downgrade still broke |
Previous Message | Mario Weilguni | 2001-02-27 21:37:46 | Re: Re: Query precompilation? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-02-27 22:04:21 | Database Internals Presentation |
Previous Message | Mario Weilguni | 2001-02-27 21:37:46 | Re: Re: Query precompilation? |