From 69ab9938b426523f5bbcc90dcda5f097d7c9b76a Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sat, 19 Feb 2005 14:01:05 +0000 Subject: [PATCH] Remove PL/PgSQL installation for now, we do manual notifies. --- sql/ccbs.sql | 16 ---------------- 1 file changed, 16 deletions(-) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index e73464c..5125fdb 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -163,19 +163,3 @@ CREATE SCHEMA bigscreen; 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; - -- 2.39.2