Skip to main content

New answers tagged

0 votes

Create triggers on slave only in mysql replication with a slave with different schema

This question is six years old, but I'm answering for future reference. As the other answer states, in MySQL, row-based replication doesn't run triggers. Triggers can only be fired by SQL statements. ...
Federico Razzoli's user avatar
0 votes
Accepted

PostgreSQL16 concurrency upsert rows with subquery in trugger funtion got maybe bad read

The problem is the subquery you are using in the UPDATE branch. The problem will go away if you write ... ON CONFLICT (name) DO UPDATE SET score = name_score.score + 1 as long as you are using the ...
Laurenz Albe's user avatar
  • 54.1k
0 votes

Call a stored procedure from a trigger

Different names for defining and calling the procedure would cause a problem. Has anyone noticed that sp-set-comment_count and sp_set-comment_count are different? After the sp, one has an underscore ...
Edward LeBlanc's user avatar

Top 50 recent answers are included