[OSM-dev] Field lengths in Rails port

Andy Allan gravitystorm at gmail.com
Wed Jun 30 08:46:08 BST 2010


On Wed, Jun 30, 2010 at 8:39 AM, Frederik Ramm <frederik at remote.org> wrote:
> Hi,
>
>   looking at the migrations I find that integer database fields are
> created with wildly different "limits":
>
> For example, ID columns are created with :limit=>64 whereas e.g. the
> version number has :limit=>11.

Yeah, I found that a right royal PITA when I was writing the postgres
port of the rails port during the 0.6 upgrade.

> Is this all basically disregarded, and all boils down to 4-byte signed
> integers, or what?

Postgres ignores them, IIRC, since it doesn't have such a concept. I'm
sure one day some numbers will get too big for mysql, but hey.

Cheers,
Andy




More information about the dev mailing list