pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedInsert row in 1.10.1 and 1.10.3
6+ messages / 4 participants
[nested] [flat]
* Insert row in 1.10.1 and 1.10.3
@ 2010-11-26 16:22 ndias <nun0_dias@hotmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: ndias @ 2010-11-26 16:22 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Insert row in 1.10.1 and 1.10.3
@ 2010-11-26 16:52 Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt>
parent: ndias <nun0_dias@hotmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Oliveiros d'Azevedo Cristina @ 2010-11-26 16:52 UTC (permalink / raw)
To: ndias <nun0_dias@hotmail.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Insert row in 1.10.1 and 1.10.3
@ 2010-11-26 17:09 ndias <nun0_dias@hotmail.com>
parent: Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt>
0 siblings, 0 replies; 6+ messages in thread
From: ndias @ 2010-11-26 17:09 UTC (permalink / raw)
To: pgsql-sql
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 values to be 1 more. Different
application dlls version between client and test environment...
Sorry to trouble you and thanks again.
Best regards,
Nuno
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Insert-row-in-1-10-1-and-1-10-3-tp3281512p3281562.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Insert row in 1.10.1 and 1.10.3
@ 2010-11-26 17:14 Thomas Kellerer <spam_eater@gmx.net>
parent: ndias <nun0_dias@hotmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Thomas Kellerer @ 2010-11-26 17:14 UTC (permalink / raw)
To: pgsql-sql
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 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.
What versions are you talking about?
PostgreSQL is currently at 9.0.1, the previous version was 8.4.something
I doubt there ever was a Version 1.10.3 of PostgreSQL
Regards
Thomas
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Insert row in 1.10.1 and 1.10.3
@ 2010-11-26 17:25 Guillaume Lelarge <guillaume@lelarge.info>
parent: Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Guillaume Lelarge @ 2010-11-26 17:25 UTC (permalink / raw)
To: Thomas Kellerer <spam_eater@gmx.net>; +Cc: pgsql-sql
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"
>> (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.
>
>
> What versions are you talking about?
> PostgreSQL is currently at 9.0.1, the previous version was 8.4.something
> I doubt there ever was a Version 1.10.3 of PostgreSQL
>
This looks like a pgAdmin release. There was a 1.10.1 and a 1.10.3,
which are a bit old now, and unmaintained.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Insert row in 1.10.1 and 1.10.3
@ 2010-11-26 17:28 ndias <nun0_dias@hotmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 6+ messages in thread
From: ndias @ 2010-11-26 17:28 UTC (permalink / raw)
To: pgsql-sql
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.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-11-26 17:28 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-26 16:22 Insert row in 1.10.1 and 1.10.3 ndias <nun0_dias@hotmail.com>
2010-11-26 16:52 ` Oliveiros d'Azevedo Cristina <oliveiros.cristina@marktest.pt>
2010-11-26 17:09 ` ndias <nun0_dias@hotmail.com>
2010-11-26 17:14 ` Thomas Kellerer <spam_eater@gmx.net>
2010-11-26 17:25 ` Guillaume Lelarge <guillaume@lelarge.info>
2010-11-26 17:28 ` ndias <nun0_dias@hotmail.com>
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