On 02.07.24 18:51, Noah Misch wrote:
On Mon, Jul 01, 2024 at 06:19:08PM -0700, Jeff Davis wrote:
On Mon, 2024-07-01 at 16:03 -0700, Noah Misch wrote:
An alternative would be to make pg_upgrade reject
operating on a cluster that contains use of $SUBJECT.
That wouldn't help anyone.
Can you say more about that? For the last decade at least, I think our
standard for new features has been to error rather than allow an operation
that creates a known path to wrong query results. I think that's a helpful
standard that we should continue to follow.
I don't think the builtin locale provider is any different in this
respect from the other providers: The locale data might change and
there is a version mechanism to track that. We don't prevent pg_upgrade
in scenarios like that for other providers.
