BUG #1293: INSERT INTO test (f1.f2) VALUES (1,2) - wrong diagnostic
The following bug has been logged online:
Bug reference: 1293
Logged by: Alexander Kirpa
Email address: postgres@bilteks.com
PostgreSQL version: 8.0 Beta
Operating system: FreeBSD
Description: INSERT INTO test (f1.f2) VALUES (1,2) - wrong diagnostic
Details:
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
select f1.f2 from test;
relation "f1" does not exist
Wrong diagnostic for INSERT
"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