<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
What is wrong in my function, it doesnt stop or should it take so loooong... ? Minutes... Trying to insert to lines in table<br><br>CREATE OR REPLACE FUNCTION make_point() RETURNS TRIGGER AS $start_point$<br> BEGIN<br> <br> UPDATE positionreports SET the_geom = SetSRID(st_makepoint <br> ("longitude","latitude"), 4326);<br><br> RETURN NULL; -- result is ignored since this is an AFTER trigger<br> END;<br>$start_point$ LANGUAGE plpgsql;<br><br>CREATE TRIGGER start_point<br>AFTER INSERT OR UPDATE ON positionreports<br> FOR EACH ROW EXECUTE PROCEDURE make_point();<br><br><hr id="stopSpelling">From: illurt@hotmail.com<br>To: postgis-users@postgis.refractions.net<br>Date: Mon, 7 Sep 2009 12:59:56 +0300<br>Subject: [postgis-users] Points and lines<br><br>
<style>
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_hmmessage
{font-size:10pt;font-family:Verdana;}
</style>
Hi,<br><br>I have this kind of problem that i have 2 tables, another has point data and another has line data that comes from points. Everything is okay, i see lines etc.<br>Now I need trigger or function or ... cause everytime that new point comes to table i need to update my lines table also that table shows the latest point in line also.<br>I hope that you understand what i mean :)<br>Tell me different kind of options that I have that I can make this work...<br>Thanks for everybody !!<br><br>-Tuomas<br><br><hr>Uusi Spaces ja 25 Gt ilmaista SkyDrive tallennustilaa. <a href="http://www.download.live.com/">Lataa Live paketti.</a><br /><hr />Uudessa IE8 selaimessa on uudet pikatoiminnot. <a href='http://www.microsoft.com/finland/windows/products/winfamily/ie/beta/default.mspx' target='_new'>Lataa.</a></body>
</html>