From: Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt>
To: ndias <nun0_dias@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Insert row in 1.10.1 and 1.10.3
Date: Fri, 26 Nov 2010 16:52:37 -0000
Message-ID: <EE763B73452B4102BE8564F52C58517F@marktestcr.marktest.pt> (raw)
References: <1290788562014-3281512.post@n5.nabble.com>
Could you please
include the full insert SQL statement?
Best,
Oliveiros
----- Original Message -----
From: "ndias" <nun0_dias@hotmail.com>
To: <pgsql-sql@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oliveiros.cristina@marktest.pt, nun0_dias@hotmail.com
Subject: Re: Insert row in 1.10.1 and 1.10.3
In-Reply-To: <EE763B73452B4102BE8564F52C58517F@marktestcr.marktest.pt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox