[postgis-users] Points and lines
illurt at hotmail.com
Mon Sep 7 22:41:48 PDT 2009
What is wrong in my function, it doesnt stop or should it take so loooong... ? Minutes... Trying to insert to lines in table
CREATE OR REPLACE FUNCTION make_point() RETURNS TRIGGER AS $start_point$
UPDATE positionreports SET the_geom = SetSRID(st_makepoint
RETURN NULL; -- result is ignored since this is an AFTER trigger
$start_point$ LANGUAGE plpgsql;
CREATE TRIGGER start_point
AFTER INSERT OR UPDATE ON positionreports
FOR EACH ROW EXECUTE PROCEDURE make_point();
From: illurt at hotmail.com
To: postgis-users at postgis.refractions.net
Date: Mon, 7 Sep 2009 12:59:56 +0300
Subject: [postgis-users] Points and lines
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.
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.
I hope that you understand what i mean :)
Tell me different kind of options that I have that I can make this work...
Thanks for everybody !!
Uusi Spaces ja 25 Gt ilmaista SkyDrive tallennustilaa. Lataa Live paketti.
Windows Liven avulla voit jakaa valokuviasi helposti.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users