[Gnue-dev] GEAS Error interpreting object attributes as SQL reserved words.

[Neil Tiffin]

error: [postgresql.c/878] [postgresql_update_tables] [create table 
language__help (sys_id char(32) , sys_cre_user varchar(16) , 
sys_cre_time datetime , sys_mod_user varchar(16) , sys_mod_time 
datetime , _language char(32) , code varchar(8) , dialect varchar(8) 
, name varchar(255) , company varchar(15) , user_group varchar(15) , 
user varchar(15) , help_text varchar(2000) , help_keywords 
varchar(100) , tool_tip text , label text , long_label text , 
short_label text , default_text text , primary key (sys_id) )] failed
error: [postgresql.c/879] [postgresql_update_tables] ERROR:  parser: 
parse error at or near "user"

Had to change language::help from:

    char  user_group<15>;     # if empty this change applies to all groups.
    char  user<15>;           # if empty this change applies to all users.

to:

    char  usr_group<15>;     # if empty this change applies to all groups.
    char  usr<15>;           # if empty this change applies to all users.

the field user was being interpreted as a reserved word.  The words 
effected seem to be
end, user, group, natural, left.

Neil