Re: Template1 is locked when pgAdminIII is open - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Template1 is locked when pgAdminIII is open
Date
Msg-id 20050131174859.GA9434@dcc.uchile.cl
Whole thread Raw
In response to Re: Template1 is locked when pgAdminIII is open  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Template1 is locked when pgAdminIII is open  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Mon, Jan 31, 2005 at 12:29:12PM -0500, Tom Lane wrote:

> Of course, sooner or later we should fix the underlying locking
> mechanism so we don't have to have this constraint, but I'm not sure
> when that will happen.

Hm, can we use LockSharedObject?  It's on my shared dependency patch.

What needs to be locked?  Maybe we need to take a AccessShareLock on the
pg_database row for schema changes, and AccessExclusiveLock on same for
database creation.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Template1 is locked when pgAdminIII is open
Next
From: Tom Lane
Date:
Subject: Re: Template1 is locked when pgAdminIII is open