[postgis-users] could not find function "centroid" in file "/usr/lib/postgresql/postgis.dll"

[Rudolf Nottrott]

Thanks, Martin,

I'm attempting the geos compile under Cygwin.  There is no Makefile, and 
the installation instructions
(http://www.alexandria.ucsb.edu/~rnott/tmp/geos-1.0/INSTALL)
are really very minimal.  Is that all there is?

The expanded geos-1.0 tree that I got from http://geos.refractions.net/ is at
http://www.alexandria.ucsb.edu/~rnott/tmp/geos-1.0/
for reference.

To begin with, I can't just 'make' Geos in the regular way as there is no 
Makefile, only
Makefile.am and Makefile.am.

For the rest, I did the steps below, and they went fine (so all that's 
missing is Geos)

My PostgreSQL contrib directory is
/cygdrive/c/cygwin/usr/src/postgresql-7.4.3-1/contrib/

I have PostGIS in
/cygdrive/c/cygwin/usr/src/postgresql-7.4.3-1/contrib/postgis-0.8.1
and Geos in
/cygdrive/c/cygwin/usr/src/postgresql-7.4.3-1/contrib/geos-1.0


Following instructions elsewhere I ran a make  (but NOT 'make install') on 
PostgreSQL in directory
/cygdrive/c/cygwin/usr/src/postgresql-7.4.3-1
This make went fine.

I also ran a make AND a 'make install' in
/cygdrive/c/cygwin/usr/src/postgresql-7.4.3-1/contrib/postgis-0.8.1
This went fine, too.

Rudolf

At 03:45 PM 6/26/2004 -0600, you wrote:
>Rudolf,
>
>This is a wild guess, but a centroid sounds like it could be a 
>class/struct in the geos library.  And since PostGIS uses geos for it's 
>geometric calculations it probably needs geos 
>installed.  http://geos.refractions.net/
>
>Martin
>         >Subject: RE: Using/Compiling PostGIS on WindowsXP/Cygwin for use 
> with PostgreSQL
>         >Date: Fri, 25 Jun 2004 17:45:25 -0600
>         >From: "Chapman, Martin" <MChapman at sanz.com>
>         >To: "PostGIS Users Discussion" 
> <postgis-users at postgis.refractions.net>
>         >
>         >That is correct, fortunately the builds for these projects are 
> really
>         >good and work on both linux and windows.  Just download them and 
> follow
>         >the build instructions.  It's easier than you might think.
>         >
>         >Martin
>
>-----Original Message-----
>From: Rudolf Nottrott [mailto:rnott at alexandria.UCSB.edu]
>Sent: Sat 6/26/2004 8:57 AM
>To: PostGIS Users Discussion
>Subject: [postgis-users] could not find function "centroid" in file 
>"/usr/lib/postgresql/postgis.dll"
>
>         I installed PostGIS with PostgreSQL on Windows XP / Cygwin, after 
> switching
>         off proj4 and geos in the Makefile (USE_PROJ=0 and
>         USE_GEOS=0).  I switched off proj4 and geos because I was getting 
> PostGIS
>         compilition errors without them installed, and I felt a bit daunted
>         about  two more installs.
>
>         WIth
>         USE_PROJ=0 and USE_GEOS=0
>         PostGIS  compiles and installes ok -- I just wanted to get the basic
>         PostGIS going first.
>
>         Unfortunatley, now when loading the postgis.sql definitions file
>         psql    -d   drg_usgs   -f   postgis.sql
>         I get an error
>
>         could not find function "centroid" in file 
> "/usr/lib/postgresql/postgis.dll"
>
>         Any idea what that means, and what to do?
>
>         Thanks,
>
>         Rudolf
>
>         P.S.  I thought that perhaps it relates to the uninstalled geos, so I
>         downloaded and unpacked geos, but then found no installation 
> instructions
>         for it (only an empty README file).