Forum OpenACS Q&A: Data model loading error
psql:bboard.sql:152: ERROR: Unable to identify an operator '=' for
types 'character' and 'character varying'
You will have to retype this query using an explicit cast
psql:bboard.sql:156: ERROR: Relation "bboard" does not exist
I found a thread from last August concerning this problem but not an
answer to it. Postgres 7.2 has been here already for a while and I
hope there's already a solution for this problem.
Just encountered this problem myself. Here is the fix, in ~/www/doc/sql/bboard.sql:
create table bboard (
fips_county_code char(5) references counties,
fips_county_code varchar(5) references counties,
and then bboard db table would be loaded correctly.
hope this help, though a bit late.