Received: from mail.astrofoto.org (dsl092-102-177.nyc2.dsl.speakeasy.net [66.92.102.177]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAFGOhm20080 for ; Thu, 15 Nov 2001 11:24:43 -0500 (EST) (envelope-from roland@astrofoto.org) Received: (from roland@localhost) by mail.astrofoto.org (8.11.6/8.11.6) id fAFGOmn15223; Thu, 15 Nov 2001 11:24:48 -0500 To: pgsql-sql@postgresql.org Subject: Re: Is this a bug? References: <9sqakt$op1$1@news.tht.net> <73t1vtk61pcsob9pa0p32a9eou3a31tolh@4ax.com> <9srnih$10qq$1@news.tht.net> From: Roland Roberts Date: 15 Nov 2001 11:24:47 -0500 In-Reply-To: <9srnih$10qq$1@news.tht.net> Message-ID: Lines: 18 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.0.105 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/214 X-Sequence-Number: 5597 >>>>> "Jack" == Jack Gao writes: Jack> So, I can't use JOIN in UPDATE? You are trying to update two different tables. Use a transaction instead. begin transaction; update foo ....; update bar ....; end transaction; roland -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD RL Enterprises roland@rlenter.com 76-15 113th Street, Apt 3B roland@astrofoto.org Forest Hills, NY 11375