On Wed, Jul 4, 2018 at 2:27 PM, Łukasz Jarych <jarys...@gmail.com> wrote:
> Hi Melvin, > > > > 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. >> >> > thank you very much. Awesome!!! Jacek, You are quite welcome. -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!
