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