[BioSQL-l] postgres 8.3 will not cast text to integer any longer

[Erik]

Hi,

(latest BioSQL, bioperl-db, and bioperl-live installed.)

Postgres 8.3 will not auto-cast text (='character
varying') to integer any longer, which causes test
t/16odba.t to fail:


------------- EXCEPTION: Bio::Root::Exception -------------
MSG: error while executing query in
Bio::DB::BioSQL::SeqAdaptor::find_by_query: ERROR: 
operator does not exist: character varying = integer
LINE 1: ...eq.taxon_id FROM bioentry seq WHERE
seq.identifier = 5456929

It seems likely to cause many similar statements to fail;
how should this be solved?

I tried to fix it but I couldn't find the place where the
statement/clauses are put together.


Thanks,

Erik Rijkers