| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, Net Virtual Mailing Lists <mailinglists(at)net-virtual(dot)com>, Pgsql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem with inherited table, can you help?... |
| Date: | 2005-03-11 14:23:51 |
| Message-ID: | 20050311142351.GC3823@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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[(at)]dcc(dot)uchile(dot)cl>)
"Ni aun el genio muy grande llegaría muy lejos
si tuviera que sacarlo todo de su propio interior" (Goethe)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Együd Csaba | 2005-03-11 14:25:28 | Best practices: Handling Daylight-saving time |
| Previous Message | GIROIRE Nicolas (COFRAMI) | 2005-03-11 14:12:01 | Re: Convert Cursor to array |