Environment
GMS 23.4GMS 24.1
GMS 24.2
Situation
During the install of GMS, the following error is returned and the install does not complete:Schema change: "CREATE OR REPLACE FUNCTION notify_id_trigger() RETURNS trigger AS \$\$ BEGIN PERFORM pg_notify('new_id', 'payload'); RETURN NEW; END; \$\$ LANGUAGE plpgsql;"
Schema change: "CREATE OR REPLACE TRIGGER data_added AFTER INSERT ON mcheckitems FOR EACH ROW EXECUTE PROCEDURE notify_id_trigger();"
Failed to update database schema (1).
Error output = ERROR: syntax error at or near "TRIGGER"
Support
Documentation
Learning Services
Partner Programs
