[OSM-dev] type "four_byte_unsigned" does not exist

Dan Karran dan at karran.net
Tue May 26 22:08:19 BST 2009


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 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 <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
www.dankarran.com




More information about the dev mailing list