search

mantisbt-plugins / timetracking

Other
27 stars 43 forks source link

'user' and 'timestamp' are reserved words in postrges #14

Closed angmac closed 6 years ago

angmac commented 10 years ago

Mantis translate the schema definition to the following: CREATE TABLE mantis_plugin_TimeTracking_data_table ( id SERIAL, bug_id INTEGER DEFAULT NULL, user INTEGER DEFAULT NULL, expenditure_date TIMESTAMP DEFAULT NULL, hours FLOAT8 DEFAULT NULL, timestamp TIMESTAMP DEFAULT NULL, info VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id) ) and because user and timestamp are reserved words in postgres it throws error.

grangeway commented 10 years ago

We should add some "keywords" handling functionlity to the new db layer to block them being used in table/column definitions within mantis -this would then avoid these sorts of issues.

dregad commented 6 years ago

Closing as duplicate of #36