Re: Cloning schemas

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Cloning schemas
Дата
Msg-id CANu8FiyGaryragUWXa5u=csvULcbSy-Az9kUqA2r22JdaRzktw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cloning schemas  (DiasCosta <diascosta@diascosta.org>)
Ответы Re: Cloning schemas
Список pgsql-general
Дерево обсуждения


On Mon, Jul 9, 2018 at 12:32 PM, DiasCosta <diascosta@diascosta.org> wrote:
Hi Melvin,

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,
Try reindexing your system_catalogs.

REINDEX VERBOSE SYSTEM  <your_database_name>;


--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!

В списке pgsql-general по дате отправления: