Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f46GMfA57431 for ; Sun, 6 May 2001 12:22:41 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f46GMFR28613; Sun, 6 May 2001 12:22:16 -0400 (EDT) To: "guard" cc: pgsql-sql@postgresql.org Subject: Re: update error In-reply-to: <9d3ngp$2p63$1@news.tht.net> References: <9d3ngp$2p63$1@news.tht.net> Comments: In-reply-to "guard" message dated "Sun, 06 May 2001 22:43:15 +0800" Date: Sun, 06 May 2001 12:22:14 -0400 Message-ID: <28610.989166134@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/40 X-Sequence-Number: 2841 "guard" writes: > update table_a set trn_no = table_b.trn_no from table_a,table_b > where table_a.cust_no=table_b.cust_no > IN pgsql 7.0x IS OK > if run 7.1 IS error ?? More details please? regards, tom lane