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 <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nJzTD-00026i-5u
	for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 15:10:23 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nJzTC-0000VW-2d
	for pgsql-docs@arkaria.postgresql.org; Tue, 15 Feb 2022 15:10:22 +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 <david.g.johnston@gmail.com>)
	id 1nJzTB-0000VN-Rk
	for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 15:10:21 +0000
Received: from mail-vk1-xa2f.google.com ([2607:f8b0:4864:20::a2f])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1nJzT9-0005xb-DG
	for pgsql-docs@lists.postgresql.org; Tue, 15 Feb 2022 15:10:21 +0000
Received: by mail-vk1-xa2f.google.com with SMTP id o129so10278048vko.7
        for <pgsql-docs@lists.postgresql.org>;
 Tue, 15 Feb 2022 07:10:19 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to;
        bh=cY5u3lBxjyBr7XBfOOFcLAiHrK7u93LSUgHNXwspiVE=;
        b=kZ+ayeV/5fQraZEpHe930u9dQih51InPnMyo5n9TDzRAhmudUb5aiZMqlDRaWyVkEv
         yJtcRzg3moP7OEPASASFW8DREWlMGW1KJnvPcporCaSghV8BpQ7oWQIAdItXVIK/uosJ
         7Yo0ZblNvah+Ran494VZVVbO3sK2pH4yRa8taZnLOvmWoNm6U/ZQU3gPqJRcfmEoEWRz
         I2sOxOL9ZLhZyl0OQHTq8hbIuDtkVdwd5YWdbGJTGqeedQJ92PzY2C8fWeB0QWfAnPJ0
         yKbWXasqO/Ysug8zbYZK7lNueaI1frylRt2YKO1IAGWvdMqjKLbUTHGALqyt/qEHrZWf
         dQfQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to;
        bh=cY5u3lBxjyBr7XBfOOFcLAiHrK7u93LSUgHNXwspiVE=;
        b=Bu0DbwURkxcJX8BeHcIXO+D/at9fyZN+11x+eYZYqSWQR/5zkl1gWnpeOJSP1q2v2D
         /uhXO65clW+OvxVcUeiPcZq8MS77uzkQz4+UsKM1sO/HD3sdEQOf2Kr0FNpGNFwPF504
         M/PFKNtgbgkC2md9ewRTis8GjEB4YpTIr4SDr9Jf99zcq8Y0QtCyLZdtcDvzn1CM4/X7
         R7RXUBVEkcHkvlPz8DO7AlrC3VsSIc+4ftIt1+qRrJ+GhG19PEnmIibmRRMM5EkMbWPZ
         s69ohFOPfi146rZ+68ee54UdKtvy0v222x0WS8zFls+91xUbXNF0vwTctQ6XimU5dVRg
         DtmQ==
X-Gm-Message-State: AOAM533s1j19DfkD2jBd8svfjf6ZwqdYA8gn/JOh23H2Y+qyN1XrzaNN
	Oxs8hKTmOra1+hIqxmjjpq1JrrKhEsJORdEI5zLNMVQZ
X-Google-Smtp-Source: 
 ABdhPJzUuUrMTcb77zv0SLCTij7IJVqd0VVPCHLxYLxL3sgLZKJqWNthq7s6TPeKc0/p85lPCAkGlcTSdnHySmuHWlE=
X-Received: by 2002:a1f:17c7:: with SMTP id 190mr1638380vkx.41.1644937817983;
 Tue, 15 Feb 2022 07:10:17 -0800 (PST)
MIME-Version: 1.0
References: <164491377967.23316.6256247353274439441@wrigleys.postgresql.org>
In-Reply-To: <164491377967.23316.6256247353274439441@wrigleys.postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 15 Feb 2022 08:10:00 -0700
Message-ID: 
 <CAKFQuwZSkg-O4TECajpcxuO=ftOkyiVhGeAPUhE49QnCVkUi9w@mail.gmail.com>
Subject: Re: Doc says nothing about wether CREATE OR REPLACE VIEW can change
 the COLLATION of an existing field
To: pageorge@unice.fr, Pg Docs <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000518fff05d80fee4c"
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZSkg-O4TECajpcxuO%3DftOkyiVhGeAPUhE49QnCVkUi9w%40mail.gmail.com>
Precedence: bulk

--000000000000518fff05d80fee4c
Content-Type: text/plain; charset="UTF-8"

On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form <noreply@postgresql.org>
wrote:

> For this reason, I'm also filling a bug report, since postgresql's reaction
> was not adapted to my request (neither an appropriate error message nor
> successful execution of my SQL statement).
>

The bug report is valid and sufficient.  We really don't want to have two
threads active discussing the issue.

David J.

--000000000000518fff05d80fee4c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Feb 15, 2022 at 8:04 AM PG Doc comments form &lt;<=
a href=3D"mailto:noreply@postgresql.org">noreply@postgresql.org</a>&gt; wro=
te:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">For this reason, I&#39;m also filling a bug rep=
ort, since postgresql&#39;s reaction<br>
was not adapted to my request (neither an appropriate error message nor<br>
successful execution of my SQL statement).<br></blockquote><div><br></div><=
div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif=
">The bug report is valid and sufficient.=C2=A0 We really don&#39;t want to=
 have two threads active discussing the issue.</div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David J=
.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif"></div></div></div>

--000000000000518fff05d80fee4c--