While in directory
/home/acs/openacs-3.2.5/www/doc/sql
when i give the command 'psql acs -f load-data-model.sql'
<<here acs is my database name>>
it gives the following errors:
permitted to create a function in the 'C' language.
2 Others may use the 'sql' language or the created procedural languages.
3 psql:postgres.sql:18: ERROR: Only users with Postgres superuser privilege are permitted to create procedural languages
4 psql:postgres.sql:27: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
5 Recognized languages are sql, C, internal, and created procedural languages.
6 psql:postgres.sql:38: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
7 Recognized languages are sql, C, internal, and created procedural languages.
8 psql:postgres.sql:44: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
9 Recognized languages are sql, C, internal, and created procedural languages.
10 psql:postgres.sql:52: ERROR: Function 'sysdate()' does not exist
11 Unable to identify a function that satisfies the given argument types
12 You may need to add explicit typecasts
****************************************
****************************************
****************************************
_idx' already exists
2499 psql:photodb.sql:286: ERROR: Cannot create index: 'ph_prest_photo_by_photo_idx' already exists
2500 psql:photodb.sql:296: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
2501 Recognized languages are sql, C, internal, and created procedural languages.
2502 psql:photodb.sql:301: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
2503 psql:photodb.sql:301: ERROR: Relation 'ph_presentation_user_map' already exists
2504 psql:photodb.sql:303: ERROR: Cannot create index: 'ph_prest_user_by_present_idx' already exists 2505 psql:photodb.sql:304: ERROR: Cannot create index: 'ph_prest_user_by_user_idx' already exists 2506 psql:photodb.sql:314: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. 2507 Recognized languages are sql, C, internal, and created procedural languages.
psql:photodb.sql:323: ERROR: Relation 'dual' does not exist
psql:photodb.sql:329: ERROR: Relation 'dual' does not exist
Some of errors can be ignored as i am running that command 2nd time.
Expecting your help soon.
Regards,
--Pradeep
