The query trigger will execute an SQL query on a schedule and can pass row changes as input to the defined pipeline. The query trigger supports the same database engines as the query step. Flowpipe ...

DROP trigger if exists update_objects_updated_at on storage.objects; CREATE TRIGGER update_objects_updated_at BEFORE UPDATE ON storage.objects FOR EACH ROW EXECUTE PROCEDURE update_updated_at_column ...

For our app, we have a service that will update a VersionId column for a given record (SQL Server 2008), which is hooked up to the following trigger to populate some tables that hold historical ...

I'm having trouble figuring out how to write a particular trigger to avoid having it recurse. This trigger is an after update trigger that operates on the same table that fires it. This is a ...