Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D22666325D7 for ; Sun, 19 Apr 2009 06:26:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78813-07 for ; Sun, 19 Apr 2009 06:26:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og122.obsmtp.com (exprod7og122.obsmtp.com [64.18.2.22]) by mail.postgresql.org (Postfix) with SMTP id 010936345F7 for ; Sun, 19 Apr 2009 04:41:59 -0300 (ADT) Received: from source ([209.85.218.171]) by exprod7ob122.postini.com ([64.18.6.12]) with SMTP ID DSNKSerVxhmrORBAFjBdH7S+NsBWw6LbJCJv@postini.com; Sun, 19 Apr 2009 00:42:00 PDT Received: by bwz19 with SMTP id 19so1751461bwz.4 for ; Sun, 19 Apr 2009 00:41:57 -0700 (PDT) Received: by 10.103.160.3 with SMTP id m3mr2378875muo.25.1240126917811; Sun, 19 Apr 2009 00:41:57 -0700 (PDT) Received: from ?85.77.211.113? (YKMMDCCCXII.gprs.sl-laajakaista.fi [85.77.211.113]) by mx.google.com with ESMTPS id j2sm10396245mue.19.2009.04.19.00.41.53 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 19 Apr 2009 00:41:57 -0700 (PDT) Message-ID: <49EAD5A6.4010601@enterprisedb.com> Date: Sun, 19 Apr 2009 10:41:26 +0300 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103) MIME-Version: 1.0 To: KaiGai Kohei CC: Tom Lane , KaiGai Kohei , pgsql-hackers@postgresql.org Subject: Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE References: <49E809F6.8070008@ak.jp.nec.com> <49E8133A.7090601@enterprisedb.com> <49E81EA1.2060202@ak.jp.nec.com> <20069.1239977115@sss.pgh.pa.us> <49E91AE4.9020404@kaigai.gr.jp> <49E974AD.3020602@enterprisedb.com> <13982.1240056219@sss.pgh.pa.us> <49E9D5B6.9050406@enterprisedb.com> <49EA7E4D.6060109@kaigai.gr.jp> In-Reply-To: <49EA7E4D.6060109@kaigai.gr.jp> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200904/989 X-Sequence-Number: 137092 KaiGai Kohei wrote: > However, ACL_UPDATE and ACL_SELECT_FOR_UPDATE internally shares same bit > so SE-PostgreSQL cannot discriminate between UPDATE and SELECT FOR UPDATE > or SHARE. Why should it discriminate between them? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com