Re: [GENERAL] How can you have an Exclusive Lock on nothing? please help me understand this lock monitoring query output

2011-04-15 Thread Simon Riggs
On Fri, Apr 15, 2011 at 2:12 AM, Aleksey Tsalolikhin atsaloli.t...@gmail.com wrote: Hi.  I use the following query (from http://wiki.postgresql.org/wiki/Lock_Monitoring) to monitor locks; and I've got an ExlusiveLock that does not have a relation name associated with it.  What is locked with

[GENERAL] How can you have an Exclusive Lock on nothing? please help me understand this lock monitoring query output

2011-04-14 Thread Aleksey Tsalolikhin
Hi. I use the following query (from http://wiki.postgresql.org/wiki/Lock_Monitoring) to monitor locks; and I've got an ExlusiveLock that does not have a relation name associated with it. What is locked with the Exclusive Lock in this case, please? (it's between d and e tables below) psql -U

Re: [GENERAL] How can you have an Exclusive Lock on nothing? please help me understand this lock monitoring query output

2011-04-14 Thread Jerry Sievers
Aleksey Tsalolikhin atsaloli.t...@gmail.com writes: Hi. I use the following query (from http://wiki.postgresql.org/wiki/Lock_Monitoring) to monitor locks; and I've got an ExlusiveLock that does not have a relation name associated with it. What is locked with the Exclusive Lock in this case,