Re: pg_restore creates public schema?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_restore creates public schema?
Дата
Msg-id 2678272.1665067771@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_restore creates public schema?  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: pg_restore creates public schema?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Ron <ronljohnsonjr@gmail.com> writes:
> pg_dump 9.6.24

You realize that that version's been out of support for a year?

> Why does pg_restore explicitly create "public" even though public is 
> automatically created when the database is created?

We fixed that in v11 (see 5955d9341).  Evidently the fix requires an
updated pg_dump more than pg_restore.  However, I believe that only
happens with -c, so why are you using both -c and -C?

            regards, tom lane



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

Предыдущее
От: Gus Spier
Дата:
Сообщение: Re: Postgres calendar?
Следующее
От: Ron
Дата:
Сообщение: Re: pg_restore creates public schema?