The following bug has been logged online: Bug reference: 1293 Logged by: Alexander Kirpa
Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend