Postgres Import Error-messages

[luftikus143]

Hi,

there seems to be a problem with the content of a couple of the fields.
When I did the import (of allCountries.txt) into Postgres - with the
definition of the fields as indicated on the download page at the
bottom - I still get a couple of error messages, like these here:

Row34078 - ERROR: invalid input syntax for type double precision: "P"

Row40374 - ERROR: invalid input syntax for type double precision: "P"

Row53636 - ERROR: invalid input syntax for type double precision: "T"

Row53781 - ERROR: invalid input syntax for type double precision: "H"

Row53949 - ERROR: value too long for type character(1)

Any ideas?

[Marc]

Hi

I have found two errors. One was with the database dumper. It has dumped
null values for featurecode as 'null'. The other one was a 'tab' in an
alternate name. I have removed the 'tab' and added some automatic 'tab'
removal code in the update methods.
Both problems should be fixed with the next daily dump, and you should
be able to load it.

Marc

[Stefan Schwarzer]

Thanks!

There are still a few errors:

Import log (2006-05-15 15:24:59)

Row34078 - ERROR: invalid input syntax for type double precision: "P"

Row40374 - ERROR: invalid input syntax for type double precision: "P"

Row53636 - ERROR: invalid input syntax for type double precision: "T"

Row53781 - ERROR: invalid input syntax for type double precision: "H"

Import was canceled by user. (2006-05-15 15:31:24)

And besides: I use NavicatPostgres to insert the data, but it crashes
after some time. Any suggestions for other tools that I can try,
preferably for a Mac?

Thanks!

[Marc]

Hi Stefan

I use simple psql to import the dump into postgres. I have just created
a faq entry for this :

http://forum.geonames.org/gforum/posts/list/67.page

Could you try with the command as described in the faq and with a new dump?

Regards,

Marc