Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3C1171337B43 for ; Fri, 26 Nov 2010 13:15:05 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 54025-04 for ; Fri, 26 Nov 2010 17:14:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mail.postgresql.org (Postfix) with ESMTP id CB801133798E for ; Fri, 26 Nov 2010 13:14:57 -0400 (AST) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1PM1st-0002Ru-UX for pgsql-sql@postgresql.org; Fri, 26 Nov 2010 18:14:55 +0100 Received: from h-213.61.77.202.host.de.colt.net ([213.61.77.202]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 26 Nov 2010 18:14:55 +0100 Received: from spam_eater by h-213.61.77.202.host.de.colt.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 26 Nov 2010 18:14:55 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Thomas Kellerer Subject: Re: Insert row in 1.10.1 and 1.10.3 Date: Fri, 26 Nov 2010 18:14:46 +0100 Lines: 15 Message-ID: References: <1290788562014-3281512.post@n5.nabble.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: h-213.61.77.202.host.de.colt.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 In-Reply-To: <1290788562014-3281512.post@n5.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/75 X-Sequence-Number: 34813 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 Regards Thomas