[postgis-users] Seeing the value of a geometry string before an error message is issued.

[Mark Cave-Ayland]

David Potts wrote:

> Hi
> 
> I am using hibernate spatial as a front end to postgis(8.3) database
> within a java program.
> 
> As far as I can tell, a valid sql statment is generated,  I pass in
>   what I think is a valid geometry string.
> 
> I am getting a 'invalid geometry' error message.
> 
> Short off rebuilding the liblwgeom library is there any easy way off
> getting a copy of the string that postgis being passed?
> 
> I want to ensure that what I am passing in to hibernate is actual being
> supplied to postgis correctly.
> 
> I have turned on on the postgres statment processing in the postgres log
> just shows the geometry string being passed in as the string '$1.'  Which
> is I  assume its method of showing a binary argument.
> 
> D.

Hmmm newer versions of PostgreSQL should log the bind parameters with 
log_statement set to 'all'. See 
http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html#GUC-LOG-STATEMENT 
for more details.


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs