Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by mail.postgresql.org (8.11.3/8.11.1) with SMTP id f2S6HIw74868 for ; Wed, 28 Mar 2001 01:17:18 -0500 (EST) (envelope-from Inoue@tpf.co.jp) Received: (qmail 24650 invoked from network); 28 Mar 2001 06:17:15 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.10.0.100.in-addr.arpa with SMTP; 28 Mar 2001 06:17:15 -0000 Received: from tpf.co.jp ([126.0.1.62]) by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id PAA01978; Wed, 28 Mar 2001 15:17:15 +0900 (JST) Message-ID: <3AC18259.C5A8B0A9@tpf.co.jp> Date: Wed, 28 Mar 2001 15:19:05 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Tom Lane CC: Philip Warner , pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 References: <01032713101600.07241@bartok> <01032713101600.07241@bartok> <3.0.5.32.20010328101405.02b57790@mail.rhyme.com.au> <16115.985739416@sss.pgh.pa.us> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/571 X-Sequence-Number: 2241 Tom Lane wrote: > > Philip Warner writes: > >> The workaround for Forest is to make the final SELECT be a SELECT FOR > >> UPDATE, so that it's playing by the same rules as the earlier commands. > > > Eek. Does this seem good to you? > > I did call it a workaround ;-) > > I don't think that we dare try to make any basic changes in MVCC for 7.1 > at this late hour, so Forest is going to have to live with that answer > for awhile. But I would like to see a cleaner answer in future > releases. Is it the MVCC's restriction that each query inside a function must use the same snapshot ? > As I've opined before, the whole EvalPlanQual mechanism > strikes me as essentially bogus in any case... > How would you change it ? UPDATE/SELECT FOR UPDATE have to SELECT/UPDATE the latest tuples. I don't think of any simple way for 'SELECT FOR UPDATE' to have the same visibility as simple SELECT. regards, Hiroshi Inoue