id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 2097,"""User"" is a reserved keyword in Postgres.",anonymous,Colin Guthrie,"The `work_log` table contains a field named `user`. This is an SQL reserved keyword: * http://www.postgresql.org/docs/8.2/static/sql-keywords-appendix.html This means that when will not be able to `upgrade` the trac database after enable worklog, if you are using Postgres. The upgrade pretends to succeed but is in fact failing silently: {{{ [20071019-18:46:55]:[root@bugs]:[~]# trac-admin /var/trac/systems upgrade --no-backup Worklog needs an upgrade Upgrading Database Creating work_log table Done upgrading Worklog Upgrade done. [20071019-18:47:05]:[root@bugs]:[~]# trac-admin /var/trac/systems upgrade --no-backup Worklog needs an upgrade Upgrading Database Creating work_log table Done upgrading Worklog Upgrade done. }}} However: {{{ systems=# CREATE TABLE work_log ( systems(# user TEXT, systems(# ticket INTEGER, systems(# lastchange INTEGER, systems(# starttime INTEGER, systems(# endtime INTEGER, systems(# ); ERROR: syntax error at or near ""user"" at character 27 LINE 2: user TEXT, ^ systems=# }}}",defect,closed,high,WorkLogPlugin,blocker,fixed,,ecdpalma@…,0.10