Re: [Chasers-general] software setup

[Jonathan H. <jhe...@de...>]

>> [root@d-128-95-80-203 ~]# psql -U mars -f /var/www/html/chasers/chasers-schema/add_system_users.sql marsptdb
>> INSERT 0 2
>> psql:/var/www/html/chasers/chasers-schema/add_system_users.sql:32: ERROR:  null value in column "permission_date" violates not-null constraint
>>     
This can be fixed (after resolving the error below), by replacing these
lines:

INSERT INTO tbl_permission(
permission_type_code,
staff_id,
permission_read,
permission_write,
permission_super,
added_by,
changed_by)

values ('SUPER_USER',2,true,true,true,1,1);


with this:

INSERT INTO tbl_permission(
permission_type_code,
staff_id,
permission_read,
permission_write,
permission_super,
added_by,
changed_by,
permission_date)

values ('SUPER_USER',2,true,true,true,1,1,current_date);

>> psql:/var/www/html/chasers/chasers-schema/add_system_users.sql:39: ERROR:  language "plpgsql" does not exist
>> HINT:  Use CREATE LANGUAGE to load the language into the database.
>>     
>
>   
That language should have been created with
schema.desc_abrc_locator.sql, so my guess is that you got an error on
that as well. Make sure you have postgresql-pl installed, and then
revise my previous directions and run the schema file in as the Postgres
superuser:

su -c "psql -f [file] marsptdb" postgres

This is necessary since only the Postgres user can create languages.

-Jonathan