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 1q4TjB-0000fl-5x for pgsql-hackers@arkaria.postgresql.org; Wed, 31 May 2023 21:51:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q4TjA-0006XX-0k for pgsql-hackers@arkaria.postgresql.org; Wed, 31 May 2023 21:51:32 +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 1q4Tj9-0006XO-Gq for pgsql-hackers@lists.postgresql.org; Wed, 31 May 2023 21:51:31 +0000 Received: from smtp-fw-80009.amazon.com ([99.78.197.220]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q4Tj6-002xpj-IJ for pgsql-hackers@lists.postgresql.org; Wed, 31 May 2023 21:51:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1685569888; x=1717105888; h=from:to:subject:date:message-id:mime-version; bh=TuqSJFJb7ydP+zMb+SZFTA9XPHMEe4Z/l9imaMtvEVo=; b=lUVKwGn0hLpdHJ7rUiJODmoTkowS316XUflessqQ5a6mukx3ejuPoH7U w92pf0t4x/k3Gg7+x7CLaiIzyqXb8amSS44sk8H+cdnj1b3412to0cHbT vRzs+Ks7LVr2Rj9gAi5GsoPfB5Za405kQL85JkFKUkOo346Ie9Z1DDRFf c=; X-Amazon-filename: repro.sh X-IronPort-AV: E=Sophos;i="6.00,207,1681171200"; d="sh'?scan'208,217";a="7230926" Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-pdx-2b-m6i4x-0ec33b60.us-west-2.amazon.com) ([10.25.36.214]) by smtp-border-fw-80009.pdx80.corp.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 31 May 2023 21:51:26 +0000 Received: from EX19MTAUWA002.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-pdx-2b-m6i4x-0ec33b60.us-west-2.amazon.com (Postfix) with ESMTPS id C1BD3A0CF8 for ; Wed, 31 May 2023 21:51:26 +0000 (UTC) Received: from EX19D013UWA002.ant.amazon.com (10.13.138.210) by EX19MTAUWA002.ant.amazon.com (10.250.64.202) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.26; Wed, 31 May 2023 21:51:26 +0000 Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19D013UWA002.ant.amazon.com (10.13.138.210) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1118.26; Wed, 31 May 2023 21:51:26 +0000 Received: from EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964]) by EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964%5]) with mapi id 15.02.1118.026; Wed, 31 May 2023 21:51:25 +0000 From: "Imseih (AWS), Sami" To: PostgreSQL Hackers Subject: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Thread-Topic: [BUG] pg_dump does not properly deal with BEGIN ATOMIC function Thread-Index: AQHZlAoMcnWc557nNU2JK25PqJQepA== Date: Wed, 31 May 2023 21:51:25 +0000 Message-ID: <2C1933AB-C2F8-499B-9D18-4AC1882256A0@amazon.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [10.95.233.214] Content-Type: multipart/mixed; boundary="_004_2C1933ABC2F8499B9D184AC1882256A0amazoncom_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_004_2C1933ABC2F8499B9D184AC1882256A0amazoncom_ Content-Type: multipart/alternative; boundary="_000_2C1933ABC2F8499B9D184AC1882256A0amazoncom_" --_000_2C1933ABC2F8499B9D184AC1882256A0amazoncom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGksDQoNCldoYXQgYXBwZWFycyB0byBiZSBhIHBnX2R1bXAvcGdfcmVzdG9yZSBidWcgd2FzIG9i c2VydmVkIHdpdGggdGhlIG5ldw0KQkVHSU4gQVRPTUlDIGZ1bmN0aW9uIGJvZHkgc3ludGF4IGlu dHJvZHVjZWQgaW4gUG9zdGdyZXMgMTQuDQoNCkRlcGVuZGVuY2llcyBpbnNpZGUgYSBCRUdJTiBB VE9NSUMgZnVuY3Rpb24gY2Fubm90IGJlIHJlc29sdmVkDQppZiB0aG9zZSBkZXBlbmRlbmNpZXMg YXJlIGR1bXBlZCBhZnRlciB0aGUgZnVuY3Rpb24gYm9keS4gVGhlIHJlcHJvDQpjYXNlIGlzIHdo ZW4gYSBwcmltYXJ5IGtleSBjb25zdHJhaW50IGlzIHVzZWQgaW4gYSBPTiBDT05GTElDVCBPTiBD T05TVFJBSU5UDQp1c2VkIHdpdGhpbiB0aGUgZnVuY3Rpb24uDQoNCldpdGggdGhlIGF0dGFjaGVk IHJlcHJvLCBwZ19yZXN0b3JlIGZhaWxzIHdpdGgNCg0KcGdfcmVzdG9yZTogZXJyb3I6IGNvdWxk IG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjogIGNvbnN0cmFpbnQgImFfcGtleSIgZm9yIHRhYmxl ICJhIiBkb2VzIG5vdCBleGlzdA0KQ29tbWFuZCB3YXM6IENSRUFURSBGVU5DVElPTiBwdWJsaWMu YV9mKGMxX2luIHRleHQsIGMyIGludGVnZXIgREVGQVVMVCA2MCkgUkVUVVJOUyB2b2lkDQoNCg0K SSBhbSBub3Qgc3VyZSBpZiB0aGUgYW5zd2VyIGlmIHRvIGR1bXAgZnVuY3Rpb25zIGxhdGVyIG9u IGluIHRoZSBwcm9jZXNzLg0KDQpXb3VsZCBhcHByZWNpYXRlIHNvbWUgZmVlZGJhY2sgb24gdGhp cyBpc3N1ZS4NCg0KUmVnYXJkcywNCg0KU2FtaSBJbXNlaWgNCkFtYXpvbiBXZWIgU2VydmljZXMg KEFXUykNCg0K --_000_2C1933ABC2F8499B9D184AC1882256A0amazoncom_ Content-Type: text/html; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6bz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6b2ZmaWNlIiB4 bWxuczp3PSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTp3b3JkIiB4bWxuczptPSJo dHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS8yMDA0LzEyL29tbWwiIHhtbG5zPSJo dHRwOi8vd3d3LnczLm9yZy9UUi9SRUMtaHRtbDQwIj4NCjxoZWFkPg0KPG1ldGEgaHR0cC1lcXVp dj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPG1l dGEgbmFtZT0iR2VuZXJhdG9yIiBjb250ZW50PSJNaWNyb3NvZnQgV29yZCAxNSAoZmlsdGVyZWQg bWVkaXVtKSI+DQo8c3R5bGU+PCEtLQ0KLyogRm9udCBEZWZpbml0aW9ucyAqLw0KQGZvbnQtZmFj ZQ0KCXtmb250LWZhbWlseToiQ2FtYnJpYSBNYXRoIjsNCglwYW5vc2UtMToyIDQgNSAzIDUgNCA2 IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q2FsaWJyaTsNCglwYW5vc2UtMToy IDE1IDUgMiAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3Jt YWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGluOw0KCWZvbnQtc2l6 ZToxMS4wcHQ7DQoJZm9udC1mYW1pbHk6IkNhbGlicmkiLHNhbnMtc2VyaWY7fQ0Kc3Bhbi5FbWFp bFN0eWxlMTcNCgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtY29tcG9zZTsNCglmb250LWZhbWls eToiQ2FsaWJyaSIsc2Fucy1zZXJpZjsNCgljb2xvcjp3aW5kb3d0ZXh0O30NCi5Nc29DaHBEZWZh dWx0DQoJe21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmOw0KCW1zby1saWdhdHVyZXM6bm9uZTt9DQpAcGFnZSBXb3JkU2VjdGlvbjEN Cgl7c2l6ZTo4LjVpbiAxMS4waW47DQoJbWFyZ2luOjEuMGluIDEuMGluIDEuMGluIDEuMGluO30N CmRpdi5Xb3JkU2VjdGlvbjENCgl7cGFnZTpXb3JkU2VjdGlvbjE7fQ0KLS0+PC9zdHlsZT4NCjwv aGVhZD4NCjxib2R5IGxhbmc9IkVOLVVTIiBsaW5rPSIjMDU2M0MxIiB2bGluaz0iIzk1NEY3MiIg c3R5bGU9IndvcmQtd3JhcDpicmVhay13b3JkIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+ DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5IaSw8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29O b3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+V2hhdCBh cHBlYXJzIHRvIGJlIGEgcGdfZHVtcC9wZ19yZXN0b3JlIGJ1ZyB3YXMgb2JzZXJ2ZWQgd2l0aCB0 aGUgbmV3DQo8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkJFR0lOIEFUT01J QyBmdW5jdGlvbiBib2R5IHN5bnRheCBpbnRyb2R1Y2VkIGluIFBvc3RncmVzIDE0LjxvOnA+PC9v OnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBj bGFzcz0iTXNvTm9ybWFsIj5EZXBlbmRlbmNpZXMgaW5zaWRlIGEgQkVHSU4gQVRPTUlDIGZ1bmN0 aW9uIGNhbm5vdCBiZSByZXNvbHZlZA0KPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj5pZiB0aG9zZSBkZXBlbmRlbmNpZXMgYXJlIGR1bXBlZCBhZnRlciB0aGUgZnVuY3Rpb24g Ym9keS4gVGhlIHJlcHJvPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5jYXNl IGlzIHdoZW4gYSBwcmltYXJ5IGtleSBjb25zdHJhaW50IGlzIHVzZWQgaW4gYSBPTiBDT05GTElD VCBPTiBDT05TVFJBSU5UPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj51c2Vk IHdpdGhpbiB0aGUgZnVuY3Rpb24uPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPldpdGggdGhlIGF0 dGFjaGVkIHJlcHJvLCBwZ19yZXN0b3JlIGZhaWxzIHdpdGg8bzpwPjwvbzpwPjwvcD4NCjxwIGNs YXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1h bCI+cGdfcmVzdG9yZTogZXJyb3I6IGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjombmJz cDsgY29uc3RyYWludCAmcXVvdDthX3BrZXkmcXVvdDsgZm9yIHRhYmxlICZxdW90O2EmcXVvdDsg ZG9lcyBub3QgZXhpc3Q8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkNvbW1h bmQgd2FzOiBDUkVBVEUgRlVOQ1RJT04gcHVibGljLmFfZihjMV9pbiB0ZXh0LCBjMiBpbnRlZ2Vy IERFRkFVTFQgNjApIFJFVFVSTlMgdm9pZDxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZu YnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkkgYW0gbm90IHN1cmUgaWYgdGhl IGFuc3dlciBpZiB0byBkdW1wIGZ1bmN0aW9ucyBsYXRlciBvbiBpbiB0aGUgcHJvY2Vzcy4NCjxv OnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+ DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5Xb3VsZCBhcHByZWNpYXRlIHNvbWUgZmVlZGJhY2sgb24g dGhpcyBpc3N1ZS48bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5i c3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+UmVnYXJkcyw8bzpwPjwvbzpwPjwv cD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+U2FtaSBJbXNlaWg8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPkFtYXpvbiBXZWIgU2VydmljZXMgKEFXUyk8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86 cD48L286cD48L3A+DQo8L2Rpdj4NCjwvYm9keT4NCjwvaHRtbD4NCg== --_000_2C1933ABC2F8499B9D184AC1882256A0amazoncom_-- --_004_2C1933ABC2F8499B9D184AC1882256A0amazoncom_ Content-Type: application/octet-stream; name="repro.sh" Content-Description: repro.sh Content-Disposition: attachment; filename="repro.sh"; size=568; creation-date="Wed, 31 May 2023 21:51:25 GMT"; modification-date="Wed, 31 May 2023 21:51:25 GMT" Content-ID: <6A4421E90B7C5D4EAF2F137CFBF0FDDD@amazon.com> Content-Transfer-Encoding: base64 IyMgY3JlYXRlIHRoZSBkYXRhYmFzZQpwc3FsIDw8RU9GCmRyb3AgdGFibGUgYTsKY3JlYXRlIHRh YmxlIGEgKGlkIGludCBwcmltYXJ5IGtleSxjMSB0ZXh0LCBjMiBpbnQpOwoKQ1JFQVRFIE9SIFJF UExBQ0UgRlVOQ1RJT04gYV9mKGMxX2luIHRleHQsIGMyIGludGVnZXIgREVGQVVMVCA2MCkKIFJF VFVSTlMgdm9pZApMQU5HVUFHRSBzcWwKQkVHSU4gQVRPTUlDCiBJTlNFUlQgSU5UTyBhIChjMSwg YzIpCiAgIFZBTFVFUyAoYV9mLmMxX2luLCBhX2YuYzIpIE9OIENPTkZMSUNUIE9OIENPTlNUUkFJ TlQgYV9wa2V5IERPIFVQREFURSBTRVQgYzIgPSBleGNsdWRlZC5jMjsKIEVORDsKRU9GCgojIyBk dW1wIHRoZSBkYXRhYmFzZQpwZ19kdW1wIC1GYyAtYiAtdiAtZiAvdG1wL2EuZHVtcAoKIyMgZHJv cCB0aGUgdGFibGUgdG8gcmVwYXJlIGZvciBhIHBnX3Jlc3RvcmUKcHNxbCA8PEVPRgpkcm9wIHRh YmxlIGEgY2FzY2FkZTsKRU9GCgojIyBwZ19yZXN0b3JlIGZhaWxzIGFzIHRoZSBkZXBlbmRlbmN5 IGlzIG5vdCB5ZXQgY3JlYXRlZApwZ19yZXN0b3JlIC1kIHBvc3RncmVzIC90bXAvYS5kdW1wCg== --_004_2C1933ABC2F8499B9D184AC1882256A0amazoncom_--