Hi,
I encountered a strange problem while trying to solve a bug. I use a
postgresql 8.x database and a jdbc driver from
postgresql-8.1dev-400.jdbc3.jar. The following is happening
The table is created like
create table test (
field1 int8 not null,
field2 int8 not null);
if I do a
select field1 from test;
results are returned normal, no problems at all, but when i do a
insert into test (field2, field1) values (1, 2);
It complains that field1 doesn't exists.
Has anyone encountered this same problem or does have anyone a pointer
for a bit more info on this problem?
Thanks,
Johan
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
