Received: from ler-freebie.iadfw.net (ler-freebie.iadfw.net [206.66.13.221]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5FMhxa90490 for ; Fri, 15 Jun 2001 18:43:59 -0400 (EDT) (envelope-from ler@ler-freebie.iadfw.net) Received: (from ler@localhost) by ler-freebie.iadfw.net (8.11.4/8.11.3) id f5FMhrS55377; Fri, 15 Jun 2001 17:43:53 -0500 (CDT) (envelope-from ler) Date: Fri, 15 Jun 2001 17:43:53 -0500 From: Larry Rosenman To: Joe Conway Cc: PostgreSQL SQL List Subject: Re: Why doesn't this pgsql function compile? Message-ID: <20010615174353.A55366@ler-freebie.iadfw.net> References: <20010615170950.A3303@lerami.lerctr.org> <005101c0f5ec$83f56b80$d7d310ac@jecw2k1> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <005101c0f5ec$83f56b80$d7d310ac@jecw2k1> User-Agent: Mutt/1.3.19i X-Mailer: Mutt http://www.mutt.org/ X-Archive-Number: 200106/222 X-Sequence-Number: 3480 Yes, I found that out, as well as needing to save off the new. and old. var's... :-) LER * Joe Conway [010615 17:43]: > > > When this PLpgsql function gets called on the trigger > > it fails compilation on the last line. > > > > What am I doing wrong? > > > > > > > > > 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; > > Don't you need a "PERFORM" between the "THEN" and "add_ip_route(. . ." above > (and similar places below)? > > -- Joe > > > 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'; > >