sql - ERROR: could not access file "$libdir/postgis-2.0" postgresapp -

-

i running postgresapp 9.2.4.3 , postgis , trying add geometry column table. postgis extension running.

when run:

select addgeometrycolumn('public'::varchar,'gloutline'::varchar,'geom'::varchar,'4326','multipoly on','2');

i'm getting following errors:

error:  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 @ 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 @ sql statement

a reinstall of postgress.app including application support files fixed problem.


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more