[postgis-devel] problem with spatial_ref_sys.sql

[Kevin Neufeld]

It looks like your target database is not spatially enabled.

Can you verify "geometry_columns" and "spatial_ref_sys" exist in your target database?

IE. you should see something like this.

sudo -u postgres psql -d fixmystreet
fixmystreet=# \d
               List of relations
  Schema |       Name       | Type  |  Owner
--------+------------------+-------+----------
  public | geometry_columns | table | postgres
  public | spatial_ref_sys  | table | postgres
(2 rows)


To verify your libraries are properly working, try this:
fixmystreet=# SELECT ST_AsText('POINT(0 0)'::geometry);
  st_astext
------------
  POINT(0 0)
(1 row)

-- Kevin

Zico wrote:
> 
> 
> On Thu, Aug 27, 2009 at 11:29 PM, Kevin Neufeld 
> <kneufeld at refractions.net <mailto:kneufeld at refractions.net>> wrote:
> 
>     Scroll to the beginning of the log, before all the
> 
>     ERROR:  current transaction is aborted, commands ignored until end
>     of transaction block
> 
>     What's reason the block is aborted?
> 
> 
> 
> /*debian:/usr/share# sudo -u postgres psql -d fixmystreet -f 
> /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql > 
> /root/Desktop/check.txt
> 
> sudo: unable to resolve host debian
> 
> psql:/usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql:5: ERROR:  
> relation "spatial_ref_sys" does not exist
> psql:/usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql:9: ERROR:  
> current transaction is aborted, commands ignored until end of 
> transaction block
> */ 
> 
> 
> -- 
> Best,
> Zico
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel