错误:无法访问文件"$libdir/postgis-2.0“postgresapp

Question

我正在运行postgresapp 9.2.4.3和postgis，并试图向表中添加一个几何列。postgis扩展正在运行。

当我运行时：

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

Answer 1

重新安装包含应用程序支持文件的postgress.app修复了该问题。