Re: Insert row in 1.10.1 and 1.10.3

Could you please
include the full insert SQL statement?

Best,
Oliveiros

----- Original Message -----
From: "ndias" <nun0_dias(at)hotmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql