Trying run 9.6 clone_schema on a different schema and I get the following error:
NOTICE: search path = {public,pg_catalog} CONTEXT: PL/pgSQL function clone_schema(text,text,boolean) line 79 at RAISE ERROR: relation "bilhetica_logic_schema.idx_unq_cod_operador_aml" does not exist CONTEXT: SQL statement "COMMENT ON INDEX bilhetica_logic_schema.idx_unq_cod_operador_aml IS 'garante unicidade do Cod_Operador_AML';" PL/pgSQL function clone_schema(text,text,boolean) line 401 at EXECUTE ********** Error **********
ERROR: relation "bilhetica_logic_schema.idx_unq_cod_operador_aml" does not exist SQL state: 42P01 Context: SQL statement "COMMENT ON INDEX bilhetica_logic_schema.idx_unq_cod_operador_aml IS 'garante unicidade do Cod_Operador_AML';" PL/pgSQL function clone_schema(text,text,boolean) line 401 at EXECUTE
Can you help me, please? Thanks in advance Dias Costa
Dias
> NOTICE: search path = {public,pg_catalog}
>ERROR: relation "bilhetica_logic_schema.idx_unq_cod_operador_aml" does not exist
This is not related to the clone_schema function. It looks like you may have corruption in your syste catalogs,