1. Karen Atkocius
  2. Valentina Studio
  3. Суббота, Декабрь 16 2023, 11:52 PM
  4.  Подписаться через 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;
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Ссылки
  1. https://valentina-db.com/bt
Комментарий
There are no comments made yet.
Karen Atkocius Ответ принят
Yes Postgres is on the same system. I copy and pasted the same SQL into both apps as well BTW.

-Karen
Комментарий
There are no comments made yet.
  • Страница :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories