Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA27250 for ; Sun, 27 Feb 2000 18:43:08 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id SAA19672; Sun, 27 Feb 2000 18:41:39 -0500 (EST) To: maillist@remo.demon.co.uk cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Rule (which multiple actions) problem with history table..... In-reply-to: <20000227224531.A27483@pawprint.colloquium.co.uk> References: <20000227224531.A27483@pawprint.colloquium.co.uk> Comments: In-reply-to maillist@remo.demon.co.uk message dated "Sun, 27 Feb 2000 22:45:31 +0000" Date: Sun, 27 Feb 2000 18:41:39 -0500 Message-ID: <19669.951694899@sss.pgh.pa.us> From: Tom Lane maillist@remo.demon.co.uk writes: > The problem is with the rule on update. > This fails with the error... > ERROR: INSERT has more expressions than target columns FWIW, this seems to work fine in current sources (7.0beta1). It's difficult to muster much enthusiasm for figuring out why it was broken in 6.5... regards, tom lane