Hi Everyone,
I am trying to run step two of the stable release… Any clues as to what generated this error?
Kind Regards,
Andrew
[quote]----------------------------------
±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| MySource Error |
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Error text not found for this code and locale [SYS0320] |
| array ( |
| 0 => 'DB Error: unknown error-- creates a function that grants access to the secondary user. |
| – This function should be called after all the tables in the system |
| – have been created |
| 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]
