gistfile1.txt

CREATE TABLE test (
  id SERIAL PRIMARY KEY,
  test TEXT,
  status CHARACTER VARYING (20) DEFAULT 'queued'
);

CREATE OR REPLACE RULE "new_test" AS
  ON INSERT TO test
  DO NOTIFY "new_test";

CREATE TABLE action (
  id SERIAL PRIMARY KEY,
  origin TEXT,
  type TEXT,
  name TEXT,
  status TEXT,
  updated TIMESTAMPTZ DEFAULT now()
);