which migration is that? I need pgsql so I'm sticking to my guns, but i think i'm doing all right now... i briefly had a problem with btree_gist but after struggling to make that, i retried rake db:migrate and i successfully completed the migrations. if you have booted the application in another shell before running rake db:migrate, you get a much more verbose set of errors in that first script/server shell, which really helped me figure out what was failing.
what's failing specifically in the migration in question? BTW, Tom's fix is a much better idea than mine, esp. since it'll be making its way into the trunk code whereas mine's just a hack. Jeff On Tue, May 26, 2009 at 2:08 PM, Dan Karran <[email protected]> wrote: > Hi Jeff, > > 2009/5/26 Jeffrey Warren <[email protected]>: > > I noticed that during db:migrate it doesn't pick up the /lib/migrate.rb > type > > definitions... so I just changed it to :integer, :limit => 8, which is > how > > four_byte_unsigned is defined in migrate.rb. > > I'm also setting up the rails port and am having trouble so if you want > to > > compare notes I'd love to. > > Thanks, though it doesn't seem to get much further than that once I've > made the change, stopping after trying to remove the index points_idx. > > Would you be able to send over a diff of any necessary changes you've > made? Is it any more successful with MySQL? :) > > > > Cheers, > Dan > > > Best, > > Jeff > > > > On Tue, May 26, 2009 at 1:31 PM, Dan Karran <[email protected]> wrote: > >> > >> I'm trying to set up a copy of the rails site on my machine, using > >> Postgres, but I'm running into a problem on the initial db:migrate ... > >> can anyone point me to how to fix this? > >> > >> > >> ===== > >> > >> rake db:migrate --trace > >> (in /Users/dankarran/Sites/openstreetmap) > >> ** Invoke db:migrate (first_time) > >> ** Invoke environment (first_time) > >> ** Execute environment > >> ** Execute db:migrate > >> == TileTracepoints: migrating > >> ================================================ > >> -- add_column("gps_points", "tile", :four_byte_unsigned) > >> rake aborted! > >> An error has occurred, this and all later migrations canceled: > >> > >> PGError: ERROR: type "four_byte_unsigned" does not exist > >> LINE 1: ALTER TABLE "gps_points" ADD COLUMN "tile" four_byte_unsigne... > >> ^ > >> : ALTER TABLE "gps_points" ADD COLUMN "tile" four_byte_unsigned > >> > >> ===== > >> > >> > >> Thanks, > >> Dan > >> > >> -- > >> Dan Karran > >> [email protected] > >> www.dankarran.com > >> > >> _______________________________________________ > >> dev mailing list > >> [email protected] > >> http://lists.openstreetmap.org/listinfo/dev > > > > > > > > -- > Dan Karran > [email protected] > www.dankarran.com >
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
