Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am calebcase on github.
  • I am calebcase (https://keybase.io/calebcase) on keybase.
  • I have a public key ASCO0CPE2vPQ8m76RBNyb5yTt3VGt-P-lTE7lBaG5hSUMAo

To claim this, I am signing this object:

@calebcase
calebcase / gist:2bde7e55803fd4b7cabf
Created July 23, 2014 23:14
Possibly reusable with minor tweaks...
CREATE OR REPLACE FUNCTION notify_changes_on_create() RETURNS trigger
LANGUAGE plpgsql
AS $$BEGIN
PERFORM pg_notify('changes', '{"kind": "create", "data": ' || NEW.data::text || '}');
RETURN NULL;
END;$$;
CREATE OR REPLACE FUNCTION notify_changes_on_delete() RETURNS trigger
LANGUAGE plpgsql
AS $$BEGIN