[postgis-users] Vacuum analyse ERROR: Operation on two GEOMETRIESwith different SRIDs
sergey.karin at gmail.com
Wed Jun 15 03:29:17 PDT 2005
2005/6/15, strk at refractions.net <strk at refractions.net>:
> On Wed, Jun 15, 2005 at 11:09:10AM +0100, Mark Cave-Ayland wrote:
> > > -----Original Message-----
> > > From: Sergey Karin [mailto:sergey.karin at gmail.com]
> > > Sent: 15 June 2005 10:50
> > > To: Mark Cave-Ayland (External)
> > > Subject: Re: [postgis-users] Vacuum analyse ERROR: Operation
> > > on two GEOMETRIESwith different SRIDs
> > > INFO: analyzing "public.workspace"
> > > INFO: "workspace": 1 pages, 15 rows sampled, 15 estimated total rows
> > > ERROR: Operation on two GEOMETRIES with different SRIDs
> I've verified this myself.
> Yes, it's btree ops involved. Even in 1.x series.
> analyze verbose can show the corrupted table, but question is:
> should a table containing mixed-SRID geometries be really considered
> corrupted ?
> The btree ops are really just place-holders to allow DISTINCT
> and ORDER BY operations, we could change their
> semantics to include SRID in their checks (compare SRID number,
> upper-left X and Y values, lower-right X and Y values).
> What do you think ?
> postgis-users mailing list
> postgis-users at postgis.refractions.net
strk, If my syggestion is interest, I think that table containing
mixed-SRID geometries shouldn't be considered corrupted!
More information about the postgis-users