Re: Re: Query precompilation?

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/