Re: column names in select don't exists in insert to

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