From: ndias <nun0_dias@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Insert row in 1.10.1 and 1.10.3
Date: Fri, 26 Nov 2010 08:22:42 -0800 (PST)
Message-ID: <1290788562014-3281512.post@n5.nabble.com> (raw)
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.
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: nun0_dias@hotmail.com
Subject: Re: Insert row in 1.10.1 and 1.10.3
In-Reply-To: <1290788562014-3281512.post@n5.nabble.com>
* 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