Re: New geographic types.... - Mailing list pgsql-general

From Tom Lane
Subject Re: New geographic types....
Date
Msg-id 15776.957913192@sss.pgh.pa.us
Whole thread Raw
In response to New geographic types....  (Franck Martin <Franck@sopac.org.fj>)
List pgsql-general
Franck Martin <Franck@sopac.org.fj> writes:
> As part of the Fmaps project (Fmaps.sourceforge.net), Eric Miller is
> developing some new geographic types for Postgres.

Cool!

> We have several questions relating to the implementation of new types,
> variable types, and especially how to index them.

Datatype questions in general we can deal with.  Are you planning to use
r-tree indices, or perhaps something even more esoteric?  You might be a
little bit on your own there; I don't think any of the currently active
developers know much about the r-tree code.

> For the moment we are developing the new types/functions
> as extensions, should it stays that way or what does it imply to be merged
> in the main distribution.

If you are willing to release your code under the Postgres license terms
(basically BSD) then I think we'd be interested in including these types
in the distribution --- certainly in the contrib area, maybe integrated
into the standard build if there seems to be enough interest in 'em.

> We will be glad if someone can point us to some documentation on the
> subject, as the developer doc that comes with PG is very short on the
> subject.

The docs are kind of weak; there's little substitute for looking at
existing code you can use as a model.  Asking questions on the lists
is good too.

> For Fmaps to be complete, we will need a toasted version of PG where the 8kB
> limit has been removed, and works with custom types. Can someone give a
> status on toasted PG (working, not working, stable enough, unstable,...)

This should happen for 7.1 which we are hoping to have out circa Aug-Sep.
Jan Wieck would have to be the one to give you any more-detailed
projection than that.  It's certainly not there yet in any usable form.

            regards, tom lane

pgsql-general by date:

Previous
From: "J. Atwood"
Date:
Subject: 7.0 RPM?
Next
From: Tom Lane
Date:
Subject: Re: Problems compiling version 7