Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 96D241337B4A for ; Fri, 26 Nov 2010 13:25:20 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 66371-07 for ; Fri, 26 Nov 2010 17:25:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id E83E2133798E for ; Fri, 26 Nov 2010 13:25:12 -0400 (AST) Received: from [192.168.42.162] (LCaen-151-93-7-26.w80-13.abo.wanadoo.fr [80.13.230.26]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id D36433B8F5; Fri, 26 Nov 2010 18:25:11 +0100 (CET) Message-ID: <4CEFED77.6060902@lelarge.info> Date: Fri, 26 Nov 2010 18:25:11 +0100 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); fr; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 MIME-Version: 1.0 To: Thomas Kellerer CC: pgsql-sql@postgresql.org Subject: Re: Insert row in 1.10.1 and 1.10.3 References: <1290788562014-3281512.post@n5.nabble.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.324 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_NJABL_PROXY=2.224 X-Spam-Level: X-Archive-Number: 201011/76 X-Sequence-Number: 34814 Le 26/11/2010 18:14, Thomas Kellerer a écrit : > ndias, 26.11.2010 17:22: >> When doing a insert row with less columns mentioned in "into table(col1, >> col2, col3,..." than the columns that exist on the table, on 1.10.1 it >> returns an error saying "INSERT has more expressions than target columns" >> (the error is translated so maybe the text is not exactly like this). >> Although, when this is insert is done on our test environment, where the >> version is 1.10.3 it works fine. The tables have the same columns and >> so on. > > > What versions are you talking about? > PostgreSQL is currently at 9.0.1, the previous version was 8.4.something > I doubt there ever was a Version 1.10.3 of PostgreSQL > This looks like a pgAdmin release. There was a 1.10.1 and a 1.10.3, which are a bit old now, and unmaintained. -- Guillaume http://www.postgresql.fr http://dalibo.com