Dimitris Stafylarakis created GRIFFIN-231:
---------------------------------------------
Summary: Database initialisation fails on Postgresql
Key: GRIFFIN-231
URL: https://issues.apache.org/jira/browse/GRIFFIN-231
Project: Griffin (Incubating)
Issue Type: Bug
Affects Versions: 0.5.0
Reporter: Dimitris Stafylarakis
The script service/src/main/resources/Init_quartz_postgres.sql contains the
following statements that lead to an exception (table does not exist)
{code:java}
// code SQL
drop table qrtz_fired_triggers;
DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE QRTZ_SCHEDULER_STATE;
DROP TABLE QRTZ_LOCKS;
drop table qrtz_simple_triggers;
drop table qrtz_cron_triggers;
drop table qrtz_simprop_triggers;
DROP TABLE QRTZ_BLOB_TRIGGERS;
drop table qrtz_triggers;
drop table qrtz_job_details;
drop table qrtz_calendars;
{code}
Other platforms (e.g., mysql) use the DROP TABLE IF EXISTS statement instead.
The postgres variant should use this as well.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
