xmera-circle / redmine_workload

[Fork] Calculate user workload over time
6 stars 3 forks source link

Using Postgres: table wl_national_holidays cannot be used: column END is a reserved keyword #16

Closed qbicode closed 1 year ago

qbicode commented 1 year ago

Hi team, I'm using postgres as database. I cannot usse the workload plugin, because the table wl_national_holidays is using the column name END. This is a resreved keyword in Postgres and produces an error:

ActiveRecord::StatementInvalid (PG::SyntaxError: ERROR: syntax error at or near "end" LINE 1: ...tional_holidays" WHERE (start <= '2022-12-26' AND end >= '20... ^ : SELECT 1 AS one FROM "wl_national_holidays" WHERE (start <= '2022-12-26' AND end >= '2022-12-26') LIMIT $1):

Could you please fix this? Cheers. Steffen

liaham commented 1 year ago

Hi Steffen,

Thank you very much for this information!

Would you mind to prepare a pull request on this topic?

Would be so helpful for all users when you could support in maintenance ...

Best Regards, Liane