column names in select don't exists in insert to

From: "Johan" <johan(dot)stover(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: column names in select don't exists in insert to
Date: 2006-09-20 21:29:16
Message-ID: 1158787754.755139.103960@m7g2000cwm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks,

Johan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Hallstrom 2006-09-20 21:38:33 Re: postgresql rising
Previous Message Terry Lee Tucker 2006-09-20 21:29:06 Re: Question Regarding a Temporary Table