hi guys,
installing matrix 3.4.1 locally on apache2triad 1.4.2…
postgresql: server: unix(), user: root, no pass. second user same.
it creates the structure of the database (however have no idea if it's complete), all the tables are empty. casts, languages, schemas -> public -> 11 empty tables.
after step 14:
TABLE CREATION COMPLETE
SEQUENCE CREATION COMPLETE
MySource Error
TABLE INSTALL FAILURE
and 1 warning:
DB Error: unknown error
CREATE OR REPLACE FUNCTION sq_grant_access(character varying) RETURNS TEXT AS ' DECLARE user_name ALIAS FOR $1; table RECORD; tablename TEXT; BEGIN FOR table IN SELECT c.relname AS name FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (''r'',''v'',''S'','''') AND n.nspname NOT IN (''pg_catalog'', ''pg_toast'') AND pg_catalog.pg_table_is_visible(c.oid) LOOP tablename=table.name; RAISE NOTICE ''tablename is %'', tablename; EXECUTE ''GRANT ALL ON '' || quote_ident(tablename) || '' TO '' || quote_ident(user_name::text); END LOOP; RETURN ''access granted.''; END; ' LANGUAGE plpgsql; [nativecode=ERROR: language "plpgsql" does not exist HINT: You need to use "createlang" to load the language into the database.]
don't know postgre, can you help?
thank you.
mik
You need to add the PL/pgSQL language to the PostgreSQL database before installing. Check the PostgreSQL documentation for details on how to do this on Windows. 