Geometric types (was Re: [PATCHES] guc) - Mailing list pgsql-hackers

From Tom Lane
Subject Geometric types (was Re: [PATCHES] guc)
Date
Msg-id 4817.1011335502@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] guc  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Not really.  I'd much rather see the EPSILON removed/revised.  I don't
> claim to understand numerical analysis, but that thing is completely
> bogus.

Yeah, and there's even the handy comment:
*      XXX These routines were not written by a numerical analyst.

to remind you that this stuff was written by someone who was studying
databases not numerical analysis.

In my eyes, all of our geometric datatypes are firmly in the "academic
toy prototype" category.  They could use a thorough overhaul, but in
view of the existence of the PostGIS project I doubt they'll ever get
one.  Anyone who might have both the ability and the motivation to
improve these datatypes will probably go use/work on PostGIS instead.

I could make an argument that we should just yank these types from the
distribution and leave the field clear for PostGIS.  I don't really want
to take that line; the types do have usefulness for simple applications,
and what's probably more important is they help keep us honest on
datatype extensibility concerns.  But I have a hard time justifying
spending any core development time on them.

Basically what I want is some fairly simple answer that will let us stop
wasting quite so much maintenance effort on the geometry regression
test.  Because, frankly, that code is nowhere near good enough to
justify our expending much time on it.

In that context, trimming the number of displayed decimal places seems
like a great solution.  Whether it's the "right thing" from a purist's
viewpoint doesn't concern me a whole lot.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: tuptoaster.c must *not* use SnapshotAny
Next
From: Bruce Momjian
Date:
Subject: Re: Bug in pg_dump/restore -o