Skip site navigation (1) Skip section navigation (2)


From: Abhay Kumar <abhay4india(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: abhay(dot)kumar1(at)wipro(dot)com
Subject: Bugs
Date: 2008-01-29 10:08:58
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
  I am installing the Postgis 2.2.1 on PostgreSQL.
  I am acing the error:
  1. Download postgis-1.2.1.tar.gz from
      to /usr/share/postgresql/8.1/contrib
  2.  tar xvzf postgis-1.2.1.tar.gz
       cd postgis-1.2.1
        ./configure --prefix=/usr --with-pgsql=/usr/bin/pg_config --with-geos=/usr/bin/geos-config --with-proj=/usr
  3. # create a PostgreSQL database for a test
       createdb zpostgis_test
       createlang plpgsql zpostgis_test
-      psql -d zpostgis_test /usr/share/postgresql/8.1/contrib/postgis-1.2.1/wpostgis.sql
+      psql -d zpostgis_test -f /usr/share/postgresql/8.1/contrib/postgis-1.2.1/lwpostgis.sql
      We now get an error "Could not be loaded"
       even is in /usr/lib.
+ Or execute the first SQL statement in lwpostgis.sql:
+ postgres=# CREATE OR REPLACE FUNCTION histogram2d_in(cstring) RETURNS histogram2d AS '/usr/lib/', 'lwhistogram2d_in' LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);
+ NOTICE:  type "histogram2d" is not yet defined
+ DETAIL:  Creating a shell type definition.
+ ERROR:  could not load library "/usr/lib/": /usr/lib/ undefined symbol: has_arc 
  Please provide me the Solution.
  Thanks and Regards
  P Please do not print this email unless it is absolutely necessary. Spread environmental awareness.

Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.


  • Re: Bugs at 2008-01-29 11:08:36 from Gregory Stark

pgsql-bugs by date

Next:From: Gregory StarkDate: 2008-01-29 11:08:36
Subject: Re: Bugs
Previous:From: Dmitry AfanasievDate: 2008-01-29 09:45:28
Subject: BUG #3910: Incorrect behavior of UPDATE statement on tables with constraints UNIQUE/PRIMARY KEY

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group