pg_partition_2.sql

-- Attach a magic function to the insert of this table:
CREATE OR REPLACE FUNCTION create_partition_and_insert()
  RETURNS TRIGGER AS
$BODY$
DECLARE
  partition VARCHAR(25);
BEGIN
  partition := TG_RELNAME || '_' || NEW.period || ‘p’;
  IF NOT EXISTS(SELECT relname
                FROM pg_class
                WHERE relname = partition)
  THEN
    RAISE NOTICE 'A partition has been created %', partition;
    EXECUTE 'CREATE TABLE ' || partition || ' (check (period = ''' || NEW.period || ''')) INHERITS (' || TG_RELNAME ||
            ');';
  END IF;
  EXECUTE 'INSERT INTO ' || partition || ' SELECT(' || TG_RELNAME || ' ' || quote_literal(NEW) || ').*;';
  RETURN NULL;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;