Re: Problem with schemas, possibly oids?

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: Problem with schemas, possibly oids?
Дата
Msg-id CAKoxK+7Jdoh1s5G7iJjKvdXSxFUQ0+6g+VvBJS21H7-TWeODuA@mail.gmail.com
обсуждение исходный текст
Ответ на Problem with schemas, possibly oids?  (Arni Kromić <Arni.Kromic@Bios-ICT.hr>)
Ответы Re: Problem with schemas, possibly oids?
Список pgsql-admin
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? And what about

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

Luca



В списке pgsql-admin по дате отправления:

Предыдущее
От: Arni Kromić
Дата:
Сообщение: Problem with schemas, possibly oids?
Следующее
От: Ron
Дата:
Сообщение: Re: Problem with schemas, possibly oids?