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

On Wed, 2006-09-20 at 16:29, Johan wrote:
> 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?

What happens if you run those commands from psql?  They work fine for me
in pg 7.4 and 8.1 from psql.

Have you got an example in java that causes this you can show?