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

2010-06-07 Thread M Naveed Akram
can anyone tell me that to which schema migration version number the new osmosis works fine On Sun, Jun 6, 2010 at 7:35 AM, Brett Henderson wrote: > On Fri, Jun 4, 2010 at 10:38 PM, Ævar Arnfjörð Bjarmason > wrote: > >> On Fri, Jun 4, 2010 at 09:40, M Naveed Akram wrote: >> > thanks to all >>

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

2010-06-05 Thread Brett Henderson
On Fri, Jun 4, 2010 at 10:38 PM, Ævar Arnfjörð Bjarmason wrote: > On Fri, Jun 4, 2010 at 09:40, M Naveed Akram wrote: > > thanks to all > > UTF8 issue resolved. > > but now its osmosis > > Last I checked osmosis hadn't been fixed to work with the latest > schema changes in the rails port, I run t

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

2010-06-04 Thread Ævar Arnfjörð Bjarmason
On Fri, Jun 4, 2010 at 09:40, M Naveed Akram wrote: > thanks to all > UTF8 issue resolved. > but now its osmosis Last I checked osmosis hadn't been fixed to work with the latest schema changes in the rails port, I run the Debian osmosis version, but it wasn't fixed in trunk either (at least the n

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

2010-06-04 Thread M Naveed Akram
thanks to all UTF8 issue resolved. but now its osmosis ./osmosis --read-xml-0.6 file="/tmp/data.osm" --write-apidb-0.6 host="localhost" database="openstreetmap" user="openstreetmap" password="aopen" validateSchemaVersion=no Jun 4, 2010 9:35:25 AM org.openstreetmap.osmosis.core.Osmosis run INFO

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

2010-06-03 Thread Andy Allan
On Thu, Jun 3, 2010 at 6:26 PM, M Naveed Akram wrote: > 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. Ah, I think I know this problem. It is very annoying. When postgres is installed, it sets a numb

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

2010-06-03 Thread Richard Weait
On Thu, Jun 3, 2010 at 1:26 PM, M Naveed Akram wrote: > 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. Works for me on 8.4.3 createdb -E UTF8 -O username gis What error are you getting? ___

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

2010-06-03 Thread 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 wrote: > According to http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL: > > "PostgreSQL doesn't have th

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

2010-06-03 Thread Andy Allan
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 wrote: > 8.2 > > On Thu, Jun 3, 2010 at

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

2010-06-03 Thread M Naveed Akram
8.2 On Thu, Jun 3, 2010 at 4:48 PM, Shaun McDonald 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", "Rela

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

2010-06-03 Thread Shaun McDonald
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 migr

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

2010-06-03 Thread M Naveed Akram
== 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',