Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rom7Z-003IAS-2I for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Mar 2024 15:20:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rom7X-004mZm-Jm for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Mar 2024 15:20:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rolfK-004PUj-W8 for pgsql-bugs@lists.postgresql.org; Mon, 25 Mar 2024 14:51:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rolfG-006PxQ-HC for pgsql-bugs@lists.postgresql.org; Mon, 25 Mar 2024 14:51: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=Yeso7wYInvynM5tqdlLX1O0F52tHZ0MUBW9lML1YD8I=; b=2h1MOgP9UTTNnEvH4zMzmMpDAv rweiXbaM4hHuwWk+EdpdVxPvD3rnrry4BNSkSfk1IgZGkQ0tf1qnjBx2lq4U7v0v3A5LVfxbJhHZ5 /VK/kOBlnpPx5I0E2BWcWjnTQsEVsj/akoDHeryiFe8sM8ujpONrjuPmRTTj1Mr+5LctCpBVp2wpb CepUcSgc/EqhBZQZ4zS12KM/zUNapma8qUlLW775IZwOFr4BMvATDXIrdJvFrzUicKtN8KP84yOiT vaqwKM6feV8lwigwdtJ/vOthBoUpuLEu2BbZogtspp9qeSKok1LNPS6qsaKnFJgBP0JRbJ5Q5uWQg I5LufCtg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rolfF-0003Fi-5w for pgsql-bugs@lists.postgresql.org; Mon, 25 Mar 2024 14:51:05 +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 1rolfC-008Dlt-BJ for pgsql-bugs@lists.postgresql.org; Mon, 25 Mar 2024 14:51:03 +0000 Content-Type: multipart/mixed; boundary="===============0097038424046104744==" MIME-Version: 1.0 Subject: BUG #18407: ALTER TABLE SET SCHEMA on foreign table with SERIAL column does not move sequence to new schema To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: vidushi2504@gmail.com Reply-To: vidushi2504@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 25 Mar 2024 14:50:53 +0000 Message-ID: <18407-4fd07373d252c6a0@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 --===============0097038424046104744== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQwNwpMb2dnZWQgYnk6ICAgICAgICAgIFZpZHVzaGkgR3VwdGEKRW1h aWwgYWRkcmVzczogICAgICB2aWR1c2hpMjUwNEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNi4wCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRpb246ICAgICAgICAKCkhp LA0KDQpJIGNyZWF0ZWQgYSBmb3JlaWduIHRhYmxlIHdpdGggYSBzZXJpYWwgY29sdW1uIGFuZCB0 aGVuIG1vdmVkIHRoZSB0YWJsZSB0byBhCmRpZmZlcmVudCBzY2hlbWEuIFRoZSBzZXF1ZW5jZSBi b3VuZCB0byB0aGUgdGFibGUgY29sdW1uIHdhc24ndCBtb3ZlZCB0byB0aGUKbmV3IHNjaGVtYS4g SSBleHBlY3RlZCB0aGUgc2VxdWVuY2UgdG8gYmUgbW92ZWQgYXMgd2VsbCBqdXN0IGxpa2UgaXQg d29ya3MKZm9yIHJlZ3VsYXIgdGFibGVzLg0KDQpUaGUgZG9jdW1lbnRhdGlvbiBmb3IgQUxURVIg Rk9SRUlHTiBUQUJMRSBTRVQgU0NIRU1BIGRvZXNuJ3QgbWVudGlvbgphbnl0aGluZyBhYm91dCBv YmplY3RzIHJlbGF0ZWQgdG8gZm9yZWlnbiB0YWJsZXMuDQoNCldoYXQgaXMgdGhlIGV4cGVjdGVk IGJlaGF2aW91ciBoZXJlPw0KIA0KU3RlcHMgdG8gcmVwcm9kdWNlOg0KYGBgDQpwb3N0Z3Jlcz0j IGNyZWF0ZSBkYXRhYmFzZSBkMjsNCkNSRUFURSBEQVRBQkFTRQ0KcG9zdGdyZXM9IyBcYyBkMg0K WW91IGFyZSBub3cgY29ubmVjdGVkIHRvIGRhdGFiYXNlICJkMiIgYXMgdXNlciAicG9zdGdyZXMi Lg0KZDI9IyBjcmVhdGUgdGFibGUgdChhIHNlcmlhbCk7DQpDUkVBVEUgVEFCTEUNCmQyPSMgXGMg cG9zdGdyZXMNCllvdSBhcmUgbm93IGNvbm5lY3RlZCB0byBkYXRhYmFzZSAicG9zdGdyZXMiIGFz IHVzZXIgInBvc3RncmVzIi4NCnBvc3RncmVzPSMgY3JlYXRlIGV4dGVuc2lvbiBwb3N0Z3Jlc19m ZHc7DQpDUkVBVEUgRVhURU5TSU9ODQpwb3N0Z3Jlcz0jIGNyZWF0ZSBzZXJ2ZXIgcG9zdGdyZXNf MiBmb3JlaWduIGRhdGEgd3JhcHBlciBwb3N0Z3Jlc19mZHcgDQpvcHRpb25zIChkYm5hbWUgJ2Qy JywgaG9zdCAnMTI3LjAuMC4xJywgcG9ydCAnNTQzMicpOw0KDQpjcmVhdGUgdXNlciBtYXBwaW5n IGZvciBjdXJyZW50X3VzZXINCnNlcnZlciBwb3N0Z3Jlc18yIG9wdGlvbnMgKHVzZXIgJ3Bvc3Rn cmVzJyk7DQpDUkVBVEUgU0VSVkVSDQpDUkVBVEUgVVNFUiBNQVBQSU5HDQpwb3N0Z3Jlcz0jIGNy ZWF0ZSBmb3JlaWduIHRhYmxlIHRfcmVmIChhIHNlcmlhbCkgc2VydmVyIHBvc3RncmVzXzIgb3B0 aW9ucwooc2NoZW1hX25hbWUgJ3B1YmxpYycsIHRhYmxlX25hbWUgJ3QnKTsNCkNSRUFURSBGT1JF SUdOIFRBQkxFDQpwb3N0Z3Jlcz0jIFxkDQogICAgICAgICAgICAgICAgTGlzdCBvZiByZWxhdGlv bnMNCiBTY2hlbWEgfCAgICBOYW1lICAgICB8ICAgICBUeXBlICAgICAgfCAgT3duZXIgICANCi0t LS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0NCiBwdWJsaWMg fCB0X3JlZiAgICAgICB8IGZvcmVpZ24gdGFibGUgfCBwb3N0Z3Jlcw0KIHB1YmxpYyB8IHRfcmVm X2Ffc2VxIHwgc2VxdWVuY2UgICAgICB8IHBvc3RncmVzDQooMiByb3dzKQ0KDQpwb3N0Z3Jlcz0j IGNyZWF0ZSBzY2hlbWEgczsNCkNSRUFURSBTQ0hFTUENCnBvc3RncmVzPSMgYWx0ZXIgdGFibGUg dF9yZWYgc2V0IHNjaGVtYSBzOw0KQUxURVIgVEFCTEUNCnBvc3RncmVzPSMgXGQNCiAgICAgICAg ICAgICBMaXN0IG9mIHJlbGF0aW9ucw0KIFNjaGVtYSB8ICAgIE5hbWUgICAgIHwgICBUeXBlICAg fCAgT3duZXIgICANCi0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0t DQogcHVibGljIHwgdF9yZWZfYV9zZXEgfCBzZXF1ZW5jZSB8IHBvc3RncmVzDQooMSByb3cpDQoN CnBvc3RncmVzPSMgYWx0ZXIgc2VxdWVuY2UgdF9yZWZfYV9zZXEgc2V0IHNjaGVtYSBzOw0KRVJS T1I6ICBjYW5ub3QgbW92ZSBhbiBvd25lZCBzZXF1ZW5jZSBpbnRvIGFub3RoZXIgc2NoZW1hDQpE RVRBSUw6ICBTZXF1ZW5jZSAidF9yZWZfYV9zZXEiIGlzIGxpbmtlZCB0byB0YWJsZSAidF9yZWYi Lg0KcG9zdGdyZXM9IyANCg0KYGBgDQpBbmQgdGhlIHNhbWUgYmVoYXZpb3VyIHdpdGggQUxURVIg Rk9SRUlHTiBUQUJMRQ0KDQpgYGANCnBvc3RncmVzPSMgXGQNCiAgICAgICAgICAgICAgICBMaXN0 IG9mIHJlbGF0aW9ucw0KIFNjaGVtYSB8ICAgIE5hbWUgICAgIHwgICAgIFR5cGUgICAgICB8ICBP d25lciAgIA0KLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t LQ0KIHB1YmxpYyB8IHRfcmVmICAgICAgIHwgZm9yZWlnbiB0YWJsZSB8IHBvc3RncmVzDQogcHVi bGljIHwgdF9yZWZfYV9zZXEgfCBzZXF1ZW5jZSAgICAgIHwgcG9zdGdyZXMNCigyIHJvd3MpDQoN CnBvc3RncmVzPSMgYWx0ZXIgZm9yZWlnbiB0YWJsZSB0X3JlZiBzZXQgc2NoZW1hIHM7DQpBTFRF UiBGT1JFSUdOIFRBQkxFDQpwb3N0Z3Jlcz0jIFxkDQogICAgICAgICAgICAgTGlzdCBvZiByZWxh dGlvbnMNCiBTY2hlbWEgfCAgICBOYW1lICAgICB8ICAgVHlwZSAgIHwgIE93bmVyICAgDQotLS0t LS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLQ0KIHB1YmxpYyB8IHRfcmVm X2Ffc2VxIHwgc2VxdWVuY2UgfCBwb3N0Z3Jlcw0KDQpgYGANCg0KVGhhbmtzCgo= --===============0097038424046104744==--