[Qgis-developer] PostGIS provider estimated extent

[Jeremy Palmer]

Hi,

I was just wondering about the purpose of r13014 which implemented a "setNoExtentEstimate" flag for a PostgreSQL connection. 

I have a little issue with this when used in conjunction with the new use estimated metadata provider option. Because the PostgreSQL connections are pooled for the postgres provider, it is possible to have the connection "hasNoExtentEstimate" flag indefinitely set when you can't get a result back from estimated_extent function for a table (see line 2777 of qgspostgresprovider.cpp). Then any new postgresprovider objects that are later created using this same pooled connection can not use the estimated_extent function, even if the database table has been appropriately analysed.

Cheers,
Jeremy

______________________________________________________________________________________________________

This message contains information, which is confidential and may be subject to legal privilege. 
If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message.
If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info at linz.govt.nz) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ.

Thank you.
______________________________________________________________________________________________________