Forum OpenACS Q&A: Data model loading error

Collapse
1: Data model loading error
Posted by Jarkko Laine on 05/29/02 10:32 AM
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
2: Response to Data model loading error (response to 1)
Posted by Kenny Chan on 08/22/02 05:15 PM
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,