On Fri, Apr 15, 2011 at 2:12 AM, Aleksey Tsalolikhin <atsaloli.tech@xxxxxxxxx> 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 the Exclusive Lock in this case, > please? (it's between "d" and "e" tables below) Locks can be held on databases, relations, rows and also show for transactions. So the absence of a relation name just means it is one of the other kinds of lock. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
