Re: Errors when restoring backup created by pg_dumpall

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Errors when restoring backup created by pg_dumpall
Дата
Msg-id CANzqJaA1VV6gzoBTLAwUcm5cOzNPhtKUVfvxpa66BttP1EgPqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Errors when restoring backup created by pg_dumpall  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Errors when restoring backup created by pg_dumpall
Re: Errors when restoring backup created by pg_dumpall
Список pgsql-general
On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
Another alternative is to open the .sql file in Notepad++, then add "public." before all the unqualified "earth" and "ll_to_earth" references.

And as discussed there are none in that file because those references are within an extension's objects and only create extension appears in the file.

Then why would changing search_path work? 

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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