Plugin is mySQL only. Not working at our university (postgress)

[RainerRutka]

Unfortunately the plugin is for mySQL only. But, we have Postgress installed.

See the errsor-message:
ActiveRecord::StatementInvalid (PG::SyntaxError: FEHLER: Syntaxfehler bei »« LINE 1: INSERT INTOwatchers(user_id,watchable_id,watchabl...
^
: INSERT INTO watchers (user_id, watchable_id, watchable_type) VALUES (564, 3385, 'Issue')):
activerecord (3.2.16) lib/active_record/connection_adapters/postgresql_adapter.rb:650:in exec' activerecord (3.2.16) lib/active_record/connection_adapters/postgresql_adapter.rb:650:inblock in execute'
activerecord (3.2.16) lib/active_record/connection_adapters/abstract_adapter.rb:280:in block in log' activesupport (3.2.16) lib/active_support/notifications/instrumenter.rb:20:ininstrument'
activerecord (3.2.16) lib/active_record/connection_adapters/abstract_adapter.rb:275:in log' activerecord (3.2.16) lib/active_record/connection_adapters/postgresql_adapter.rb:649:inexecute'
plugins/redmine_watcher_groups/app/controllers/watcher_groups_controller.rb:18:in block in create' plugins/redmine_watcher_groups/app/controllers/watcher_groups_controller.rb:13:ineach'
plugins/redmine_watcher_groups/app/controllers/watcher_groups_controller.rb:13:in create' actionpack (3.2.16) lib/action_controller/metal/implicit_render.rb:4:insend_action'

Any suggestions to fix this :-) ?

[mmackiew]

I solve this problem in controller:

Watcher.connection.execute("INSERT INTO #{Watcher.table_name} (user_id, watchable_id, watchable_type) VALUES (#{group_id}, #{@watched.id}, '#{@watched.class.name}')")

U should remove ugly mySQL quote and after that it works fine with PostgreSQL.