Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-09-05 Thread Owen Hartnett
At 12:41 PM -0400 9/5/07, Owen Hartnett wrote: At 11:32 AM -0400 9/5/07, Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Owen Hartnett wrote: I've been able to turn on statement logging (I've set log_statement to 'all'), but it doesn't seem to show the begin transaction - commit

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-09-05 Thread Owen Hartnett
At 11:32 AM -0400 9/5/07, Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Owen Hartnett wrote: I've been able to turn on statement logging (I've set log_statement to 'all'), but it doesn't seem to show the begin transaction - commit - rollback statements. Is there another way to

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-09-05 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> In PG 8.2 I'd agree, but older versions are not so good about logging >> execution of prepared statements. What's the server version exactly, >> and is there any indication of use of prepared statements in the log? > Humm, but can yo

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-09-05 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Owen Hartnett wrote: > >> I've been able to turn on statement logging (I've set log_statement to > >> 'all'), but it doesn't seem to show the begin transaction - commit - > >> rollback statements. Is there another way to have them

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-09-05 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Owen Hartnett wrote: >> I've been able to turn on statement logging (I've set log_statement to >> 'all'), but it doesn't seem to show the begin transaction - commit - >> rollback statements. Is there another way to have them show up in the log? > If

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-09-05 Thread Alvaro Herrera
Owen Hartnett wrote: > At 10:14 AM -0400 8/28/07, Owen Hartnett wrote: >> At 7:05 PM -0400 8/27/07, Tom Lane wrote: >>> Owen Hartnett <[EMAIL PROTECTED]> writes: I assign the transaction object to each of the commands, but it seems that some tables will get updated, even when I call rol

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-09-05 Thread Owen Hartnett
At 10:14 AM -0400 8/28/07, Owen Hartnett wrote: At 7:05 PM -0400 8/27/07, Tom Lane wrote: Owen Hartnett <[EMAIL PROTECTED]> writes: I assign the transaction object to each of the commands, but it seems that some tables will get updated, even when I call rollback. Is something I'm calling se

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-08-28 Thread Owen Hartnett
At 7:05 PM -0400 8/27/07, Tom Lane wrote: Owen Hartnett <[EMAIL PROTECTED]> writes: I assign the transaction object to each of the commands, but it seems that some tables will get updated, even when I call rollback. Is something I'm calling secretly calling "commit" somewhere? Dunno anythi

Re: [GENERAL] problem with transactions in VB.NET using npgsql

2007-08-27 Thread Tom Lane
Owen Hartnett <[EMAIL PROTECTED]> writes: > I assign the transaction object to each of the commands, but it seems > that some tables will get updated, even when I call rollback. Is > something I'm calling secretly calling "commit" somewhere? Dunno anything about vb.net, but this sounds like an

[GENERAL] problem with transactions in VB.NET using npgsql

2007-08-27 Thread Owen Hartnett
Maybe someone here can figure it out. Everything updates fine with this code, except where there's an exception, it's not rolling back by the transaction. What I'm trying to do: Begin a transaction Do the update, insert, delete checks on each of the data tables, using a different npgsqlcom

Re: [GENERAL] Problem with transactions

2007-03-27 Thread Richard Huxton
Matthijs Melissen wrote: I want two users to execute the following queries: 1) delete from forum where id = 'A'; 1) insert into forum (id, name) values ('A', 'testa'); 2) delete from forum where id = 'A'; 2) insert into forum (id, name) values ('A', 'testb'); id is a unique key. The numbers de

[GENERAL] Problem with transactions

2007-03-26 Thread Matthijs Melissen
I want two users to execute the following queries: 1) delete from forum where id = 'A'; 1) insert into forum (id, name) values ('A', 'testa'); 2) delete from forum where id = 'A'; 2) insert into forum (id, name) values ('A', 'testb'); id is a unique key. The numbers designate the user (1 and 2)