[BioSQL-l] postgres 8.3 will not cast text to integer any longer
Erik
er at xs4all.nl
Thu Mar 20 19:24:12 UTC 2008
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
More information about the BioSQL-l
mailing list