Re: Problem with schemas, possibly oids?

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ć <[email protected]> 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?