Re: [HACKERS] second "begin transaction" emits a warning

2005-12-16 Thread Robert Treat
On Fri, 2005-12-16 at 17:36, Jaime Casanova wrote: > Hi, > > recently someone show us this code in the spanish list... > > > BEGIN WORK; > > INSERT INTO mitabla VALUES (1); > >BEGIN TRANSACTION; > > INSERT INTO mitabla VALUES (2); > > INSERT INTO mitabla VALUES (3); > >COMMIT TRAN

Re: [HACKERS] second "begin transaction" emits a warning

2005-12-16 Thread Tom Lane
Jaime Casanova <[EMAIL PROTECTED]> writes: > recently someone show us this code in the spanish list... >> BEGIN WORK; >> INSERT INTO mitabla VALUES (1); >> BEGIN TRANSACTION; >> INSERT INTO mitabla VALUES (2); >> INSERT INTO mitabla VALUES (3); >> COMMIT TRANSACTION; >> INSERT INTO mitabla VALUES

[HACKERS] second "begin transaction" emits a warning

2005-12-16 Thread Jaime Casanova
Hi, recently someone show us this code in the spanish list... > BEGIN WORK; > INSERT INTO mitabla VALUES (1); >BEGIN TRANSACTION; > INSERT INTO mitabla VALUES (2); > INSERT INTO mitabla VALUES (3); >COMMIT TRANSACTION; > INSERT INTO mitabla VALUES (4); > ROLLBACK WORK; this is cl