Forum OpenACS Q&A: Data model loading error

Request notifications

Collapse
Posted by Jarkko Laine on
I get the following error when loading data model:

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.

Thanks,

Jarkko

Collapse
Posted by Kenny Chan on
Jarkko,

Just encountered this problem myself. Here is the fix, in ~/www/doc/sql/bboard.sql:

create table bboard (

change this:

fips_county_code char(5) references counties,

into:

fips_county_code varchar(5) references counties,

and then bboard db table would be loaded correctly.

hope this help, though a bit late.

Sincerely,