Forum OpenACS Q&A: problem in load-data-model.sql

Collapse
1: problem in load-data-model.sql
Posted by amit singh on 11/16/00 05:15 AM
When i load database with psql -f load-data-model.sql mydb 2>
datamodel.txt. I get following errors. I am using postgres 6.5.3 rpm
on redhat 6.2 with acs/pg 3.2.4.

ERROR:  Unrecognized language specified in a CREATE FUNCTION:
'plpgsql'.  Recognized languages are sql, C, internal and the created
procedural languages.

NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'lob_data_pkey' for table 'lob_data'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)

can someone tell me how to get rid of these errors load-geo-tables
works fine

thanks

amitks

Collapse
2: Response to problem in load-data-model.sql (response to 1)
Posted by Don Baccus on 11/16/00 01:31 PM
The first error simply means you haven't defined the language plpgsql.  The easiest way to do this is to log in as the postgres user, and do a "createlang plpgsql your_database_name".  Then you'll be able to define functions.

The other messages aren't ERRORs, they're NOTICEs telling you of extra  things Postgres is creating implicitly as a result of the datamodel definitions.  Ignore them.