[postgis] (unknown)

[comp_sjc]

Hi all,
I am geeting the following error while trying to install the 
postGIS extensions for my POSTGRESQL DB.
any pointers on what might be wrong

regards

______________________________________________

$$$ psql -d spt -f postgis.sql superuser
BEGIN
       message        
----------------------
 plpgsql is installed
(1 row)

CREATE
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
psql:postgis.sql:34: NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
CREATE
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'gc_pk' for table 'geometry_columns'
psql:postgis.sql:47: NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'gc_pk' for table 'geometry_columns'
CREATE
CREATE
CREATE
CREATE
NOTICE:  ProcedureCreate: type 'box3d' is not yet defined
psql:postgis.sql:212: NOTICE:  ProcedureCreate: type 'box3d' is not yet defined
ERROR:  Can't find function box3d_in in file /usr/lib/pgsql/plpgsql.so
psql:postgis.sql:212: ERROR:  Can't find function box3d_in in file /usr/lib/pgsql/plpgsql.so
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
psql:postgis.sql:217: NOTICE:  current transaction is aborted, queries ignored until end of transaction block
*ABORT STATE*

...
....
big stack trace of failure...



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Send FREE Holiday eCards from Yahoo! Greetings.
http://us.click.yahoo.com/IgTaHA/ZQdDAA/ySSFAA/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/