Current section
Files
Jump to
Current section
Files
priv/stubs.sql
-- Stubs for pg_cron extension so sqlc can parse the absurd schema.
-- These are NOT used at runtime — only for static analysis by sqlc/parrot.
CREATE SCHEMA IF NOT EXISTS cron;
CREATE TABLE IF NOT EXISTS cron.job (jobid bigint, jobname text, schedule text, command text, nodename text, nodeport integer, database text, username text, active boolean, jobclass text);
CREATE FUNCTION cron.schedule(jobname text, schedule text, command text) RETURNS bigint AS $$ BEGIN RETURN 0; END; $$ LANGUAGE plpgsql;
CREATE FUNCTION cron.unschedule(jobid bigint) RETURNS boolean AS $$ BEGIN RETURN true; END; $$ LANGUAGE plpgsql;