Re: this is in plain text (row level locks) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: this is in plain text (row level locks)
Date
Msg-id 200307310449.h6V4nt612651@candle.pha.pa.us
Whole thread Raw
In response to Re: this is in plain text (row level locks)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I was thinking of adding to TODO:
> >     * Allow shared row locks for referential integrity
> > but how is that different from:
> >     * Implement dirty reads and use them in RI triggers
> 
> It'd be a completely different approach to solving the FK locking
> problem.  I wouldn't think we'd do both.
> 
> Personally I'd feel more comfortable with a shared-lock approach, if we
> could work out the scalability issues.  Dirty reads seem ... well ...
> dirty.

TODO updated:
* Implement dirty reads or shared locks and use them in RI  triggers


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: autocommit in 7.4
Next
From: Bruce Momjian
Date:
Subject: Re: autocommit in 7.4