Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Template1 is locked when pgAdminIII is open
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
- Cc: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, Mehul Doshi-A20614 <mehul(at)motorola(dot)com>, pgsql-bugs(at)postgresql(dot)org
- Subject: Re: Template1 is locked when pgAdminIII is open
- Date: Mon, 31 Jan 2005 13:04:21 -0500
- Message-id: <21067.1107194661@sss.pgh.pa.us> <text/plain>
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes: > 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. > What needs to be locked? Somehow we'd need to prevent any changes to the template database while it's being copied. AFAICS this would require something on the order of taking out a lock at the database level for every query, which sounds like a mighty expensive solution compared to the seriousness of the problem. regards, tom lane
- References:
- Re: Template1 is locked when pgAdminIII is open
- From: Dave Page
- Re: Template1 is locked when pgAdminIII is open
- From: Tom Lane
- Re: Template1 is locked when pgAdminIII is open
- From: Alvaro Herrera
- Re: Template1 is locked when pgAdminIII is open
- Prev by Date: Re: Template1 is locked when pgAdminIII is open
- Next by Date: Re: Template1 is locked when pgAdminIII is open
- Previous by thread: Re: Template1 is locked when pgAdminIII is open
- Next by thread: Re: Template1 is locked when pgAdminIII is open
- Indexes: