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 по дате отправления: