[postgis] ERROR: parser: parse error at or near "with"

[Luis Viveros]

José Maria:

dentro del archivo postgis.sql estan las instrucciones que lo que tienes que hacer antes de ejecutar las instrucciones sql.

--- you might have to define the plpgsql language something like;

-- CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
--     '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';
--
-- CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
--     HANDLER plpgsql_call_handler
--     LANCOMPILER 'PL/pgSQL';

-- here's some hockey code to test to see if plpgsql is installed
--  if it is, you get a message "plpgsql is installed" 
--    otherwise it will give a big error message


Luis Viveros
 
--

On Thu, 31 Jan 2002 05:26:12  
 José María Michia wrote:
>Español:
>
>Hola!
>
>Cuando ejecuto "psql -f postgis.sql -d databasename" obtengo los 
>siguientes errores:
>
>1- ERROR:  parser: parse error at or near "with"
>
>2- ERROR:  parser: parse error at or near ","
>
>Estos errores se repiten muchas veces.
>
>Edite el archivo postgis.sql y elimine todos los with(.........) y todos 
>los ,'.......' que traian problemas. Luego:
>
>psql -f postgis.sql -d databasename         OK
>
>CREATE TABLE geom_test ( gid int4, geom geometry,name varchar(25) );    
>    OK
>
>INSERT INTO geom_test ( gid, geom, name ) VALUES ( 1, 'POLYGON((0 0 0,0 
>5 0,5 5 0,5 0 0,0 0 0))', '3D Square');        ERROR
>
>ERROR:  Load of file /usr/local/pgsql/lib/contrib/libpostgis.so.0.6 
>failed: /usr/local/pgsql/lib/contrib/libpostgis.so.0.6: undefined 
>symbol: LocalBufferBlockPointers
>
>Gracias
>
>---------------------------------------
>
>ENGLISH???
>
>Hello!
>
># "psql -f postgis.sql -d databasename"
>
>1- ERROR:  parser: parse error at or near "with"    (many times)
>
>2- ERROR:  parser: parse error at or near ","    (many times)
>
>In postgis.sql, delete every occurrence of [with(...)] and [,'........']
>
>try again:
>
>psql -f postgis.sql -d databasename         OK
>
>CREATE TABLE geom_test ( gid int4, geom geometry,name varchar(25) );    
>    OK
>
>INSERT INTO geom_test ( gid, geom, name ) VALUES ( 1, 'POLYGON((0 0 0,0 
>5 0,5 5 0,5 0 0,0 0 0))', '3D Square');        ERROR
>
>ERROR:  Load of file /usr/local/pgsql/lib/contrib/libpostgis.so.0.6 
>failed: /usr/local/pgsql/lib/contrib/libpostgis.so.0.6: undefined 
>symbol: LocalBufferBlockPointers
>
>Thanks
>
>
>
>
>
>
>



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
Pinpoint the right security solution for your company - FREE
Guide from industry leader VeriSign gives you all the facts.
http://us.click.yahoo.com/lWSNbC/WdiDAA/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/