From: Tom Lane <tgl@sss.pgh.pa.us>
To: pageorge@unice.fr
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17404: CREATE OR REPLACE VIEW does not properly change the COLLATION of an existing field.
Date: Tue, 15 Feb 2022 11:12:32 -0500
Message-ID: <3049978.1644941552@sss.pgh.pa.us> (raw)
In-Reply-To: <17404-8a4a270ef30a6709@postgresql.org>
References: <17404-8a4a270ef30a6709@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> create TABLE my_table (my_text TEXT);
> create VIEW my_view AS SELECT my_text COLLATE "C" FROM my_table;
> create OR REPLACE view my_view AS SELECT my_text COLLATE "en_US.utf8" FROM
> my_table;
> The COLLATION of "my_view"."my_text" should have been changed to
> "en_US.utf8".
> - OR -
> I should have got an error message telling me that it is not possible.
Yeah, that's a bug, it should have thrown an error.
(Changing the collation is impractical for the same reasons that
changing the output datatype is impractical.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, pageorge@unice.fr, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17404: CREATE OR REPLACE VIEW does not properly change the COLLATION of an existing field.
In-Reply-To: <3049978.1644941552@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox