Re: Problem with schemas, possibly oids?

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Arni Kromić <Arni(dot)Kromic(at)bios-ict(dot)hr>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Problem with schemas, possibly oids?
Date: 2019-08-08 12:08:52
Message-ID: CAKoxK+7Jdoh1s5G7iJjKvdXSxFUQ0+6g+VvBJS21H7-TWeODuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Aug 8, 2019 at 11:04 AM Arni Kromić <Arni(dot)Kromic(at)bios-ict(dot)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? And what about

SELECT oid, nspname FROM pg_namespace WHERE nspname like
'%HR16101766338-2018%';

Luca

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2019-08-08 12:14:06 Re: Problem with schemas, possibly oids?
Previous Message Arni Kromić 2019-08-08 09:04:10 Problem with schemas, possibly oids?