You are both right, the Postgres version is 8.4, 1.10.3 is the pgAdmin
version.
Sorry the trouble, as you can see I am a newbie at Postgres. :)
Best to all,
Nuno Dias
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Insert-row-in-1-10-1-and-1-10-3-tp3281512p3281580.htm
Le 26/11/2010 18:14, Thomas Kellerer a écrit :
> 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
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 exac
Oliveiros,
Thank you for your reply.
I was debugging and printing the query also for myself and it was indeed
something I was missing. The COM where the query is done was correct in
number of values but the last field had a wrong value and was arriving there
with a ',' in it, which caused the va
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
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