[OSM-dev] type "four_byte_unsigned" does not exist
warren at mit.edu
Tue May 26 22:38:05 BST 2009
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.
On Tue, May 26, 2009 at 2:08 PM, Dan Karran <dan at karran.net> wrote:
> Hi Jeff,
> 2009/5/26 Jeffrey Warren <warren at mit.edu>:
> > I noticed that during db:migrate it doesn't pick up the /lib/migrate.rb
> > definitions... so I just changed it to :integer, :limit => 8, which is
> > four_byte_unsigned is defined in migrate.rb.
> > I'm also setting up the rails port and am having trouble so if you want
> > 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? :)
> > Best,
> > Jeff
> > On Tue, May 26, 2009 at 1:31 PM, Dan Karran <dan at karran.net> 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
> >> dan at karran.net
> >> www.dankarran.com
> >> _______________________________________________
> >> dev mailing list
> >> dev at openstreetmap.org
> >> http://lists.openstreetmap.org/listinfo/dev
> Dan Karran
> dan at karran.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev