On Fri, Aug 9, 2019 at 11:39 AM Arni <Arni.Kromic@bios-ict.hr> wrote:
>
> On 08/08/2019 16.38, Luca Ferrari wrote:
> > the first query is performed with quote_ident and that's the initial
> > failure.
> Oh now I get it, that was the reason why it wouldn't clone an existing
> schema! My schema names are always quoted and that's why it fails. I
> removed that quote_indent and it sort of works now (even though it still
> fails trying to do something on a nonexistant column!) I wonder how
> nobody noticed this before, while so many people discussed the script.
> As I'm not so good with procedural SQL, I wouldn't have caught it too.
> Many thanks!
I didn't get this: your schema name requires double quotes because it
has uppercase letters, and you fixed it removing quote_ident?
Do you have the time and patient to reproduce every single query done
by the script and see what exactly does not work? Because it seems to
me that the schema is always quote_ident-ed.
Luca