| From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
|---|---|
| To: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
| Cc: | DiasCosta <diascosta(at)diascosta(dot)org>, 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-09 13:04:22 |
| Message-ID: | CANu8Fiy2PPsSR8LOFJe=66o099rkiT-gOGqvOpP=S0V8uODkkw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jul 9, 2018 at 5:14 AM, Łukasz Jarych <jaryszek(at)gmail(dot)com> wrote:
> Hi Melvin,
>
> i am trying to run postgresql 10 cloning schema function but still i am
> getting error...
>
> [image: image.png]
>
> Error: Error in syntax near "SYSTEM"
> Context: Function PL/pgSQL, row 212 in EXECUTE
>
> What is happening?
>
> Best,
> Jacek
>
> > Error: Error in syntax near "SYSTEM"
Jacek,
I have changed the code from OVERRIDING SYSTEM VALUE to OVERRIDING USER
VALUE
and attached the revised version below.
If that does not fix the problem, then I will need you to do a
pgdump -F p -t public.t_cpuinfo
and send the output to me.
--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!
| Attachment | Content-Type | Size |
|---|---|---|
| clone_schema_10.sql | text/plain | 13.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DiasCosta | 2018-07-09 16:32:48 | Re: Cloning schemas |
| Previous Message | David Fetter | 2018-07-09 13:01:05 | Re: How to set array element to null value |