Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOgkR-000awJ-Q9 for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jul 2024 16:52:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sOgjR-002vRf-PM for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jul 2024 16:51:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOgjR-002vOe-6Y for pgsql-hackers@lists.postgresql.org; Tue, 02 Jul 2024 16:51:54 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sOgjP-0005CU-Ex for pgsql-hackers@postgresql.org; Tue, 02 Jul 2024 16:51:53 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-64b29539d87so39117447b3.0 for ; Tue, 02 Jul 2024 09:51:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1719939109; x=1720543909; darn=postgresql.org; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=49Luz4WWo8TTLc7F6hNfYq/ULcRBqLguV0M+MlsaFN4=; b=YgvwKyxM3a+00RXySyvLFTberY9YW6svdCe8P/nv5KKVWKqBDtHgE5IGW9VMpE4H+f zTjpiv6F5SmBcTZSNO9wQncVOopW8aHhA6ULqnW3D0OmBNdbYCliAyUQojTcLw8iWLN1 +uPzqaUXxU9tgoFHHBkdP/QrkgmW8BYHG84Ko= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719939109; x=1720543909; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=49Luz4WWo8TTLc7F6hNfYq/ULcRBqLguV0M+MlsaFN4=; b=HdTodx9114IAX92XbIaEy4RKSI0c1gPbiNifUy+o8HXRaC3wuUgcMnhU4xjPPyUdoU OsFKfRz5jLOoCGb8PBeVHI2jSdKkKe95h9qJu6Ji5ysNFq7Q7DjWQN1V2KOJK4Q6wBQL 4nwjPLzdApUyVMlEv4f12U2TDQDYisA1x09bEc6vDd+CdhLBkAOc7aiUmd1b3Z0vQa65 9cJbL6SQKk9QJUwspg2ElKNsoOjI0BS+N/spQ+YSXZ+wBaP/NrbzOZkgnAh47PUM/Igv FIzrMyf0QrNuDaVo9XyNObcFHqkce7vG01LxHO1AlqbB806FqUXbG0jyOOF47ccZv0qU Gu3Q== X-Forwarded-Encrypted: i=1; AJvYcCWblEQXup3vUw3CogMYDfxaXCaB3eZEhdqCv84717w0Db7oEYSvk/S92Y2/1esPS/IAHgA5zRonQvN0RVZJDLEDcMxk3PrIl7AJGKjm X-Gm-Message-State: AOJu0YxNeHV5gUMX4hB4Y4XkzgXn06w+WG+h5REwvSgkSYDsq13BxaGX 0HhhyU6jcNNMphLoHiJhr8JyTCSCdireNEXGOacYNtxj9ZyuelzlUC6Cvk2pig== X-Google-Smtp-Source: AGHT+IGml7flAoQjFgvf83nMMpBUfESihRBIyhSzVYShXfC/Kp2fEBFDMbQZPRmaZNA/iQ5RHzpG7g== X-Received: by 2002:a0d:ea8f:0:b0:64a:b250:55f2 with SMTP id 00721157ae682-64dca2a6b58mr74528307b3.7.1719939109055; Tue, 02 Jul 2024 09:51:49 -0700 (PDT) Received: from google.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id 00721157ae682-64a9ba5a8d6sm18280347b3.98.2024.07.02.09.51.47 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 02 Jul 2024 09:51:48 -0700 (PDT) Date: Tue, 2 Jul 2024 09:51:45 -0700 From: Noah Misch To: Jeff Davis Cc: Peter Eisentraut , Daniel Verite , Robert Haas , Jeremy Schneider , pgsql-hackers@postgresql.org Subject: Re: Built-in CTYPE provider Message-ID: <20240702165145.af.nmisch@google.com> References: <846a7e1fa2024918b58ff7583523a2f3de9a11b4.camel@j-davis.com> <3117d30aa911b408b90420f4f280fa0c3b5851be.camel@j-davis.com> <4135cf11-206d-40ed-96c0-9363c1232379@eisentraut.org> <7451f81ba0cb512222ab759de8ca1cffe44e9acb.camel@j-davis.com> <1f309153-8198-4efa-86dd-8c304ec0040c@eisentraut.org> <20240629220857.fb.nmisch@google.com> <1ecfeb4d2b1b7f119fa917d3052a3aecfaf4f425.camel@j-davis.com> <20240701230352.2c.nmisch@google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.