Hola.
DEBIDO a que al correr la linea
SELECT PostGIS_Full_Version();
obtengo:
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . .
postgres=# SELECT PostGIS_Full_Version();
ERROR: function postgis_full_version() does not exist
LINE 1: SELECT PostGIS_Full_Version();
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts.
postgres=#
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . .
volvi a correr las lineas
psql -d geoespacial -f /usr/share/pgsql/contrib/postgis-1.5/postgis.sql
psql -d geoespacial -f /usr/share/pgsql/contrib/postgis-1.5/spatial_ref_sys.sql
y me retorna esto:
psql:/usr/share/pgsql/contrib/postgis-1.5/postgis.sql:6987: ERROR: current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/contrib/postgis-1.5/postgis.sql:7009: ERROR: current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/contrib/postgis-1.5/postgis.sql:7015: ERROR: current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/contrib/postgis-1.5/postgis.sql:7018: ERROR: current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/pgsql/contrib/postgis-1.5/postgis.sql:7024: ERROR: current
transaction is aborted, commands ignored until end of transaction block
Al buscar en GOO no encuentro info...
Intento ELIMINAR LA BD que configure PARA POSTGIS asi:
DROP DATABASE geoespacial
y no lo hace ni devuelve error
(lo hago como user postgres)
_______________________________________________
Talk-co mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/talk-co
