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 <[email protected]> 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 <[email protected]> wrote: > > 8.2 > > > > On Thu, Jun 3, 2010 at 4:48 PM, Shaun McDonald < > [email protected]> > > 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 > >> > [email protected] > >> > http://lists.openstreetmap.org/listinfo/dev > >> > > >> > >> > > > > > > > > -- > > Regards > > M Naveed Akram > > http://www.google.com/profiles/cmnajs > > > > > > _______________________________________________ > > dev mailing list > > [email protected] > > http://lists.openstreetmap.org/listinfo/dev > > > > > -- Regards M Naveed Akram http://www.google.com/profiles/cmnajs
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
