| From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
|---|---|
| To: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Cloning schemas |
| Date: | 2018-07-03 13:34:04 |
| Message-ID: | CANu8FizwHA5qDrS8do2kVR7oEcCCdy4V7HXHd9OLgHo23YXztA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
| Attachment | Content-Type | Size |
|---|---|---|
| clone_schema_10.sql | text/plain | 13.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paula Kirsch | 2018-07-03 14:26:59 | Question on the right way to think about order by |
| Previous Message | Adrian Klaver | 2018-07-03 13:27:24 | Re: problem wirh irc ffreenode |