Re: [GENERAL] Seeing uncommitted transactions

2004-06-28 Thread Tom Lane
"Carl E. McMillin" <[EMAIL PROTECTED]> writes: > BTW, it might be nice to give the backends a diagnostic port for "remote > debugging" in similar wise as the Java Virtual Machine provides so that some > degree of live-time workflow examination can happen. What do you > think? It's called gdb ;-

Re: [GENERAL] Seeing uncommitted transactions

2004-06-28 Thread Carl E. McMillin
you think? Carl <|};-)> -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Atkins Sent: Monday, June 28, 2004 1:34 PM To: [EMAIL PROTECTED] Subject: [GENERAL] Seeing uncommitted transactions Is there any way to look at the database as though you wer

Re: [GENERAL] Seeing uncommitted transactions

2004-06-28 Thread Alvaro Herrera
On Mon, Jun 28, 2004 at 01:33:33PM -0700, Steve Atkins wrote: > Is there any way to look at the database as though you were inside another > sessions transaction? Not currently. Maybe actually you _could_ do it with a C function, but it will require a lot of backend internal knowledge. -- Alvar

[GENERAL] Seeing uncommitted transactions

2004-06-28 Thread Steve Atkins
Is there any way to look at the database as though you were inside another sessions transaction? I've had two cases recently where this would have been somewhat useful. In one, a select into query ran for several hours and it would have been nice to see that it was running correctly. In the other