Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jCOA6-0002tC-Ck for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Mar 2020 13:46:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jCOA5-0004oZ-7i for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Mar 2020 13:46:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jCOA4-0004oS-Vp for pgsql-bugs@lists.postgresql.org; Thu, 12 Mar 2020 13:46:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jCOA1-0006tL-0q for pgsql-bugs@lists.postgresql.org; Thu, 12 Mar 2020 13:46:07 +0000 Content-Type: multipart/mixed; boundary="===============0378128997804890603==" MIME-Version: 1.0 Subject: BUG #16299: pg_subscription_rel inconsistency post create database from template with disabled subscription To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: eric.cyr@gmail.com Reply-To: eric.cyr@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 12 Mar 2020 13:45:45 +0000 Message-ID: <16299-0e518acf3ff4956e@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0378128997804890603== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI5OQpMb2dnZWQgYnk6ICAgICAgICAgIEVyaWMgQ3lyCkVtYWlsIGFk ZHJlc3M6ICAgICAgZXJpYy5jeXJAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTIuMQpP cGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGksDQoNCkkg c3R1bWJsZWQgdXBvbiB3aGF0IHNlZW1zIHRvIGJlIGluY29uc2lzdGVuY3kgaW4gdGhlIHBnX3N1 YnNjcmlwdGlvbl9yZWwKY2F0YWxvZyB0YWJsZS4NClRoaXMgd2FzIG5vdGljZWQgYWZ0ZXIgY3Jl YXRpbmcgYSBuZXcgZGF0YWJhc2UgdXNpbmcgYSB0ZW1wbGF0ZSB3aGljaCBoYWQKZGlzYWJsZWQg c3Vic2NyaXB0aW9uLg0KQWx0aG91Z2jCoEltIHNlbmRpbmcgdGhpcyB0byBidWcgcmVwb3J0LCBp dCBkaWRuJ3QgY2F1c2UgYW55IGlzc3VlIHNvIGZhci4NCg0KSGVyZSBhcmUgdGhlIHN0ZXBzIHRv IHJlcHJvZHVjZSB0aGUgc2l0dWF0aW9uOg0KDQoNCi0tDQoNCkNSRUFURSBST0xFIHVzcl9yZXBs aWNhdGlvbiBSRVBMSUNBVElPTiBQQVNTV09SRCAndGVzdCcgTE9HSU47DQoNCi0tDQoNCkNSRUFU RSBEQVRBQkFTRSBwdWJsaXNoZXI7DQoNClxjIHB1Ymxpc2hlcg0KDQpDUkVBVEUgU0NIRU1BIHRl c3Q7DQoNCkdSQU5UIFVTQUdFIE9OIFNDSEVNQSB0ZXN0IFRPIHVzcl9yZXBsaWNhdGlvbjsNCg0K Q1JFQVRFIFRBQkxFIHRlc3QucHViX3RhYmxlDQooDQogICAgaWQgU0VSSUFMLA0KICAgIHZhbDEg dGV4dA0KKTsNCg0KR1JBTlQgQUxMIE9OIFRBQkxFIHRlc3QucHViX3RhYmxlIFRPIHVzcl9yZXBs aWNhdGlvbjsNCg0KQ1JFQVRFIFBVQkxJQ0FUSU9OIHB1YiBGT1IgVEFCTEUgdGVzdC5wdWJfdGFi bGU7DQoNClNFTEVDVCBwZ19jcmVhdGVfbG9naWNhbF9yZXBsaWNhdGlvbl9zbG90KCdwdWJfcnNs b3RfMScsICdwZ291dHB1dCcpOw0KDQotLQ0KDQpDUkVBVEUgREFUQUJBU0Ugc3Vic2NyaWJlcjsN Cg0KXGMgc3Vic2NyaWJlcg0KDQpDUkVBVEUgU0NIRU1BIHRlc3Q7DQoNCkdSQU5UIFVTQUdFIE9O IFNDSEVNQSB0ZXN0IFRPIHVzcl9yZXBsaWNhdGlvbjsNCg0KQ1JFQVRFIFRBQkxFIHRlc3QucHVi X3RhYmxlDQooDQogICAgaWQgU0VSSUFMLA0KICAgIHZhbDEgdGV4dA0KKTsNCg0KR1JBTlQgQUxM IE9OIFRBQkxFIHRlc3QucHViX3RhYmxlIFRPIHVzcl9yZXBsaWNhdGlvbjsNCg0KQ1JFQVRFIFNV QlNDUklQVElPTiBzdWINCiAgICBDT05ORUNUSU9OICdkYm5hbWU9cHVibGlzaGVyIHVzZXI9dXNy X3JlcGxpY2F0aW9uIHBhc3N3b3JkPXRlc3QnDQogICAgUFVCTElDQVRJT04gcHViDQogICAgV0lU SCAoIGNyZWF0ZV9zbG90ID0gRkFMU0UsIHNsb3RfbmFtZSA9ICdwdWJfcnNsb3RfMScgKQ0KOw0K DQotLQ0KDQpcYyBzdWJzY3JpYmVyDQoNCkFMVEVSIFNVQlNDUklQVElPTiBzdWIgRElTQUJMRTsN Cg0KXGMgdGVtcGxhdGUxDQoNCkNSRUFURSBEQVRBQkFTRSBzdWJzY3JpYmVyX2Zyb21fdGVtcGxh dGUgVEVNUExBVEUgc3Vic2NyaWJlcjsNCg0KXGMgc3Vic2NyaWJlcl9mcm9tX3RlbXBsYXRlDQoN ClxkUnMNCi0tIDAgcm93cw0KDQpTRUxFQ1QgKiBGUk9NIHBnX3N1YnNjcmlwdGlvbiBXSEVSRSBz dWJkYmlkID0gKFNFTEVDVCBvaWQgRlJPTSBwZ19kYXRhYmFzZQpXSEVSRSBkYXRuYW1lID0gY3Vy cmVudF9kYXRhYmFzZSgpKTsNCi0tIDAgcm93cw0KDQpTRUxFQ1QgKiBGUk9NIHBnX3N1YnNjcmlw dGlvbl9yZWw7DQotLSAxIHJvd3MNCg0KDQoNCg0KDQpUaGFuayB5b3UNCkhhdmUgYSBuaWNlIGRh eQ0KRXJpYw0KDQoNClNpZGUgbm90ZQ0KTWF5YmUsIGluIHRoZSBtZWFudGltZSwgYSBtZW50aW9u IGNvdWxkIGJlIGFkZGVkIHRvIHRoZSBkb2N1bWVudGF0aW9uLg0KDQpSZWZlcmVuY2U6DQo1MS41 NC4gcGdfc3Vic2NyaXB0aW9uX3JlbA0KDQoiVGhpcyBjYXRhbG9nIG9ubHkgY29udGFpbnMgdGFi bGVzIGtub3duIHRvIHRoZSBzdWJzY3JpcHRpb24gYWZ0ZXIgcnVubmluZwplaXRoZXIgQ1JFQVRF IFNVQlNDUklQVElPTiBvciBBTFRFUiBTVUJTQ1JJUFRJT04gLi4uIFJFRlJFU0ggUFVCTElDQVRJ T04uIg0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9jYXRhbG9nLXBnLXN1YnNj cmlwdGlvbi1yZWwuaHRtbAoK --===============0378128997804890603==--