[ADMIN] Locks with no database or relation

2008-03-18 Thread Julius Tuskenis
Hello. I see Exclusive lock on my server (using pgAdmin) but cant understand what does it lock, because Database and Relation fields are left blank. What does it mean? (Attaching screenshot). -- Julius Tuskenis inline: Lock.JPG -- Sent via pgsql-admin mailing list

Re: [ADMIN] Locks with no database or relation

2008-03-18 Thread Vishal Arora
use PgAdmin Support ([EMAIL PROTECTED]) mailing list for your query. Date: Tue, 18 Mar 2008 16:46:50 +0200 From: [EMAIL PROTECTED] To: pgsql-admin@postgresql.org Subject: [ADMIN] Locks with no database or relation Hello. I see Exclusive lock on my server (using pgAdmin) but cant

[ADMIN] Locks

2003-10-15 Thread Greg Spiegelberg
Is there a good all-inclusive resource out there that documents LOCK in PostgreSQL, any side-effects when used, and how UPDATE, DELETE, cursors, transactions, and so on use them? Thanks, Greg -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax:

[ADMIN] Locks on Tables

2002-02-21 Thread Antony Stace
Hi How can I see if there is a lock on a table or row of a table? -- Cheers Tony。 - _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com