[postgis-devel] Transform() PROJ4 cache patch

[Mark Cave-Ayland]

> -----Original Message-----
> From: strk at refractions.net [mailto:strk at refractions.net] 
> Sent: 07 November 2005 10:39
> To: Mark Cave-Ayland (External)
> Cc: postgis-devel at postgis.refractions.net
> Subject: Re: [postgis-devel] Transform() PROJ4 cache patch
> 
> 
> There's a SPI_execute() call that should be changed to 
> SPI_exec or compile-time switched (SPI_execute was introduced in 8.0).
> 
> Apart from that I think you can commit.
> Thanks!
> 
> --strk;


Hi strk,

Thanks for the review :) I've since discovered that caching per backend is
wrong, and in fact it is necessary to cache per portal - otherwise the cache
doesn't behave correctly when using combinations of normal interactive
queries, prepared statements and cursors. While I still think it can be
done, I'm going to ask for some advice on pgsql-hackers as the solution
starts to get a lot more messy....


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com 
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.