[OSM-dev] Problem in rake db:migrate with postgre

Andy Allan gravitystorm at gmail.com
Thu Jun 3 17:48:25 BST 2010


According to http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL:

"PostgreSQL doesn't have the ENUM types prior to 8.3"

I think it would be easiest to upgrade your version of postgres.

Cheers,
Andy

On Thu, Jun 3, 2010 at 12:54 PM, M Naveed Akram <cmnajs at gmail.com> wrote:
> 8.2
>
> On Thu, Jun 3, 2010 at 4:48 PM, Shaun McDonald <shaun at shaunmcdonald.me.uk>
> wrote:
>>
>> Which version of Postgres are you using?
>>
>> Shaun
>>
>> On Thu, June 3, 2010 11:24 am, M Naveed Akram wrote:
>> > == AddRelations: migrating =======================================
>> > -- create_enumeration(:nwr_enum, ["Node", "way", "Relation"])
>> > rake aborted!
>> > An error has occurred, this and all later migrations canceled:
>> > PGError: ERROR: syntax error at or near "enum"
>> > LINE 1: create type nwr_enum as enum ('Node', 'Way', 'Relation')
>> >                                                  ^
>> > : create type nwr_enum as enum ('Node', 'Way', 'Relation')
>> >
>> > --
>> > Regards
>> > M Naveed Akram
>> > http://www.google.com/profiles/cmnajs
>> > _______________________________________________
>> > dev mailing list
>> > dev at openstreetmap.org
>> > http://lists.openstreetmap.org/listinfo/dev
>> >
>>
>>
>
>
>
> --
> Regards
> M Naveed Akram
> http://www.google.com/profiles/cmnajs
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>
>




More information about the dev mailing list