CREATE TABLE bigscreen.active_tournament (
tournament INTEGER NOT NULL REFERENCES tournaments
);
+
+-- install PL/PgSQL
+CREATE FUNCTION plpgsql_call_handler() RETURNS opaque
+ AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler'
+ LANGUAGE "C";
+CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
+
+-- NOTIFY active_tournament when anything has changed
+CREATE FUNCTION notify_active_tournament() RETURNS trigger
+AS '
+ DECLARE
+ BEGIN
+ NOTIFY bigscreen.active_tournament;
+ END;'
+LANGUAGE plpgsql;
+