Apparently one can not use Mantis unless on is using a paid version ... Oh well
In any case I was using the current version of Studio (13.6.1) on macOS 12.7.2 with PostgreSQL version 15 . When I tried to execute the the following statement from Valentin Studio I get an error:
CREATE OR REPLACE TRIGGER SOPDeptCodesUpdate BEFORE Update ON SOPDeptCodes
FOR EACH ROW EXECUTE FUNCTION audit.ModInfo();
Studio says:
CREATE OR REPLACE TRIGGER SOPDeptCodesUpdate BEFORE Update ON SOPDeptCodes
Missing semicolon at end of command
FOR EACH ROW EXECUTE FUNCTION audit.ModInfo();
First the command does not end on that line but the following one.
Secondly, to make sure I was just not seeing what the real issue was, I switched to using pgAdmin 4. There the exact same command executed without an issue.
In both cases this was within a transaction block:
Begin TRANSACTION;
CREATE TABLE IF NOT EXISTS SOPDeptCodes
Key0 SERIAL PRIMARY KEY,
DeptKey INTEGER NOT NULL REFERENCES Department(Key0) ON DELETE CASCADE,
SOPCode CHARACTER VARYING(5) NOT NULL UNIQUE,
Description CHARACTER VARYING(80),
CreatedOn timestamp (0) with time zone Default Now(),
CreatedBy TEXT DEFAULT (session_user),
LastModifiedOn timestamp (0) with time zone,
LastModifiedBy Text );
CREATE UNIQUE INDEX IF NOT EXISTS DeptSOPCode_idx on SOPDeptCodes (Key0, DeptKey);
CREATE OR REPLACE TRIGGER SOPDeptCodesUpdate BEFORE Update ON SOPDeptCodes
FOR EACH ROW EXECUTE FUNCTION audit.ModInfo();
CREATE OR REPLACE TRIGGER SOPDeptCodes_audit
AFTER INSERT OR UPDATE OR DELETE ON SOPDeptCodes
FOR EACH ROW EXECUTE PROCEDURE audit.LogAudit();
ALTER TABLE MasterSOPTable Add COLUMN OldNaming BOOLEAN DEFAULT FALSE;
End TRANSACTION;