Re: pg_restore creates public schema?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore creates public schema?
Date: 2022-10-06 14:49:31
Message-ID: 2678272.1665067771@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron <ronljohnsonjr(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-10-06 15:17:44 Re: pg_restore creates public schema?
Previous Message Gus Spier 2022-10-06 14:49:25 Re: Postgres calendar?