Re: Problem with schemas, possibly oids?
Luca Ferrari <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAKoxK+7Jdoh1s5G7iJjKvdXSxFUQ0+6g+VvBJS21H7-TWeODuA@mail.gmail.com> |
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? And what about SELECT oid, nspname FROM pg_namespace WHERE nspname like '%HR16101766338-2018%'; Luca