Michael Fuhr schreef: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster Someone executed the query in psql for me and the problem seems to be in a stored procedure triggered after update. This procedure complains about the field. Thanks for the help. Johan
