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 (<[EMAIL PROTECTED]>) "Ni aun el genio muy grande llegarķa muy lejos si tuviera que sacarlo todo de su propio interior" (Goethe) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly