Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling

Christopher Kings-Lynne wrote:
> > OK, TODO updated:
> > 
> > * Implement dirty reads or shared row locks and use them in RI triggers
> 
> Can someone explain to me what a dirty read is and how it relates to RI 
> triggers?

Dirty read allows you to see uncommited rows.  I think RI triggers need
it so they can know if someone has a current transaction that is going
to conflict with the RI trigger action, or something like that.  Right
now I think we hang waiting for the transaction to complete.

--  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