column names in select don't exists in insert to

Поиск
Список
Период
Сортировка
От Johan
Тема column names in select don't exists in insert to
Дата
Msg-id 1158787754.755139.103960@m7g2000cwm.googlegroups.com
обсуждение исходный текст
Ответы Re: column names in select don't exists in insert to  (Michael Fuhr <mike@fuhr.org>)
Re: column names in select don't exists in insert to  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: stevethames
Дата:
Сообщение: IF EXISTS
Следующее
От: Najib Abi Fadel
Дата:
Сообщение: Re: What is the Best Postgresql Load Balancing Solution available ?