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