From: Tom Lane <tgl@sss.pgh.pa.us>
To: Arni Kromić <Arni.Kromic@Bios-ICT.hr>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Problem with schemas, possibly oids?
Date: Thu, 08 Aug 2019 10:25:02 -0400
Message-ID: <19010.1565274302@sss.pgh.pa.us> (raw)
In-Reply-To: <3cabefc3-0713-7f5d-27c5-c0dab55cd8c6@Bios-ICT.hr>
References: <3cabefc3-0713-7f5d-27c5-c0dab55cd8c6@Bios-ICT.hr>
=?UTF-8?Q?Arni_Kromi=c4=87?= <Arni.Kromic@Bios-ICT.hr> writes:
> We're using the clone_schema function from a postgres mailing list
> (converted to a procedure now) to create new schemas from a template,
> and so far we have created about 170 schemas that way. Now we have
> encountered a problem which prevents us from creating new schemas:
> CALL clone_schema('klijent_tpl', 'test-2019')
> Although this has worked perfectly until now, the call results in this
> error:
>> ERROR: relation "test-2019.bc_mob_pr_pnd" does not exist
> Moreover, trying to clone some of the existing schemas also fails:
> call clone_schema ('HR16101766338-2018', 'test')
>> NOTICE: source schema HR16101766338-2018 does not exist!
> The source schema DOES exist.
Given that both of these troublesome schemas have dashes in their
names, the most obvious theory is that clone_schema() has some
oversight about double-quoting schema names everywhere necessary.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Arni.Kromic@Bios-ICT.hr, pgsql-admin@lists.postgresql.org
Subject: Re: Problem with schemas, possibly oids?
In-Reply-To: <19010.1565274302@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox