Postgres Pro
Downloads
Home   >   mailing lists

Re: Cloning schemas - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Cloning schemas
Date
Msg-id CANu8Fiy2PPsSR8LOFJe=66o099rkiT-gOGqvOpP=S0V8uODkkw@mail.gmail.com
Whole thread Raw
In response to Re: Cloning schemas  (Łukasz Jarych <jaryszek@gmail.com>)
List pgsql-general
Tree view


On Mon, Jul 9, 2018 at 5:14 AM, Łukasz Jarych <jaryszek@gmail.com> wrote:
Hi Melvin,

i am trying to run postgresql 10 cloning schema function but still i am getting error...

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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: How to set array element to null value
Next
From: DiasCosta
Date:
Subject: Re: Cloning schemas