错误:无法访问文件"$ libdir/postgis-2.0" postgresapp [英] ERROR: could not access file "$libdir/postgis-2.0" postgresapp
本文介绍了错误:无法访问文件"$ libdir/postgis-2.0" postgresapp的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在运行postgresapp 9.2.4.3和postgis,并尝试将几何列添加到表中. postgis扩展正在运行.
I am running postgresapp 9.2.4.3 and postgis and trying to add a geometry column to a table. The postgis extension is running.
当我跑步时:
SELECT AddGeometryColumn('public'::varchar,'gloutline'::varchar,'geom'::varchar,'4326','MULTIPOLY ON','2');
我遇到以下错误:
ERROR: could not access file "$libdir/postgis-2.0": No such file or directory
LINE 1: ALTER TABLE public.gloutline ADD COLUMN geom geometry(MultiP...
QUERY: ALTER TABLE public.gloutline ADD COLUMN geom geometry(MultiPolygon, 4326)
CONTEXT: PL/pgSQL function addgeometrycolumn(character varying,character varying,character varying,character varying,integer,character varying,integer,boolean) line 110 at EXECUTE statement
SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)" PL/pgSQL function addgeometrycolumn(character varying,character varying,character varying,integer,character varying,integer,boolean) line 5 at SQL statement
推荐答案
重新安装postgress.app(包括应用程序支持文件)解决了该问题.
A reinstall of postgress.app including the application support files fixed the problem.
这篇关于错误:无法访问文件"$ libdir/postgis-2.0" postgresapp的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文