1. Karen Atkocius
  2. Valentina Studio
  3. Saturday, December 16 2023, 11:52 PM
  4.  Subscribe via email
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;
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Karen,

There are no limitations on Mantis, just a separate registration is necessary.

Is PostgreSQL on the same system?

The text is sent as-is to the server, it’s strange there is a difference with another application, we’ll try to reproduce it.
References
  1. https://valentina-db.com/bt
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Karen Atkocius Accepted Answer
Yes Postgres is on the same system. I copy and pasted the same SQL into both apps as well BTW.

-Karen
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.