Hi, We are connecting dbWalker to a postgres table. We are getting an Internal Server Error during the walk. When we click on "Test" in dbwalker, it shows our key field values listed, but clicking on any of them gives this error:
com.thunderstone.DBWalker.ConfigurationException: SQL Error: java.sql.SQLException: ERROR: operator does not exist: bigint = character varying
We tried with postgres 9.2 and 10. We have tried several tests, the latest test table is this:
lname character varying(20) NOT NULL,
fname character varying(20),
The key-field specified in DB Walker is the myid field.
FYI - If I make a view that has all these fields from the table but casts the myid field to varchar, then I can point DBWalker to the view instead of the table and use myid as the key. I can also include additional numeric fields and it will read them. I just can't seem to use a numeric field as the key in a dbwalker setup with postgres. I've tried numeric, smallint, integer, and bigint types.