[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnue-dev] GEAS Error interpreting object attributes as SQL reserved wor
From: |
Neil Tiffin |
Subject: |
[Gnue-dev] GEAS Error interpreting object attributes as SQL reserved words. |
Date: |
Sun, 24 Feb 2002 11:46:56 -0500 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gnue-dev] GEAS Error interpreting object attributes as SQL reserved words.,
Neil Tiffin <=