Re: Cloning schemas

Поиск
Список
Период
Сортировка
От Łukasz Jarych
Тема Re: Cloning schemas
Дата
Msg-id CAGv31of_kectEtF63zSgPDFO1a3jCarhTEtXnCFM9H2kkOn50Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cloning schemas  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: Cloning schemas
Список pgsql-general
Дерево обсуждения
Hi Melvin,

thank you very much. Awesome!!!

Best,
Jacek


wt., 3 lip 2018 o 15:34 Melvin Davidson <melvin6925@gmail.com> napisał(a):



ERROR: BŁĄD: you cannot add to column "TopoToVersion_ID" DETAIL: Column "TopoToVersion_ID" is an identity column defined as GENERATED ALWAYS. HINT: Use OVERRIDING SYSTEM VALUE to override. CONTEXT: wyrażenie SQL "INSERT INTO version4.t_topotoversions SELECT * FROM public.t_topotoversions;" funkcja PL/pgSQL clone_schema(text,text,boolean), wiersz 212 w EXECUTE

Lukasz,
That ERROR is occuring because you choose to copy the data (include_recs = TRUE).
I have added OVERRIDING SYSTEM VALUE to the insert statement and attached revised version.
CAUTION: The value of TopoToVersion_ID and any other IDENTITY columns may be changed.

The revised version is attached.

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