[postgis-users] Question about the regression tests on Windows

[DANTE ALEXANDRA]

Hello List,

I got a question about the PostGIS regression tests.
Using MinGW and Msys, I have compiled PostGreSQL 8.1.3, Geos 2.2.1, Proj 
4.4.9 and PostGIS 1.1.2 on Windows 2000 Professionnel.
As my system is a french one, "initdb" has built the database cluster 
using as locale support "French_France.1252". So to run the regression 
tests, I have done :
- stop the postmaster
- modify the "postgresql.conf" file to set :
# These settings are initialized by initdb -- they might be changed
lc_messages = 'C'#'French_France.1252'                  # locale for 
system error message strings
lc_monetary = 'C'#'French_France.1252'                  # locale for 
monetary formatting
lc_numeric = 'C'#'French_France.1252'                   # locale for 
number formatting
lc_time = 'C'#'French_France.1252'                      # locale for 
time formatting
- restart the postmaster
- go to the repertory of the PostGIS sources which is 
"/home/dantea/sources/PostGIS/postgis-1.1.2/" (that is to say 
"C:\msys\1.0\home\dantea\sources\PostGIS\postgis-1.1.2"), directory 
where PostGIS was compiled
- launch the "make test" command.

By doing this, I got this error :
$ make test
make -C ../lwgeom all-shared-libm
make[1]: Entering directory 
`/home/dantea/sources/PostGIS/postgis-1.1.2/lwgeom'
make[1]: Nothing to be done for `all-shared-lib'.
make[1]: Leaving directory 
`/home/dantea/sources/PostGIS/postgis-1.1.2/lwgeom'
Creating spatial db postgis_reg
ERROR:  function postgis_lib_version() does not exist
HINT:  No function matches the given name and argument types. You may 
need to add explicit type casts.
   Something went wrong (no postgis installed in postgis_reg).
   Check /tmp/regress_log_1704 for details.
make: *** [test] Error 1


The postmaster logfile contained :
ERROR:  could not access file 
"home/dantea/sources/PostGIS/postgis-1.1.2/lwgeom/liblwgeom.dll": No 
such file or directory


So I do a search on the files of the repertory 
"C:\msys\1.0\home\dantea\sources\PostGIS\postgis-1.1.2\regress", and I 
understand that the problem come from the file "lwpostgis.sql" which has 
the full path of the libraries :
CREATE OR REPLACE FUNCTION histogram2d_in(cstring)
   RETURNS histogram2d
   AS '/home/dantea/sources/PostGIS/postgis-1.1.2/lwgeom/liblwgeom.dll', 
'lwhistogram2d_in'
   LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);

I have replaced all the strings 
"/home/dantea/sources/PostGIS/postgis-1.1.2/" by 
"C:/msys/1.0/home/dantea/sources/PostGIS/postgis-1.1.2/", and I have 
launched again "make check" => the 12 tests are successfull !
$ make test
make -C regress test
make[1]: Entering directory 
`/home/dantea/sources/PostGIS/postgis-1.1.2/regress'
make -C ../lwgeom all-shared-lib
make[2]: Entering directory 
`/home/dantea/sources/PostGIS/postgis-1.1.2/lwgeom'
make[2]: Nothing to be done for `all-shared-lib'.
make[2]: Leaving directory 
`/home/dantea/sources/PostGIS/postgis-1.1.2/lwgeom'
Creating spatial db postgis_reg

PostgreSQL 8.1.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 
(mingw-special)

Postgis 1.1.2
- 2006-04-20 09:37:15

  GEOS: 2.2.1-CAPI-1.0.1

  JTS:

  PROJ: Rel. 4.4.9, 29 Oct 2004


Running tests

          regress: Ok.
    regress_index: Ok.
   lwgeom_regress: Ok.
      regress_lrs: Ok.
      removepoint: Ok.
         setpoint: Ok.
         simplify: Ok.
       snaptogrid: Ok.
           affine: Ok.
      regress_ogc: Ok.
   regress_bdpoly: Ok.
     regress_proj: Ok.

Run tests: 12
Successful: 12
Failed: 0
make[1]: Leaving directory 
`/home/dantea/sources/PostGIS/postgis-1.1.2/regress'


I give you the postmaster logfile :
LOG:  transaction ID wrap limit is 2147484146, limited by database 
"postgres"
NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type histogram2d is only a shell
NOTICE:  type "spheroid" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type spheroid is only a shell
NOTICE:  type "geometry" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type geometry is only a shell
NOTICE:  return type geometry is only a shell
NOTICE:  argument type geometry is only a shell
NOTICE:  type "box3d" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type box3d is only a shell
NOTICE:  type "chip" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type chip is only a shell
NOTICE:  type "box2d" is not yet defined
DETAIL:  Creating a shell type definition.
NOTICE:  argument type box2d is only a shell
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"spatial_ref_sys_pkey" for table "spatial_ref_sys"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"geometry_columns_pk" for table "geometry_columns"
ERROR:  parse error - invalid geometry
ERROR:  parse error - invalid geometry
ERROR:  parse error - invalid geometry
ERROR:  parse error - invalid geometry
ERROR:  parse error - invalid geometry
ERROR:  parse error - invalid geometry
ERROR:  geometry contains non-closed rings
ERROR:  geometry contains non-closed rings
ERROR:  parse error - invalid geometry
ERROR:  parse error - invalid geometry
ERROR:  parse error - invalid geometry
ERROR:  geometry requires more points
ERROR:  parse error - invalid geometry
ERROR:  Can't remove points from a single segment line
ERROR:  Point index out of range (0..2)
ERROR:  Point index out of range (0..2)
ERROR:  Point index out of range (0..2)
ERROR:  Point index out of range (0..2)
ERROR:  First argument must be a LINESTRING
ERROR:  Third argument must be a POINT
NOTICE:  Self-intersection
NOTICE:  IllegalArgumentException: Number of points must be 0 or >3
ERROR:  POSTGIS2GEOS conversion failed
ERROR:  Input is not a MultiLinestring
ERROR:  Input is not a MultiLinestring
ERROR:  Input returns more then a single polygon, try using 
BdMPolyFromText instead
ERROR:  Input geometry has unknown (-1) SRID
LOG:  transaction ID wrap limit is 2147484146, limited by database 
"postgres"


Have you already encounter this problem of "path" in the lwpostgis.sql 
file ?
Why do this file, stored in the "regress" directory, contain this path ?
Have you already passed the regression tests ?

Thank you for your help.
Regards,
Alexandra DANTE