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

[M Naveed Akram]

i upgraded to 8.4
very thanks.

but there seems to be an issue with 8.4 for UTF8, it does not allow to
create database with UTF8 Encoding.

On Thu, Jun 3, 2010 at 9:48 PM, Andy Allan <gravitystorm at gmail.com> wrote:

> 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
> >
> >
>



-- 
Regards
M Naveed Akram
http://www.google.com/profiles/cmnajs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100603/b62a47be/attachment.html>