Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1lSKtP-0000Ig-EN
	for pgsql-bugs@arkaria.postgresql.org; Fri, 02 Apr 2021 14:35:24 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1lSKtO-0008Ho-AY
	for pgsql-bugs@arkaria.postgresql.org; Fri, 02 Apr 2021 14:35:22 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <drtr0jan@yandex.ru>)
	id 1lSKUJ-0008Va-Is
	for pgsql-bugs@lists.postgresql.org; Fri, 02 Apr 2021 14:09:27 +0000
Received: from forward101j.mail.yandex.net ([5.45.198.241])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <drtr0jan@yandex.ru>)
	id 1lSKUF-0005Om-5E
	for pgsql-bugs@lists.postgresql.org; Fri, 02 Apr 2021 14:09:26 +0000
Received: from forward101q.mail.yandex.net (forward101q.mail.yandex.net
 [IPv6:2a02:6b8:c0e:4b:0:640:4012:bb98])
	by forward101j.mail.yandex.net (Yandex) with ESMTP id 3F5281BE079B;
	Fri,  2 Apr 2021 17:09:19 +0300 (MSK)
Received: from vla5-7a001693b25e.qloud-c.yandex.net
 (vla5-7a001693b25e.qloud-c.yandex.net
 [IPv6:2a02:6b8:c18:348d:0:640:7a00:1693])
	by forward101q.mail.yandex.net (Yandex) with ESMTP id 3894ECF40021;
	Fri,  2 Apr 2021 17:09:19 +0300 (MSK)
Received: from vla1-ef285479e348.qloud-c.yandex.net
 (vla1-ef285479e348.qloud-c.yandex.net [2a02:6b8:c0d:35a1:0:640:ef28:5479])
	by vla5-7a001693b25e.qloud-c.yandex.net (mxback/Yandex) with ESMTP id
 wlN6pIA7tM-9JJmpdOj;
	Fri, 02 Apr 2021 17:09:19 +0300
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail;
 t=1617372559;
	bh=Hehh7WUJcaa/DTP5IrIpEBJHQTKXtbCmjJ00PTqdgi4=;
	h=In-Reply-To:To:Subject:From:Message-ID:Cc:Date:References;
	b=u6HArhbwGhfY3/zXssiMnGfm1OqqY/Khp5dNzlL15sFFJsKitiPT35UnyKaLBgQFm
	 xlzdI226XpLh3RecAcLc/UmjN8MH3zeCQfLMZwN2yvWslfsx+lVq4mZCic2xhDnnp0
	 JhgrJzqb0XmuT1kBa2jtin0UE2lCcJIx+K4iQjA8=
Authentication-Results: vla5-7a001693b25e.qloud-c.yandex.net;
 dkim=pass header.i=@yandex.ru
Received: by vla1-ef285479e348.qloud-c.yandex.net (smtp/Yandex) with ESMTPSA
 id CVgbekpMa9-9ILCk6qJ;
	Fri, 02 Apr 2021 17:09:18 +0300
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits))
	(Client certificate not present)
From: "Boris P. Korzun" <drtr0jan@yandex.ru>
Subject: Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES
To: Neil Chen <carpenter.nail.cz@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
References: <111621616618184@mail.yandex.ru>
 <CAA3qoJkRCLwGsOq8kEAessFOHqoVC4oc0zMWBK_w9vj5Y99rHQ@mail.gmail.com>
Message-ID: <434e55c7-41a2-b854-2df2-a4dfdbef086a@yandex.ru>
Date: Fri, 2 Apr 2021 17:09:14 +0300
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:78.0) Gecko/20100101
 Thunderbird/78.9.0
MIME-Version: 1.0
In-Reply-To: 
 <CAA3qoJkRCLwGsOq8kEAessFOHqoVC4oc0zMWBK_w9vj5Y99rHQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/434e55c7-41a2-b854-2df2-a4dfdbef086a%40yandex.ru>
Precedence: bulk

Hi Neil,

> Combined with the above research, I gave this patch to fix the 
> bug. Hackers can help to see if this modification is correct. I'm 
> studying how to write test scripts for it...

it works. Thx.

WBR,
Boris