Si Chen <[EMAIL PROTECTED]> writes:
> Does anyone know of a way to go from transactions identifiers to the
> actual transaction--which tables, which statements, etc. etc.?
See pg_stat_activity.
The pg_locks entries you are looking at do *not* represent table locks
of any kind. This:
> NULL NULL
First of all, my apologies for posting it to 3 lists: I'm not sure if
this is an admin question, or I only have this question because I'm a
novice, or some combination thereof.
I have a table which appears to be locked on an INSERT. Looking in
pg_locks, I get the result (shown below). I can u
