Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5FM9ra78170 for ; Fri, 15 Jun 2001 18:09:54 -0400 (EDT) (envelope-from ler@lerctr.org) Received: from lerami.lerctr.org (localhost [127.0.0.1]) by lerami.lerctr.org (8.12.0.Beta10/8.12.0.Beta10/20010318/$Revision: 1.22 $) with ESMTP id f5FM9oZw003325 for ; Fri, 15 Jun 2001 17:09:50 -0500 (CDT) (envelope-from ler@lerami.lerctr.org) Received: (from ler@localhost) by lerami.lerctr.org (8.12.0.Beta10/8.12.0.Beta10) id f5FM9oHn003324 for pgsql-sql@postgresql.org; Fri, 15 Jun 2001 17:09:50 -0500 (CDT) (envelope-from ler) Date: Fri, 15 Jun 2001 17:09:50 -0500 From: Larry Rosenman To: PostgreSQL SQL List Subject: Why doesn't this pgsql function compile? Message-ID: <20010615170950.A3303@lerami.lerctr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.19i X-Mailer: Mutt http://www.mutt.org/ X-Archive-Number: 200106/220 X-Sequence-Number: 3478 When this PLpgsql function gets called on the trigger it fails compilation on the last line. What am I doing wrong? DROP TRIGGER netblock_bgp ON networks; DROP FUNCTION networks_trigger_router(); CREATE FUNCTION networks_trigger_router() RETURNS opaque AS 'BEGIN IF TG_OP = ''DELETE'' AND OLD.router ISNULL THEN return OLD; END IF; IF TG_OP = ''INSERT'' AND NEW.router ISNULL THEN return NEW; END IF; IF TG_OP = ''INSERT'' AND get_router_nexthop(NEW.router) ISNULL THEN return NEW; END IF; IF TG_OP = ''DELETE'' AND get_router_nexthop(OLD.router) ISNULL THEN return OLD; END IF; IF TG_OP = ''INSERT'' THEN add_ip_route(host(network(NEW.netblock)), host(netmask(NEW.netblock)), get_router_ethernet(NEW.router), get_router_nexthop(NEW.router), get_router_nexthop_user(NEW.router), get_router_nexthop_password(NEW.router), get_router_nexthop_enpass(NEW,router)); return NEW; END IF; IF TG_OP = ''DELETE'' THEN del_ip_route(host(network(OLD.netblock)), host(netmask(OLD.netblock)), get_router_ethernet(OLD.router), get_router_nexthop(OLD.router), get_router_nexthop_user(OLD.router), get_router_nexthop_password(OLD.router), get_router_nexthop_enpass(OLD,router)); return OLD; -- TG_OP must be UPDATE to get here.... IF OLD.router NOTNULL and get_router_nexthop(OLD.router) NOTNULL AND NEW.router NOTNULL and OLD.router != NEW.router THEN del_ip_route(host(network(OLD.netblock)), host(netmask(OLD.netblock)), get_router_ethernet(OLD.router), get_router_nexthop(OLD.router), get_router_nexthop_user(OLD.router), get_router_nexthop_password(OLD.router), get_router_nexthop_enpass(OLD,router)); END IF; IF NEW.router NOTNULL and get_router_nexthop(NEW.router) NOTNULL THEN add_ip_route(host(network(NEW.netblock)), host(netmask(NEW.netblock)), get_router_ethernet(NEW.router), get_router_nexthop(NEW.router), get_router_nexthop_user(NEW.router), get_router_nexthop_password(NEW.router), get_router_nexthop_enpass(NEW,router)); END IF; return NEW; END;' LANGUAGE 'plpgsql'; CREATE TRIGGER netblock_bgp BEFORE UPDATE OR INSERT OR DELETE ON networks FOR EACH ROW EXECUTE PROCEDURE networks_trigger_router(); -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749