On Wed, Sep 20, 2006 at 02:29:16PM -0700, Johan wrote: > 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 Any reason you're not using the latest, postgresql-8.1-407.jdbc3.jar? > 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. I can't reproduce this problem; could you post a complete test case? Do you see the problem if you execute the same statements in psql? -- Michael Fuhr
