PgFlow extensions migration version 1.
Creates PostgreSQL functions in the pgflow schema for:
Read Functions
get_flow_input(uuid)- Get flow run input dataflow_exists(text)- Check if flow existsget_step_output(uuid, text)- Get step output
Write Functions
register_worker(uuid, text, text)- Register or heartbeat a workermark_worker_stopped(uuid)- Mark worker as stoppedrecover_stalled_tasks(double precision)- Recover stalled tasks and reset visibility
Summary
Functions
Rolls back this version's migration by executing the down SQL file.
Applies this version's migration by executing the up SQL file.