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 1nJwSt-0001zj-13 for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Feb 2022 11:57:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJwSr-0005OR-UL for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Feb 2022 11:57:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJtZE-0001lR-Mf for pgsql-bugs@lists.postgresql.org; Tue, 15 Feb 2022 08:52:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nJtZ8-0002y2-3o for pgsql-bugs@lists.postgresql.org; Tue, 15 Feb 2022 08:52:12 +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=CeIAC17mt4rS+ASoKG9FtsbEQMps76QPtl1hITkaBQQ=; b=NWtyRer7qQWn/X9cTmbuoyd9Sd drHMtDQ27hH8GmHA8+5DhFb7Q7qfC0A88wXEYx5pFrE5Uv/QPlPWLbP37hjngEdcNNP332B5V5w8C +PnWrGZezAZWQdISIYbI+QQDuaLQTrvApNBvi3SMN3rSfvxEjWRNGPhOrr4mKsICXlMcoEAIX7As1 ZOOitl6iEC+vsUAnyNMRwj3566cMerXDDmB7oKVR2qD57DdccSDzchp1nqpsXlOuWo4FfpjeztT43 piYb404Inb8nUMTvm+E3qj1tAXebZ/A0W8Re9PO42VVS7YNrYowd8PTBFcdUy2mhX3HRv8is0C1PX +hNWbwsg==; 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 1nJtZ6-00089o-Ra for pgsql-bugs@lists.postgresql.org; Tue, 15 Feb 2022 08:52:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJtZ4-0003Ip-NS for pgsql-bugs@lists.postgresql.org; Tue, 15 Feb 2022 08:52:02 +0000 Content-Type: multipart/mixed; boundary="===============6183716205794495672==" MIME-Version: 1.0 Subject: BUG #17404: CREATE OR REPLACE VIEW does not properly change the COLLATION of an existing field. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: pageorge@unice.fr Reply-To: pageorge@unice.fr, pgsql-bugs@lists.postgresql.org Date: Tue, 15 Feb 2022 08:51:11 +0000 Message-ID: <17404-8a4a270ef30a6709@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 --===============6183716205794495672== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQwNApMb2dnZWQgYnk6ICAgICAgICAgIFBpZXJyZS1BdXLDqWxpZW4g R0VPUkdFUwpFbWFpbCBhZGRyZXNzOiAgICAgIHBhZ2VvcmdlQHVuaWNlLmZyClBvc3RncmVTUUwg dmVyc2lvbjogMTIuNApPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiA4LjMuMC02ICh4ODZfNjQt cGMtbGludXgtZ251KQpEZXNjcmlwdGlvbjogICAgICAgIAoKMyBTVEVQUyBUTyBSRVBST0RVQ0Ug OiANCj09PT09PT09PT09PT09PT09PT09PT09PQ0KY3JlYXRlIFRBQkxFIG15X3RhYmxlIChteV90 ZXh0IFRFWFQpOw0KY3JlYXRlIFZJRVcgbXlfdmlldyBBUyBTRUxFQ1QgbXlfdGV4dCBDT0xMQVRF ICJDIiBGUk9NIG15X3RhYmxlOw0KY3JlYXRlIE9SIFJFUExBQ0UgdmlldyBteV92aWV3IEFTIFNF TEVDVCBteV90ZXh0IENPTExBVEUgImVuX1VTLnV0ZjgiIEZST00KbXlfdGFibGU7DQoNCkVYUEVD VEVEIFJFU1VMVCA6DQo9PT09PT09PT09PT09PT09PT09DQpUaGUgQ09MTEFUSU9OIG9mICJteV92 aWV3Ii4ibXlfdGV4dCIgc2hvdWxkIGhhdmUgYmVlbiBjaGFuZ2VkIHRvCiJlbl9VUy51dGY4Ii4g IA0KLSBPUiAtDQpJIHNob3VsZCBoYXZlIGdvdCBhbiBlcnJvciBtZXNzYWdlIHRlbGxpbmcgbWUg dGhhdCBpdCBpcyBub3QgcG9zc2libGUuDQoNCk9CU0VSVkVEIFJFU1VMVCA6IA0KPT09PT09PT09 PT09PT09PT09PQ0KTm90aGluZyAoaXQgc2lsZW50bHkgZmFpbHMpLg0KDQpzZWxlY3QgdGFibGVf c2NoZW1hLCB0YWJsZV9uYW1lLCBjb2x1bW5fbmFtZSwgY29sbGF0aW9uX25hbWUgZnJvbQppbmZv cm1hdGlvbl9zY2hlbWEuY29sdW1ucyB3aGVyZSBjb2xsYXRpb25fbmFtZSBpcyBub3QgbnVsbCBh bmQKdGFibGVfbmFtZT0nbXlfdmlldyc7DQpjbGVhcmx5IHNob3dzIHRoYXQgdGhlIENPTExBVElP TiBoYXMgbm90IGJlZW4gY2hhbmdlZCBhcyByZXF1ZXN0ZWQuIA0KDQpXaGF0IHRoZSBkb2Mgc2F5 cyBhYm91dCBDUkVBVEUgT1IgUkVQTEFDRSBWSUVXIDoNCj09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PSANCiJUaGUgbmV3IHF1ZXJ5IG11c3QgZ2VuZXJhdGUgdGhl IHNhbWUgY29sdW1ucyB0aGF0IHdlcmUgZ2VuZXJhdGVkIGJ5IHRoZQpleGlzdGluZyB2aWV3IHF1 ZXJ5ICh0aGF0IGlzLCB0aGUgc2FtZSBjb2x1bW4gbmFtZXMgaW4gdGhlIHNhbWUgb3JkZXIgYW5k CndpdGggdGhlICpzYW1lIGRhdGEgdHlwZXMqKSwgYnV0IGl0IG1heSBhZGQgYWRkaXRpb25hbCBj b2x1bW5zIHRvIHRoZSBlbmQgb2YKdGhlIGxpc3QuIA0KKlRoZSBjYWxjdWxhdGlvbnMgZ2l2aW5n IHJpc2UgdG8gdGhlIG91dHB1dCBjb2x1bW5zIG1heSBiZSBjb21wbGV0ZWx5CmRpZmZlcmVudCou Ig0KDQpJdCBkb2Vzbid0IHNheSB3ZXRoZXIgdGhlIENPTExBVElPTiBpcyBjb25zaWRlcmVkIGJl aW5nIHBhcnQgb2YgdGhlICJkYXRhCnR5cGVzIiBvciBub3QsIGkuZS4gaXQgZG9lc24ndCBzYXkg d2V0aGVyIGl0J3MgcG9zc2libGUgdG8gY2hhbmdlIHRoZQpDT0xMQVRJT04gb2YgYW4gZXhpc3Rp bmcgZmllbGQgb3Igbm90Lg0KTXkgdGVzdHMgKHVuZGVyIFBvc3RncmVzIHYuIDEyLjQpIHRyeWlu ZyB0byBkbyBzbyBzaG93ZWQgdGhhdCBwb3N0Z3JlcyBzYXlzCm5vdGhpbmcgYW5kIHNlZW1zIHRv IGFjY2VwdCB0aGUgU1FMIHN0YXRlbWVudCwgYnV0IG5vdGhpbmcgaXMgY2hhbmdlZCBpbiB0aGUK ZGF0YWJhc2UgKGl0IHNpbGVudGx5IGZhaWxzKS4gRnJvbSB0aGUgdXNlciBwZXJzcGVjdGl2ZSwg SSBjb25zaWRlciBzdWNoIGEKc2lsZW50IGZhaWx1cmUgdGhlIFdPUlNUIHNpdHVhdGlvbiBwb3Nz aWJsZSA6IEkgd291bGQgcHJlZmVyIGVpdGhlciAxKSB0bwpnZXQgYW4gZXJyb3IgbWVzc2FnZSBz YXlpbmcgdGhhdCBpdCdzIG5vdCBwb3NzaWJsZSB0byBjaGFuZ2UgdGhlIENPTExBVElPTgpvZiBh biBleGlzdGluZyBmaWVsZCAtIE9SIGV2ZW4gYmV0dGVyIC0gMikgdG8gYWN0dWFsbHkgY2hhbmdl IHRoZSBDT0xMQVRJT04Kb2YgdGhlIGV4aXN0aW5nIGZpZWxkLCBhcyByZXF1ZXN0ZWQuDQoNCkZv ciB0aGlzIHJlYXNvbiwgSSBoYXZlIGFsc28gcmVwb3J0ZWQgYSBkb2N1bWVudGF0aW9uIGlzc3Vl LgoK --===============6183716205794495672==--