<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body><BR>Sorry the error i get is:<BR>
<BR><PRE style="BORDER-RIGHT: 0pt; BORDER-TOP: 0pt; BORDER-LEFT: 0pt; BORDER-BOTTOM: 0pt">Query failed: ERROR: missing FROM-clause entry for table "nodes" ....</PRE>
<BR>Broun Uganda<BR><BR><BR><BR>
<BLOCKQUOTE>
<HR id=EC_stopSpelling>
From: tekuganda@hotmail.com<BR>To: postgis-users@postgis.refractions.net<BR>Subject: Trigger updata lines<BR>Date: Tue, 14 Aug 2007 23:24:44 +0300<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass P
{padding:0px;}
.ExternalClass
{font-size:10pt;font-family:Tahoma;}
</STYLE>
<BR>I want to create a trigger that updates lines' geometry depending on the position of 2 points (from_node & to_node). If i move a point connecting two or more lines, the ends of lines should also move and follow the point. I wrote the following trigger but it gives me error that am giving multiple geometry.<BR> <BR>CREATE OR REPLACE FUNCTION update_links() RETURNS "trigger"<BR> AS <BR>'<BR>DECLARE<BR>starts character varying;<BR>ends character varying;<BR>BEGIN<BR>starts = NEW.name WHERE nodes.name = links.from_node;<BR>ends = NEW.name WHERE nodes.name = links.to_node;<BR>UPDATE links SET the_geom = GeometryFromtext(starts.<FONT face="">the_geom</FONT>,ends.the_geom) ;<BR>RETURN NEW;<BR>END'<BR> LANGUAGE plpgsql;<BR>CREATE TRIGGER update_links_update<BR> AFTER UPDATE<BR> ON nodes<BR> FOR EACH ROW<BR> EXECUTE PROCEDURE update_links();<BR> <BR> <BR>Thanks for your help<BR><BR><BR>
<HR>
Live Earth is coming. Learn more about the hottest summer event - only on MSN. <A href="http://liveearth.msn.com/?source=msntaglineliveearthwlm" target=_blank>Check it out!</A> </BLOCKQUOTE><br /><hr />Hotmail to go? Get your Hotmail, news, sports and much more! <a href='http://mobile.msn.com' target='_new'>Check out the New MSN Mobile</a></body>
</html>