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 ) id 1o3vvi-0007ID-D1 for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Jun 2022 08:41:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o3vvh-0003QA-7I for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Jun 2022 08:41:41 +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 ) id 1o3pf9-00075Z-4s for pgsql-bugs@lists.postgresql.org; Wed, 22 Jun 2022 02:00:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o3pf5-0002O4-7s for pgsql-bugs@lists.postgresql.org; Wed, 22 Jun 2022 02:00:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=rHSxCNjA/k+kTdeEUEpBupUeGGsZ5YxGi7UPyOKpEJg=; b=vQ5CPOImoSXifF7LaFBRq6PPKb OnJQPZybeDyRSzVKb+iIYAIDH6KsQLu5luuymJyoQwEM3J5JVjlP2JIjAYurO4gQnQwS0x1uB184W vYJi/UJqc5csi1+BARqNtB7kXORUEhUm2RVliuZ9hu7TflGkh/eMhkCtaYtUvyJBQaIRgG0dKwdYJ w/x2BIkBSy0Hm3Eark48BFLNiH45TFzXSaC8UlzDJwMWbYPsAVY5iB8drUcKACz2P6nFOfdZaz4wt aTzprglH8kwjPPh2oHPm/ajvSA3apy9U48OUASSQ7TxQ/NFUik86Lip2rO2E9d0RZgkD8rQKuQuDb tz4pQiPg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o3pf4-00089a-4e for pgsql-bugs@lists.postgresql.org; Wed, 22 Jun 2022 02:00:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1o3pf1-004U8J-Ot for pgsql-bugs@lists.postgresql.org; Wed, 22 Jun 2022 02:00:03 +0000 Content-Type: multipart/mixed; boundary="===============2833400390541148352==" MIME-Version: 1.0 Subject: BUG #17526: PG_DUMP is not outputting "CREATE SCHEMA" statements when an extension is assigned to a schema To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: developer@moregatebiotech.com Reply-To: developer@moregatebiotech.com, pgsql-bugs@lists.postgresql.org Date: Wed, 22 Jun 2022 01:59:27 +0000 Message-ID: <17526-2e7a7cf9eb165a82@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2833400390541148352== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzUyNgpMb2dnZWQgYnk6ICAgICAgICAgIGNocmlzCkVtYWlsIGFkZHJl c3M6ICAgICAgZGV2ZWxvcGVyQG1vcmVnYXRlYmlvdGVjaC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNC40Ck9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKClBH X0RVTVAgaXMgbm90IG91dHB1dHRpbmcgIkNSRUFURSBTQ0hFTUEiIHN0YXRlbWVudHMgd2hlbiBh biBleHRlbnNpb24gaXMKYXNzaWduZWQgdG8gYSBzY2hlbWEuDQoNCkkndmUgYWxzbyB2ZXJmaWVk IHRoaXMgc2FtZSBiZWhhdmlvdXIgb24gdmVyc2lvbiAxMy43IHJ1bm5pbmcgdW5kZXIgV2luZG93 cwphbmQgYWxzbyB1c2luZyB0aGUgYWRtaW5wYWNrIGV4dGVuc2lvbiBjcmVhdGVkIGluIHBnX2Nh dGFsb2cgaW5zdGVhZCBvZgpoc3RvcmUgaW4gcHVibGljLg0KDQpBIHNoZWxsIHNjcmlwdCB0byBk ZW1vbnN0cmF0ZSB0aGUgaXNzdWU6DQoNCmNyZWF0ZWRiIHRlc3QxDQpjcmVhdGVkYiB0ZXN0Mg0K cHNxbCB0ZXN0MSAtYyAiY3JlYXRlIHNjaGVtYSB0ZXN0Ig0KcHNxbCB0ZXN0MiAtYyAiY3JlYXRl IHNjaGVtYSB0ZXN0Ig0KcHNxbCAtZCB0ZXN0MiAtYyAiY3JlYXRlIGV4dGVuc2lvbiBoc3RvcmUg d2l0aCBzY2hlbWEgcHVibGljIg0KcHNxbCAtZCB0ZXN0MiAtYyAiYWx0ZXIgZXh0ZW5zaW9uIGhz dG9yZSBhZGQgc2NoZW1hIHRlc3QiDQpwZ19kdW1wIC0tbm8tY29tbWVudHMgdGVzdDENCnBnX2R1 bXAgLS1uby1jb21tZW50cyB0ZXN0Mg0KDQpGb2xsb3dpbmcgYXJlIHRoZSByZXN1bHRzIG9mIHRo ZSBzY3JpcHQsIG5vdGluZyB0aGF0IGZvciB0aGUgY2FzZSBvZiB0aGUKdGVzdDEgZGIsIHRoZSAi Q1JFQVRFIFNDSEVNQSB0ZXN0OyIgc3RhdGVtZW50IGlzIGJlaW5nIGNvcnJlY3RseSBvdXRwdXQg YnkKcGdfZHVtcCBidXQgaW4gdGhlIGNhc2Ugb2YgdGhlIHRlc3QyIGRiLCB3aGljaCBoYXMgdGhl IGhzdG9yZSBleHRlbnNpb24KYWRkZWQgdG8gaXQsIHRoZSBjcmVhdGUgc2NoZW1hIHN0YXRlbWVu dCBpcyBhYnNlbnQ6DQoNCg0KdXNlckBkZWJpYW4tdGVzdGluZzp+JCBjcmVhdGVkYiB0ZXN0MQ0K dXNlckBkZWJpYW4tdGVzdGluZzp+JCBjcmVhdGVkYiB0ZXN0Mg0KdXNlckBkZWJpYW4tdGVzdGlu Zzp+JCBwc3FsIHRlc3QxIC1jICJjcmVhdGUgc2NoZW1hIHRlc3QiDQpDUkVBVEUgU0NIRU1BDQp1 c2VyQGRlYmlhbi10ZXN0aW5nOn4kIHBzcWwgdGVzdDIgLWMgImNyZWF0ZSBzY2hlbWEgdGVzdCIN CkNSRUFURSBTQ0hFTUENCnVzZXJAZGViaWFuLXRlc3Rpbmc6fiQgcHNxbCAtZCB0ZXN0MiAtYyAi Y3JlYXRlIGV4dGVuc2lvbiBoc3RvcmUgd2l0aCBzY2hlbWEKcHVibGljIg0KQ1JFQVRFIEVYVEVO U0lPTg0KdXNlckBkZWJpYW4tdGVzdGluZzp+JCBwc3FsIC1kIHRlc3QyIC1jICJhbHRlciBleHRl bnNpb24gaHN0b3JlIGFkZCBzY2hlbWEKdGVzdCINCkFMVEVSIEVYVEVOU0lPTg0KdXNlckBkZWJp YW4tdGVzdGluZzp+JCBwZ19kdW1wIC0tbm8tY29tbWVudHMgdGVzdDENCi0tDQotLSBQb3N0Z3Jl U1FMIGRhdGFiYXNlIGR1bXANCi0tDQoNCi0tIER1bXBlZCBmcm9tIGRhdGFiYXNlIHZlcnNpb24g MTQuNCAoRGViaWFuIDE0LjQtMSkNCi0tIER1bXBlZCBieSBwZ19kdW1wIHZlcnNpb24gMTQuNCAo RGViaWFuIDE0LjQtMSkNCg0KU0VUIHN0YXRlbWVudF90aW1lb3V0ID0gMDsNClNFVCBsb2NrX3Rp bWVvdXQgPSAwOw0KU0VUIGlkbGVfaW5fdHJhbnNhY3Rpb25fc2Vzc2lvbl90aW1lb3V0ID0gMDsN ClNFVCBjbGllbnRfZW5jb2RpbmcgPSAnVVRGOCc7DQpTRVQgc3RhbmRhcmRfY29uZm9ybWluZ19z dHJpbmdzID0gb247DQpTRUxFQ1QgcGdfY2F0YWxvZy5zZXRfY29uZmlnKCdzZWFyY2hfcGF0aCcs ICcnLCBmYWxzZSk7DQpTRVQgY2hlY2tfZnVuY3Rpb25fYm9kaWVzID0gZmFsc2U7DQpTRVQgeG1s b3B0aW9uID0gY29udGVudDsNClNFVCBjbGllbnRfbWluX21lc3NhZ2VzID0gd2FybmluZzsNClNF VCByb3dfc2VjdXJpdHkgPSBvZmY7DQoNCi0tDQotLSBOYW1lOiB0ZXN0OyBUeXBlOiBTQ0hFTUE7 IFNjaGVtYTogLTsgT3duZXI6IHBvc3RncmVzDQotLQ0KDQpDUkVBVEUgU0NIRU1BIHRlc3Q7DQoN Cg0KQUxURVIgU0NIRU1BIHRlc3QgT1dORVIgVE8gcG9zdGdyZXM7DQoNCi0tDQotLSBQb3N0Z3Jl U1FMIGRhdGFiYXNlIGR1bXAgY29tcGxldGUNCi0tDQoNCnVzZXJAZGViaWFuLXRlc3Rpbmc6fiQg cGdfZHVtcCAtLW5vLWNvbW1lbnRzIHRlc3QyDQotLQ0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBk dW1wDQotLQ0KDQotLSBEdW1wZWQgZnJvbSBkYXRhYmFzZSB2ZXJzaW9uIDE0LjQgKERlYmlhbiAx NC40LTEpDQotLSBEdW1wZWQgYnkgcGdfZHVtcCB2ZXJzaW9uIDE0LjQgKERlYmlhbiAxNC40LTEp DQoNClNFVCBzdGF0ZW1lbnRfdGltZW91dCA9IDA7DQpTRVQgbG9ja190aW1lb3V0ID0gMDsNClNF VCBpZGxlX2luX3RyYW5zYWN0aW9uX3Nlc3Npb25fdGltZW91dCA9IDA7DQpTRVQgY2xpZW50X2Vu Y29kaW5nID0gJ1VURjgnOw0KU0VUIHN0YW5kYXJkX2NvbmZvcm1pbmdfc3RyaW5ncyA9IG9uOw0K U0VMRUNUIHBnX2NhdGFsb2cuc2V0X2NvbmZpZygnc2VhcmNoX3BhdGgnLCAnJywgZmFsc2UpOw0K U0VUIGNoZWNrX2Z1bmN0aW9uX2JvZGllcyA9IGZhbHNlOw0KU0VUIHhtbG9wdGlvbiA9IGNvbnRl bnQ7DQpTRVQgY2xpZW50X21pbl9tZXNzYWdlcyA9IHdhcm5pbmc7DQpTRVQgcm93X3NlY3VyaXR5 ID0gb2ZmOw0KDQotLQ0KLS0gTmFtZTogaHN0b3JlOyBUeXBlOiBFWFRFTlNJT047IFNjaGVtYTog LTsgT3duZXI6IC0NCi0tDQoNCkNSRUFURSBFWFRFTlNJT04gSUYgTk9UIEVYSVNUUyBoc3RvcmUg V0lUSCBTQ0hFTUEgcHVibGljOw0KDQoNCi0tDQotLSBQb3N0Z3JlU1FMIGRhdGFiYXNlIGR1bXAg Y29tcGxldGUNCi0tCgo= --===============2833400390541148352==--