search

ricardochimal / taps

simple database import/export app
MIT License
1.2k stars 140 forks source link

Unable to pull table with string primary key #59

Closed channels closed 13 years ago

channels commented 13 years ago

I'm trying to import a TRAC db that is in postgres to a local sqlite db.

Most tables work fine, but the wiki table has a text primary key and the import fails with the following error:

Sequel::DatabaseError - PGError: ERROR: operator does not exist: text > integer LINE 1: SELECT * FROM "wiki" WHERE ("name" > 0) ORDER BY "name", "ve... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Rest of stack trace here: https://gist.github.com/708644

Anyone know if there is a work around?

Thanks

channels commented 13 years ago

bad login, re-entering issue with my personal github login