[postgis] pl/pgsql support

[gispmpf]

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 

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';

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

#\q

postgres$ psql -f postgis.sql -d mydbGIS

is this correct?

Thanks

João.






------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
Secure all your Web servers now - with a proven 5-part
strategy. The FREE Server Security Guide shows you how.
http://us.click.yahoo.com/uCuuSA/VdiDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

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/