DBIx::Browse::CGI and boolean on Postgresql



Hello there!

I´m implementing an interface for a table in postgres using the
DBIx::Browse::CGI... it´s very good... with a 30 line code I´m able
to list the entire contents of a table, filter these contents by
(almost - back to it later) any field in the table and edit them
individually.

Now comes the forementioned almost. It doesn´t work well with boolean
types, since it uses the database patern matching operator '~*' that
doesn´t work on boolean fields. Any idea for this problem short of
altering the database for a char type?

Error Message: "Error from database: ERROR: Unable to identify an
operator '~*' for types 'boolean' and '"unknown"'
At DBIx::Browse::CGI, /usr/lib/perl5/site_perl/5.8.0/DBIx/Browse/CGI.pm
line 142."

Another problem I have is when trying to update the data. My primary
key has both letters and digits, whenever I try to update the data, it
down cases all the letters in the form and tries to match (again the
*~) against the uper case stored ones. Any ideas on that short of
editing the module?

Error Message: "rror from database: ERROR: Attribute "aaa17333" not
found

At DBIx::Browse, /usr/lib/perl5/site_perl/5.8.0/DBIx/Browse.pm line
454."

Thanks a bunch,
-Otávio

.