taps icon indicating copy to clipboard operation
taps copied to clipboard

Unable to pull table with string primary key (psql to sqlite)

Open apsoto opened this issue 15 years ago • 0 comments

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

apsoto avatar Nov 21 '10 11:11 apsoto