Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 01B751337B43 for ; Fri, 26 Nov 2010 12:52:46 -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 96812-08 for ; Fri, 26 Nov 2010 16:52:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from jupiter.marktest.pt (delta.marktest.pt [80.251.174.116]) by mail.postgresql.org (Postfix) with ESMTP id 534D51337B4A for ; Fri, 26 Nov 2010 12:52:37 -0400 (AST) Received: from Proteu (proteu.marktest.pt [10.61.90.54]) by jupiter.marktest.pt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id W4GBQCB5; Fri, 26 Nov 2010 16:52:36 -0000 Message-ID: From: "Oliveiros d'Azevedo Cristina" To: "ndias" , References: <1290788562014-3281512.post@n5.nabble.com> Subject: Re: Insert row in 1.10.1 and 1.10.3 Date: Fri, 26 Nov 2010 16:52:37 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.349 tagged_above=-5 required=5 tests=BAYES_00=-1.9, STOX_REPLY_TYPE=0.439, T_RP_MATCHES_RCVD=-0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201011/73 X-Sequence-Number: 34811 Could you please include the full insert SQL statement? Best, Oliveiros ----- Original Message ----- From: "ndias" To: Sent: Friday, November 26, 2010 4:22 PM Subject: [SQL] Insert row in 1.10.1 and 1.10.3 > > Hello to all, > > I have a question regarding the behavior of insert row in the two > versions, > tried to search for it but could not find a similar case, please excuse if > this has already been responded. > > 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. > Do you think this is really a matter of the different versions or am I > missing something else? > If this is in fact due to the version, can I upgrade the version without > any > problem and is there any guide to do so? > > Have also confirmed that the values are as many as the columns specified > on > the "into table(col1, col2, col3,..."... > > Thank you very much. > > Best regards, > Nuno > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Insert-row-in-1-10-1-and-1-10-3-tp3281512p3281512.html > Sent from the PostgreSQL - sql mailing list archive at Nabble.com. > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql