SQL INSERT bug with 6.5.3 and 7.0.2

Поиск
Список
Период
Сортировка
От John Gotts
Тема SQL INSERT bug with 6.5.3 and 7.0.2
Дата
Msg-id 200006252155.RAA31000@ww2.tqstats.com
обсуждение исходный текст
Ответы Re: SQL INSERT bug with 6.5.3 and 7.0.2
Re: SQL INSERT bug with 6.5.3 and 7.0.2
Список pgsql-general
We're experiencing a problem with the parser with both 6.5.3 and 7.0.2.

The following is with 7.0.2.  6.5.3 is similar.

umpire(rc3.d)% psql -u fmfts
psql: Warning: The -u option is deprecated. Use -U.
...
fmfts=# CREATE TABLE "contact_people" (
fmfts(#    "user_id" character(30),
fmfts(#   "account_id" character(30),
fmfts(#     "exchange_id" character(30),
fmfts(#    "isin_code" character(30),
fmfts(#    "symbol" character(30),
fmfts(#    "name" character(30),
fmfts(#    "position" character(30),
fmfts(#      "email_address" character(30));
CREATE
fmfts=# insert into contact_people (user_id,name,position,email_address) values ('jgotts','hello',null,null);
ERROR:  parser: parse error at or near "position"
fmfts=# insert into contact_people (user_id,name,"position",email_address) values ('jgotts','hello',null,null);
INSERT 20402 1

The problem also appears with libpq.

Any idea why this would occur?

John

--
John GOTTS <jgotts@linuxsavvy.com>  http://www.linuxsavvy.com/staff/jgotts

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

Предыдущее
От:
Дата:
Сообщение: Insert into a table with only a SERIAL
Следующее
От: John Gotts
Дата:
Сообщение: Re: SQL INSERT bug with 6.5.3 and 7.0.2