Hi Melvin, thank you very much. Awesome!!!
Best, Jacek wt., 3 lip 2018 o 15:34 Melvin Davidson <melvin6...@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. > >
