From: | Arni <Arni(dot)Kromic(at)Bios-ICT(dot)hr> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Problem with schemas, possibly oids? |
Date: | 2019-08-08 12:21:47 |
Message-ID: | e1522627-7988-aba3-da4a-ab4e1587a211@Bios-ICT.hr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(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?
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Arni | 2019-08-08 12:30:07 | Re: Problem with schemas, possibly oids? |
Previous Message | Ron | 2019-08-08 12:14:06 | Re: Problem with schemas, possibly oids? |