I have been building an RoR app. I've been making heavy use of
Migrations for database work and like the system. I am currently using
PostgreSQL for the backend.
One annoying aspect of migrations is that it doesn't (yet) support
decimal fields - when migration moves data from dev to test it converts
them to float. I've learned to work around this with some manual "alter
table" statements in my migration. (It also looks like this will be
fixed in a future release of Rails:
However, I have similar problem which I can't figure out how to fix
easily. I played around with activating a GIS feature in Postgres which
permits easy distance / radius searching. In order to enable this,
Postgres builds 6-7 system tables in my database.
Now when I run migrations, RoR is dropping these system tables and
attempting to re-create them using it's broken understanding of their
structure (converting field types willy-nilly, including changing some
custom datatypes into floats). This behavior is breaking the GIS
support (of course).
Does anyone have any thoughts or experience on how to have RoR suppress
migrations on specific tables in the database? I'm hoping I'm missing
some easy configuration that will tell Rails to ignore certain tables..
Thanks for any advice or assistance!