[postgis-users] PostGIS with Mapserver/Mapscript 4.0

Mike Leahy mgleahy at fes.uwaterloo.ca
Mon Sep 15 19:14:01 PDT 2003


David,

I apologize if I'm asking what may be an obvious question, but can you tell me 
where I would find the version of PostGIS that you plan to comit these changes 
to?  Is it the CVS download on the postgis.refractions.net downloads page?  If 
so, I was not able to compile that version (the results from my attempt are 
below).

Sorry if I'm way off here - perhaps I just don't know exactly how to use CVS 
version...what would I have to do differently compared to compiling 0.7.5?

Kind regards,
Mike

Output from compiling CVS source code:

gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -
I. -DFRONTEND -DSYSCONFDIR='"/etc/postgresql"'
-DUSE_VERSION=73 -I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -
DUSE_PROJ  -DUSE_STATS  -I../../src/include   -c
-o postgis_debug.o postgis_debug.c
postgis_debug.c: In function `lockcheck':
postgis_debug.c:231: warning: return makes integer from pointer without a cast
postgis_debug.c:252: warning: return makes integer from pointer without a cast
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -
I. -DFRONTEND -DSYSCONFDIR='"/etc/postgresql"'
-DUSE_VERSION=73 -I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -
DUSE_PROJ  -DUSE_STATS  -I../../src/include   -c
-o postgis_ops.o postgis_ops.c
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -
I. -DFRONTEND -DSYSCONFDIR='"/etc/postgresql"'
-DUSE_VERSION=73 -I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -
DUSE_PROJ  -DUSE_STATS  -I../../src/include   -c
-o postgis_fn.o postgis_fn.c
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -
I. -DFRONTEND -DSYSCONFDIR='"/etc/postgresql"'
-DUSE_VERSION=73 -I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -
DUSE_PROJ  -DUSE_STATS  -I../../src/include   -c
-o postgis_inout.o postgis_inout.c
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -
I. -DFRONTEND -DSYSCONFDIR='"/etc/postgresql"'
-DUSE_VERSION=73 -I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -
DUSE_PROJ  -DUSE_STATS  -I../../src/include   -c
-o postgis_proj.o postgis_proj.c
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -
I. -DFRONTEND -DSYSCONFDIR='"/etc/postgresql"'
-DUSE_VERSION=73 -I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -
DUSE_PROJ  -DUSE_STATS  -I../../src/include   -c
-o postgis_chip.o postgis_chip.c
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -
I. -DFRONTEND -DSYSCONFDIR='"/etc/postgresql"'
-DUSE_VERSION=73 -I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -
DUSE_PROJ  -DUSE_STATS  -I../../src/include   -c
-o postgis_transform.o postgis_transform.c
postgis_transform.c:49:22: projects.h: No such file or directory
postgis_transform.c:52: parse error before '*' token
postgis_transform.c:52: warning: type defaults to `int' in declaration of 
`make_project'
postgis_transform.c:52: warning: data definition has no type or storage class
postgis_transform.c:56: parse error before '*' token
postgis_transform.c:61: parse error before '*' token
postgis_transform.c:64: warning: no previous prototype for 
`pj_transform_nodatum'
postgis_transform.c: In function `pj_transform_nodatum':
postgis_transform.c:68: `pj_errno' undeclared (first use in this function)
postgis_transform.c:68: (Each undeclared identifier is reported only once
postgis_transform.c:68: for each function it appears in.)
postgis_transform.c:70: `point_offset' undeclared (first use in this function)
postgis_transform.c:73: `srcdefn' undeclared (first use in this function)
postgis_transform.c:75: `point_count' undeclared (first use in this function)
postgis_transform.c:77: `XY' undeclared (first use in this function)
postgis_transform.c:77: parse error before "projected_loc"
postgis_transform.c:78: `LP' undeclared (first use in this function)
postgis_transform.c:80: `projected_loc' undeclared (first use in this function)
postgis_transform.c:80: `x' undeclared (first use in this function)
postgis_transform.c:81: `y' undeclared (first use in this function)
postgis_transform.c:83: `geodetic_loc' undeclared (first use in this function)
postgis_transform.c:83: warning: implicit declaration of function `pj_inv'
postgis_transform.c:92: `dstdefn' undeclared (first use in this function)
postgis_transform.c:96: parse error before "projected_loc"
postgis_transform.c:102: warning: implicit declaration of function `pj_fwd'
postgis_transform.c: In function `to_rad':
postgis_transform.c:122: `PI' undeclared (first use in this function)
postgis_transform.c: In function `to_dec':
postgis_transform.c:133: `PI' undeclared (first use in this function)
postgis_transform.c: At top level:
postgis_transform.c:140: parse error before '*' token
postgis_transform.c:141: warning: return type defaults to `int'
postgis_transform.c: In function `make_project':
postgis_transform.c:146: `PJ' undeclared (first use in this function)
postgis_transform.c:146: `result' undeclared (first use in this function)
postgis_transform.c:176: warning: implicit declaration of function `pj_init'
postgis_transform.c: In function `transform_geom':
postgis_transform.c:194: `PJ' undeclared (first use in this function)
postgis_transform.c:194: `input_pj' undeclared (first use in this function)
postgis_transform.c:194: `output_pj' undeclared (first use in this function)
postgis_transform.c:194: warning: left-hand operand of comma expression has no 
effect
postgis_transform.c:239: `pj_errno' undeclared (first use in this function)
postgis_transform.c:250: warning: implicit declaration of function `pj_free'
postgis_transform.c:276: warning: implicit declaration of function 
`pj_transform'
postgis_transform.c:291: warning: implicit declaration of function 
`pj_strerrno'
postgis_transform.c:291: warning: format argument is not a pointer (arg 4)
postgis_transform.c:332: warning: format argument is not a pointer (arg 4)
make: *** [postgis_transform.o] Error 1

Quoting David Blasby <dblasby at refractions.net>:

> Mike Leahy wrote:
> > WARNING: BEGIN: already a transaction in progress WARNING: Closing pre-
> > existing portal "mycursor" WARNING: BEGIN: already a transaction in
> progress 
> > WARNING: Closing pre-existing portal "mycursor" WARNING: BEGIN: already a 
> > transaction in progress WARNING: Closing pre-existing portal "mycursor" 
> > WARNING: etc...
> 
> Yes - this is a problem with me not closing the transaction when you're 
> doing queries.  I've fixed it - I just need to commit the changes.
> 
> It shouldnt be giving you these problems after this.
> 
> > So here's my question to the PostgreSQL/PostGIS experts - is there any way
> I 
> > can prevent PostgreSQL/PostGIS from writing its warning messages to the
> output 
> > from the PHP script?  I have no idea where the logs from the postmaster 
> > service are being saved - I'd prefer if I could get the warnings sent there
> 
> > only, and not to the mapscript DLL.
> 
> These warnings are being generated by postgresql.  I believe the default 
> libpq behaviour is to send them to stderr.  You can modify this by 
> writing a custom notice handler for libpq and either eating the errors 
> or redirecting them else where.
> 
> dave
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 




----------------------------------------
This mail sent through www.mywaterloo.ca



More information about the postgis-users mailing list