Changes between Version 47 and Version 48 of InstallationGuidelines/PostgreSQL

Timestamp:

03/11/11 21:10:43 (14 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -150 +150 @@
 If using PostGIS, then once the tables have been created:
 {{{
-su postgres
-psql
-\d sahana
-# Ensure all POINTs have WKT entries
+cat << EOF > "/tmp/geometry.sql"
 UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1;
-# Add geometry Column
 SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 );
-# Populate existing entries
 UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326);
-exit
+EOF
+su -c - postgres "psql -q -d sahana -f /tmp/geometry.sql"
 }}}
 (if using Windows can use the Query Editor that comes with pgAdmin III)
@@ -165 +161 @@
 Ensure that future entries auto-populate properly:
 {{{
-su postgres
-psql
-\d sahana
+cat << EOF > "/tmp/autopopulate.sql"
 CREATE OR REPLACE FUNCTION s3_update_geometry()
-  RETURNS "trigger" AS
-$BODY$
+  RETURNS "trigger" AS \$$
   DECLARE
   BEGIN
-
     if (NEW.wkt != '') then
-        NEW.the_geom = SetSRID(GeomFromText(NEW.wkt), 4326);
-        end if;
+        NEW.the_geom = SetSRID(GeomFromText(NEW.wkt), 4326);
+        end if;
 
     RETURN NEW;
   END;
-$BODY$
-  LANGUAGE 'plpgsql' VOLATILE;
+\$$  LANGUAGE 'plpgsql' VOLATILE;
 ALTER FUNCTION s3_update_geometry() OWNER TO sahana;
 CREATE TRIGGER s3_locations_update
@@ -189 +180 @@
   EXECUTE PROCEDURE s3_update_geometry();
 
-exit
+EOF
+su -c - postgres "psql -q -d sahana -f /tmp/autopopulate.sql"
 }}}