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

[José María Michia]

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
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/iWSNbC/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/