Re: [WIP] shared row locks - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: [WIP] shared row locks
Date
Msg-id 4248E0D7.80901@familyhealth.com.au
Whole thread Raw
In response to [WIP] shared row locks  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-patches
> I implemented the user-visible side of this (FKs in particular) using a
> new "FOR SHARE" clause to SELECT.  This is of course open to
> suggestions.  Inside the grammar I hacked it using the productions for
> FOR UPDATE, and stashed a String as the first node of the relid List.

Well MySQL uses "IN SHARE MODE"...

http://dev.mysql.com/doc/mysql/en/innodb-locking-reads.html

Chris

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [WIP] shared row locks
Next
From: Robert Creager
Date:
Subject: Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',