Re: Cloning schemas - Mailing list pgsql-general

From Łukasz Jarych
Subject Re: Cloning schemas
Date
Msg-id CAGv31odwUXmN6=4EX74=8bwgBe23eoc153cb0i0x5_WrQ82RUw@mail.gmail.com
Whole thread Raw
In response to Re: Cloning schemas  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Cloning schemas  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
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 


sob., 7 lip 2018 o 22:20 Melvin Davidson <melvin6925@gmail.com> napisał(a):


2018-07-07 4:32 GMT-04:00 DiasCosta <diascosta@diascosta.org>:
Hi Melvin,

Thank you.

Dias Costa

On 04-07-2018 23:38, Melvin Davidson wrote:


On Wed, Jul 4, 2018 at 2:48 PM, DiasCosta <diascosta@diascosta.org> wrote:
Hi Melvin,

I'm new to clone_schema.
Can I use it on PostgreSQL 9.6?

TIA
DCostaployment by invitation only!

> Can I use it on PostgreSQL 9.6?

Yes, but because the developer(s) once again monkeyed with the system catalogs, there are now
two versions. One for 10 and one for 9.6 and below. I've attached the 9.6 version for you.

 


-- 
J. M. Dias Costa
Telef. 214026948     Telem. 939307421

Se divulgar esta mensagem por terceiros, por favor:
1. Apague o meu endereço de correio electrónico e o meu nome.
2. Apague também os endereços dos seus amigos antes de distribuir.
3. Enderece como cópia oculta (Cc ou Bcc) para os SEUS destinatários.
Agindo deste modo, dificultará a disseminação de "vírus", "spams" e
"banners" e contribuirá para manter a privacidade de todos e cada um.
Obrigado.

Nota: Não se deverá ao acaso a ocorrência de palavras na minha escrita que não respeitem o 
malfadado acordo ortográfico.

You are welcome Dias!
Good to have positive feedback.


--
Melvin Davidson
Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!
Attachment

pgsql-general by date:

Previous
From: Demitri Muna
Date:
Subject: Re: ddl_command_end not firing DROP events
Next
From: Brahmam Eswar
Date:
Subject: How to set array element to null value