Re: [WIP] shared row locks

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [WIP] shared row locks
Date: 2005-03-29 05:00:07
Message-ID: 4248E0D7.80901@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Dirk Raetzel 2005-03-29 05:43:53 Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',
Previous Message Alvaro Herrera 2005-03-29 04:36:22 Re: [WIP] shared row locks