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 1nJzOs-0001j9-JK for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 15:05:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJzOr-0002lB-ED for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 15:05:53 +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 1nJtDt-00055E-AW for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 08:30:09 +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 1nJtDq-0005pG-8o for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 08:30:08 +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=ngsp24GGsZMkuNuk1VcCrunIQZRh5ntFfspAMNvHxSc=; b=GP7ag1iJ75Fg1dL6N1bnITRFhD W45nnHE+4r+MRD3WpW3hQBqy5tOcsgcB6tenBwcnuPRaHReHBXUhVigXe/ZyA9SWC9DLi/QErIj2c JrIrqP8SGfqG7DMtEcMNb+uxxP9F7g5sl+0Ypjx22u5sSaaM8eglmarl5QD3w+wmL798jGoflm2II MWlLSKU5s/L9ajX/ahiKpf4c0EFeLoGUPX3JquUOEgyE63Dixo6Gp1Mre/334aFDIf8v9IjRCl1MP pVf1a6iRJu8ltW6coWFlUu1sXPTTQPxYh7aU24HCYvbzGGqmCcSo+KjhoLgAmVajhZ+oEZ7rfEJUL 8Dt7v3Fg==; 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 1nJtDp-0007ZP-L1 for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 08:30:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJtDm-0002lF-Mg for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 08:30:02 +0000 Content-Type: multipart/mixed; boundary="===============1701983782330087104==" MIME-Version: 1.0 Subject: Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: pageorge@unice.fr Reply-To: pageorge@unice.fr, pgsql-docs@lists.postgresql.org Date: Tue, 15 Feb 2022 08:29:39 +0000 Message-ID: <164491377967.23316.6256247353274439441@wrigleys.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 --===============1701983782330087104== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNC9zcWwt Y3JlYXRldmlldy5odG1sCkRlc2NyaXB0aW9uOgoKV2hhdCB0aGUgZG9jIHNheXMgYWJvdXQgQ1JF QVRFIE9SIFJFUExBQ0UgVklFVyA6IA0KIlRoZSBuZXcgcXVlcnkgbXVzdCBnZW5lcmF0ZSB0aGUg c2FtZSBjb2x1bW5zIHRoYXQgd2VyZSBnZW5lcmF0ZWQgYnkgdGhlCmV4aXN0aW5nIHZpZXcgcXVl cnkgKHRoYXQgaXMsIHRoZSBzYW1lIGNvbHVtbiBuYW1lcyBpbiB0aGUgc2FtZSBvcmRlciBhbmQK d2l0aCB0aGUgKnNhbWUgZGF0YSB0eXBlcyopLCBidXQgaXQgbWF5IGFkZCBhZGRpdGlvbmFsIGNv bHVtbnMgdG8gdGhlIGVuZCBvZgp0aGUgbGlzdC4gDQoqVGhlIGNhbGN1bGF0aW9ucyBnaXZpbmcg cmlzZSB0byB0aGUgb3V0cHV0IGNvbHVtbnMgbWF5IGJlIGNvbXBsZXRlbHkKZGlmZmVyZW50Ki4i DQoNCkl0IGRvZXNuJ3Qgc2F5IHdldGhlciB0aGUgQ09MTEFUSU9OIGlzIGNvbnNpZGVyZWQgYmVp bmcgcGFydCBvZiB0aGUgImRhdGEKdHlwZXMiIG9yIG5vdCwgaS5lLiBpdCBkb2Vzbid0IHNheSB3 ZXRoZXIgaXQncyBwb3NzaWJsZSB0byBjaGFuZ2UgdGhlCkNPTExBVElPTiBvZiBhbiBleGlzdGlu ZyBmaWVsZCBvciBub3QuDQpNeSB0ZXN0cyAodW5kZXIgUG9zdGdyZXMgdi4gMTIuNCkgc2hvd2Vk IHRoYXQgdGhlIENPTExBVElPTiBvZiBhbiBleGlzdGluZwpmaWVsZCBjYW4gbm90IGJlIGNoYW5n ZWQgOiB0cnlpbmcgdG8gZG8gc28sIHBvc3RncmVzIHNheXMgbm90aGluZyBhbmQgc2VlbXMKdG8g YWNjZXB0IHRoZSBTUUwgc3RhdGVtZW50LCBidXQgbm90aGluZyBpcyBjaGFuZ2VkIGluIHRoZSBk YXRhYmFzZSAoaXQKc2lsZW50bHkgZmFpbHMpLiBGcm9tIHRoZSB1c2VyIHBlcnNwZWN0aXZlLCBJ IGNvbnNpZGVyIHN1Y2ggYSBzaWxlbnQgZmFpbHVyZQp0aGUgV09SU1Qgc2l0dWF0aW9uIHBvc3Np YmxlIDogSSB3b3VsZCBwcmVmZXIgZWl0aGVyIDEpIHRvIGdldCBhbiBlcnJvcgptZXNzYWdlIHNh eWluZyB0aGF0IGl0J3Mgbm90IHBvc3NpYmxlIHRvIGNoYW5nZSB0aGUgQ09MTEFUSU9OIG9mIGFu IGV4aXN0aW5nCmZpZWxkIC0gT1IgZXZlbiBiZXR0ZXIgLSAyKSB0byBhY3R1YWxseSBjaGFuZ2Ug dGhlIENPTExBVElPTiBvZiB0aGUgZXhpc3RpbmcKZmllbGQsIGFzIHJlcXVlc3RlZC4NCg0KRm9y IHRoaXMgcmVhc29uLCBJJ20gYWxzbyBmaWxsaW5nIGEgYnVnIHJlcG9ydCwgc2luY2UgcG9zdGdy ZXNxbCdzIHJlYWN0aW9uCndhcyBub3QgYWRhcHRlZCB0byBteSByZXF1ZXN0IChuZWl0aGVyIGFu IGFwcHJvcHJpYXRlIGVycm9yIG1lc3NhZ2Ugbm9yCnN1Y2Nlc3NmdWwgZXhlY3V0aW9uIG9mIG15 IFNRTCBzdGF0ZW1lbnQpLgo= --===============1701983782330087104==--