[postgis-users] Get ST_Value results from a tiled raster

[Robin Wilson]

Hi bborie,

Thanks for the idea. I've set up the logging and checked and only one query is being sent by the client. I've also checked the code used by the client, which simply runs one query and gets the results.

Does anyone have any idea why this may be happening?

Cheers,

Robin

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Robin,

I can't say for certain but it looks like your client (not psql) is
sending off multiple queries.  The nulls would return if the point being
sampled isn't in any of the tiles.

You could enable statement logging (log_statement) in PostgreSQL to see
what statements are being run from your connector.

http://www.postgresql.org/docs/9.0/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT

-bborie
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120629/b575d189/attachment.html>