From: Arni <Arni.Kromic@Bios-ICT.hr>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Problem with schemas, possibly oids?
Date: Thu, 8 Aug 2019 14:21:47 +0200
Message-ID: <e1522627-7988-aba3-da4a-ab4e1587a211@Bios-ICT.hr> (raw)
In-Reply-To: <CAKoxK+7Jdoh1s5G7iJjKvdXSxFUQ0+6g+VvBJS21H7-TWeODuA@mail.gmail.com>
References: <3cabefc3-0713-7f5d-27c5-c0dab55cd8c6@Bios-ICT.hr>
<CAKoxK+7Jdoh1s5G7iJjKvdXSxFUQ0+6g+VvBJS21H7-TWeODuA@mail.gmail.com>
Thank you for your response.
On 08/08/2019 14.08, Luca Ferrari wrote:
> On Thu, Aug 8, 2019 at 11:04 AM Arni Kromić <Arni.Kromic@bios-ict.hr> wrote:
>> 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.
> This could lead to a catalog corruption, even if it is a lot strange!
> What does:
> SELECT oid, nspname FROM pg_namespace WHERE nspname = quote_ident(
> 'HR16101766338-2018');
>
> return?
That returns nothing...
> And what about
>
> SELECT oid, nspname FROM pg_namespace WHERE nspname like
> '%HR16101766338-2018%';
>
> Luca
>
>
>
This works! I get:
oid | nspname
-------+--------------------
16385 | HR16101766338-2018
(1 row)
I get the same thing if I try with '%HR16101766338-2018'. So it seems as
if there were some characters prepended to the name... I've checked for
spaces, but there are none. What could this mean?
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: Arni.Kromic@Bios-ICT.hr, pgsql-admin@lists.postgresql.org
Subject: Re: Problem with schemas, possibly oids?
In-Reply-To: <e1522627-7988-aba3-da4a-ab4e1587a211@Bios-ICT.hr>
* 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