[postgis-users] Vacuum analyse ERROR: Operation on two GEOMETRIESwith different SRIDs

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Sergey Karin
> Sent: 15 June 2005 10:35
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Vacuum analyse ERROR: Operation 
> on two GEOMETRIESwith different SRIDs

(cut)

> > I recommend you use the 1.x series.
> > --strk;
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> 
> Okay. But what about vacuum analyse? 


Hi Sergey,

Can you try doing the vacuum and the analyze separately to see which one
causes the failure, e.g.

	VACUUM;
	ANALYZE VERBOSE;

I'm just wondering if it's to do with ANALYZE invoking a geometry comparison
using the btree operators for "less than" and "equals" for PostgreSQL < 8.0.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk