Hot answers tagged postgresql
You can bind a trigger function to as many tables as you want; just execute a CREATE TRIGGER statement for each binding. Make sure to schema-qualify the table name in your statement (BEFORE INSERT OR UPDATE ON a.point etc.) If you have a large number of schemas, you could generate the SQL dynamically by iterating over the rows in ...
No space should be (also float8 is the same as double precision and a bit faster to type) UPDATE main_table SET geom = ST_SetSRID( ST_MakePoint(lng::float8, lat::float8) ,4326);
You can get the shortest route between two points using PostGIS with ST_Distance (if you want to know the distance) or with ST_MakeLine (for the geometry): http://postgis.net/docs/ST_Distance.html http://postgis.net/docs/ST_MakeLine.html If you want to use the network for routing, then you need a network topology. You could try something like pggraph, ...
I was trying to do some changes and this looks like solution since everything works. I deleted old database and again created new one by creating a spatial database directly in pgAdmin: Created new database (name,owner...) Opened the query dialog box and wrote CREATE EXTENSION postgis; and then SELECT postgis_full_version(); This step ...
Only top voted, non community-wiki answers of a minimum length are eligible