[postgis-devel] WKT Raster: Why having to compile PostgreSQL& PostGIS first?

[Mateusz Loskot]

Pierre Racine wrote:
>>> As a newcomer I really don't like the idea of having to compile 
>>> PostgreSQL & PostGIS before starting working on WKT Raster (I
>>> start
> it
>>> today!).
>> There is no need to build PostgreSQL. You need to build PostGIS
>> once. There is a requirement to use pretty fresh version of
>> PostgreSQL and PostGIS.
> 
> Could not compile PostgreSQL 8.3.5. Spent the day on Paul's 20 
> minutes... Ended with:

Looks like you are using MinGW.
Have you tried to follow this FAQ?

http://www.postgresql.org/docs/faqs.FAQ_MINGW.html

I think I should clarify that I have never used MinGW myself and I know
nothing about this platform/compiler, I never support it myself (on
Windows, I only use Visual C++ compiler).

> --------------------------------------------------------------- 
> make[4]: Entering directory 
> `/wktrasterdevel/postgresql-8.3.5/src/backend/access/common' gcc -O2
> -Wall -Wmissing-prototypes -Wpointer-arith -Winline 
> -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing 
> -fwrapv -I../../../../src/include -I./src/include/port/win32 
> -DEXEC_BACKEND  "-I../../../../src/include/port/win32" -DBUILDING_DLL
>  -c -o printtup.o printtup.c In file included from 
> c:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/security.h:38,
>  from ../../../../src/include/libpq/libpq-be.h:50, from
> ../../../../src/include/libpq/libpq.h:21, from printtup.c:19: 
> c:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sspi.h:60: 
> error: syntax error before "SECURITY_STRING"

Googling for the error message confirms this is a known bug and small
fix is explained here:

http://archives.postgresql.org/pgsql-bugs/2009-02/msg00092.php

> So following your suggestion that "There is no need to build
> PostgreSQL" I installed 8.3.6...
> 
> Can I compile Geos with gcc? Or I have to use VC?

GEOS can be build with both. However, I have no idea if you can safely
mix binaries built with MinGW and Visual C++.

> ./configure doesn't seems to be an option.

Why?

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org