pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard Guo <guofenglinux@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Ronald Cruz <cruz@rentec.com>
Cc: pgsql-bugs@lists.postgresql.org, Peter Ford <pford@rentec.com>
Cc: Aaron J. Garcia <agarcia@rentec.com>
Subject: Re: Query result differences between PostgreSQL 17 vs 16
Date: Tue, 11 Mar 2025 18:58:27 -0400
Message-ID: <Z9DAExs0YGLITyaZ@momjian.us> (raw)
In-Reply-To: <1837979.1741731589@sss.pgh.pa.us>
References: <CAMbWs4_SqFDZ1Mnp0Kmy-H2s7_-PdeuXva+kBG-jKSampoDHnw@mail.gmail.com>
	<CAMbWs48-_meMqqbkFQoVEEKBYYsanMvRk3zCqmVr23gyxkNhag@mail.gmail.com>
	<2337383.1740630494@sss.pgh.pa.us>
	<CAMbWs4-ATTw82Pc3B+64im26JQEWHemC-6VcGzqqqo_mjCEqpw@mail.gmail.com>
	<2748914.1740757698@sss.pgh.pa.us>
	<CAMbWs4_4HBfqs+AjrtNOeqZYwKTJps2jANzdCbAfQSCd-CdeGA@mail.gmail.com>
	<3650809.1741015351@sss.pgh.pa.us>
	<CAMbWs4_35p90MAuEV_cU4s8bMyL1ci9oLbSgzmdTB_+umXvkSw@mail.gmail.com>
	<Z9CzPA0W3Zyvqb6g@momjian.us>
	<1837979.1741731589@sss.pgh.pa.us>

On Tue, Mar 11, 2025 at 06:19:49PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Uh, if we fixed this for NULL optimization and backpatched, should we do
> > the same for:
> > 	Parameter NOT NULL to CREATE DOMAIN not the same as CHECK (VALUE IS NOT NULL)
> > 	https://www.postgresql.org/message-id/flat/173591158454.714.7664064332419606037%40wrigleys.postgresq...
> 
> This is unrelated to that.

Well, I was trying to figure out if we should be changing the NULL
handling in 17.X, but now that you have done it with one patch, it seems
the above URL patch should also be applied and backpatched to 17, no?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.





view thread (23+ messages)  latest in thread

Message-ID: <Z9DAExs0YGLITyaZ@momjian.us>
Permalink:  ../Z9DAExs0YGLITyaZ@momjian.us/
Also on:    postgresql.org/message-id/Z9DAExs0YGLITyaZ@momjian.us

 · 

reply
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: bruce@momjian.us, tgl@sss.pgh.pa.us, guofenglinux@gmail.com, dgrowleyml@gmail.com, cruz@rentec.com, pford@rentec.com, agarcia@rentec.com
  Subject: Re: Query result differences between PostgreSQL 17 vs 16
  In-Reply-To: <Z9DAExs0YGLITyaZ@momjian.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