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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
