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

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