Re: Problem with inherited table, can you help?... - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Problem with inherited table, can you help?...
Date
Msg-id 20050311142351.GC3823@dcc.uchile.cl
Whole thread Raw
In response to Re: Problem with inherited table, can you help?...  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-general
On Fri, Mar 11, 2005 at 06:16:28PM +1100, Russell Smith wrote:
> On Fri, 11 Mar 2005 03:39 am, Michael Fuhr wrote:
> > On Thu, Mar 10, 2005 at 01:31:21AM -0800, Net Virtual Mailing Lists wrote:
>
> > Some have suggested that PostgreSQL should use a weaker lock on the
> > referenced key, but that hasn't been implemented yet.
>
> Are there actually any problems with only getting a AccessShareLock?

Yes, because there is no infrastructure to get any type of lock save
an exclusive lock (not sure to which lmgr lock type is equivalent) on a
per-row basis.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Ni aun el genio muy grande llegaría muy lejos
si tuviera que sacarlo todo de su propio interior" (Goethe)

pgsql-general by date:

Previous
From: "GIROIRE Nicolas (COFRAMI)"
Date:
Subject: Re: Convert Cursor to array
Next
From: Együd Csaba
Date:
Subject: Best practices: Handling Daylight-saving time