[postgis-users] pgdijkstra and postgresql

[Mark Cave-Ayland]

On Fri, 2006-12-15 at 06:37 +0530, Sasanka Gandavarapu wrote:
> Hi all,
> 
> I am having a problem in integrating the pgdijkstra plug-in with
> postgresql i am using postgresql 8.1.4 on  windows xp  platform.
> I am using pgdijkstra module from cartoweb link and the following is
> the error while trying to access the dijkstra_postgis.
> 
> 
> ErrorC:\Program Files\PostgreSQL\8.1\bin>psql -U postgres roads -f"C:
> \Program Files\PostgreSQL\pgdijkstra\dijkstra_postgis.sql"
> Password for user postgres:
> 
> CREATE FUNCTION
> psql:C:/Program Files/PostgreSQL/pgdijkstra/dijkstra_postgis.sql:89:
> ERROR:  type geometry does not exist
> CREATE FUNCTION
> CREATE FUNCTION
> psql:C:/Program Files/PostgreSQL/pgdijkstra/dijkstra_postgis.sql:160:
> ERROR:  type "geometry" does not exist
> psql:C:/Program Files/PostgreSQL/pgdijkstra/dijkstra_postgis.sql:194:
> ERROR:  type "geoms" does not exist
> psql:C:/Program Files/PostgreSQL/pgdijkstra/dijkstra_postgis.sql:232:
> ERROR:  type "geoms" does not exist
> 
> Please help!
> 
> thanks in advance
> 
> Horry


Hi Horry,

It looks as if you haven't loaded the PostGIS (lwpostgis.sql)
definitions into your roads database...


Kind regards,

Mark.