[postgis] pl/pgsql support

[Eric Faurot]

gispmpf writes:
 > hello all
 > 
 > I'm istalling postgis 0.6.2 but , i'm stuck with the pl/pgsql support.
 > 
 > I had install postgreSQL 7.1.3 but i don't found plpgsql.so in the
 > /usr/local/pgsql/lib.
 > 
 > i just found this: /postgresql-7.1.3/src/pl/plpgsql/src/libplpgsql.so 

This is weird... It should be installed correctly with 'make install'.

 > what should i do to fix this and continue with the instalattion?
 > 
 > also 
 > 
 > after this fix what i have to do is:
 > 
 > psql mydbGIS
 > 
 > mydbGIS# CREATE FUNCTION plpgsql_call_handler() RETURNS OPAQUE AS
 >          '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';
             ^^^^^^^^^^^^^^^^^^^^^
You'll have to change the path here.

 > mydbGIS#CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER 
 >         plpgsql_call_handler LANCOMPILER 'PL/pgSQL';
 > 
 > #\q
 >

Simpler: you can use:

$ createlang plpgsql yourdbGIS

Add '-L path/to/your/plpgsql/so/file' if it doesn't work, but it
should if postgres is correctly installed. Then:

$ psql -f postgis.sql -d yourdbGIS


Eric.

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/