Re: BUG #1293: INSERT INTO test (f1.f2) VALUES (1,2) - wrong diagnostic - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1293: INSERT INTO test (f1.f2) VALUES (1,2) - wrong diagnostic
Date
Msg-id 8488.1098671985@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1293: INSERT INTO test (f1.f2) VALUES (1,2) - wrong diagnostic  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> create table test(f1 int4,f2 int4);
> insert into test (f1.f2) values (1,2);
> ERROR:  cannot assign to a column of type integer because it is not a
> composite type

This diagnostic is not wrong.  It might be a tad unhelpful, but I don't
think it's within the province of the parser to intuit that you meant to
type a comma instead of a period.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1293: INSERT INTO test (f1.f2) VALUES (1,2) - wrong diagnostic
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1294: Random errors (failed connection)