maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_event_part_createchild(date)
Parameters
Name
Type
Mode
in_target_date
date
IN
Definition
DECLARE table_name varchar; lower_bound timestamptz; upper_bound timestamptz; BEGIN SET time zone 'UTC'; SET search_path TO public; SET statement_timeout = '5 s'; table_name := (select 'event_p'|| to_char(in_target_date,'YYYY')||'_'||to_char(in_target_date,'MM')||'_'||to_char(in_target_date,'DD')); lower_bound := (select date_trunc('day',in_target_date)); upper_bound := lower_bound + '1 day'::interval; EXECUTE 'CREATE TABLE '||table_name ||' (LIKE event INCLUDING DEFAULTS INCLUDING INDEXES INCLUDING COMMENTS)'; EXECUTE 'ALTER TABLE '||table_name||' ADD CONSTRAINT ck_'||table_name||'_part_senddate_range CHECK(senddate >= '|| quote_literal(lower_bound) ||' AND senddate < '|| quote_literal(upper_bound)||')'; EXECUTE 'ALTER TABLE '||table_name||' INHERIT public.event'; RAISE NOTICE 'Created table %', table_name; RETURN true; EXCEPTION WHEN OTHERS THEN RAISE NOTICE '%,%', SQLSTATE, SQLERRM; RETURN false; END;