-
|
For example, you have a trigger that fires when a new row is inserted into table Foo. In the PL/PG trigger, could you execute a SQL statement like INSERT payload into procrastinate_table? The event (bar) would have already been defined in the Python code so this is really just a way to add a task via a trigger. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Hello, It should be possible using the procedures that procrastinate creates, though it's not part of the official API and as such it's undocumented. Note that it's unlikely to break suddenly due to our migration rules, but you'll need to test that it works as expected when you do a major upgrade (if there even is one) |
Beta Was this translation helpful? Give feedback.
-
|
Awesome, thank you! |
Beta Was this translation helpful? Give feedback.
Hello,
It should be possible using the procedures that procrastinate creates, though it's not part of the official API and as such it's undocumented. Note that it's unlikely to break suddenly due to our migration rules, but you'll need to test that it works as expected when you do a major upgrade (if there even is one)
procrastinate/procrastinate/sql/schema.sql
Line 72 in b7cfd09