'I have an error in Postgresql building a trigger and cannot seem to find a solution
I am working in PGAdmin4, learning postgresql (yes, I am still green to this), and trying to build a trigger for a project.
Everything seems to be working well until I get to the create trigger:
CREATE OR REPLACE TRIGGER Mail_List_upd
BEFORE UPDATE
ON Mail_List
FOR EACH ROW
EXECUTE PROCEDURE Mail_List_upd_func();
When I execute this, in addition to the rest of my code, I get the following error:
ERROR: syntax error at or near "CREATE"
LINE 73: CREATE OR REPLACE TRIGGER Mail_List_upd
^
SQL state: 42601
Character: 1824
I have gone through all the work and everything looks good. I as curious if this might be a dialect issue, but that does not seem to be it. I looked up another person's work on github and tried it and saw the same error. So I am at a loss.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
