Re: Cloning schemas

[Melvin Davidson <melvin6925@xxxxxxxxx>]

On Wed, Jul 4, 2018 at 2:27 PM, Łukasz Jarych <jaryszek@xxxxxxxxx> wrote:

Hi Melvin,

Best,

Jacek

wt., 3 lip 2018 o 15:34 Melvin Davidson <melvin6925@xxxxxxxxx> 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.

> thank you very much. Awesome!!!

Jacek,

You are quite welcome.

--

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