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!
The other (main) problem is not solved yet, but we have gotten around it
by simply removing the comment on triggers, which obviously confused the
script. Without the comment, it works again; however it is obvious that
the script still has problems which need to be addressed to be fully
functional.
I guess the script works fine with simpler names, but it seems the
capital letters in our schema names (which require quoting where
necessary) cause all the problems. Similar problem is present when
PGAdmin tries to back such a schema up; the schema names require quoting
(but that's a PGAdmin's problem, which I'll report elsewhere.)
Thanks,
A.K.