Помогите устранить ошибку в shp2pgsql
Добавлено: 17 мар 2011, 01:32
При переконвертации Shape файла в SQL программа выдает ошибку :
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 10: SELECT AddGeometryColumn('public','ukraine-water-a','the_geo...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Вот в общем весь лог:
Connecting: host=localhost port=5432 user=postgres dbname=postgres password='******'
Connection succeeded.
Connection: host=localhost port=5432 user=postgres dbname=postgres password='******'
Destination: public.ukraine-water-a
Source File: D:\Program Files\PostgreSQL\9.0\bin\ukraine-water-a
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."ukraine-water-a" (gid serial PRIMARY KEY,
"osm_id" float8,
"name" varchar(61),
"waterway" varchar(10),
"landuse" varchar(9),
"source" varchar(20));
SELECT A"
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 10: SELECT AddGeometryColumn('public','ukraine-water-a','the_geo...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Shapefile import failed.
В чем причина??
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 10: SELECT AddGeometryColumn('public','ukraine-water-a','the_geo...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Вот в общем весь лог:
Connecting: host=localhost port=5432 user=postgres dbname=postgres password='******'
Connection succeeded.
Connection: host=localhost port=5432 user=postgres dbname=postgres password='******'
Destination: public.ukraine-water-a
Source File: D:\Program Files\PostgreSQL\9.0\bin\ukraine-water-a
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."ukraine-water-a" (gid serial PRIMARY KEY,
"osm_id" float8,
"name" varchar(61),
"waterway" varchar(10),
"landuse" varchar(9),
"source" varchar(20));
SELECT A"
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 10: SELECT AddGeometryColumn('public','ukraine-water-a','the_geo...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Shapefile import failed.
В чем причина??