Re: Make attstattarget nullable
Peter Eisentraut <peter@eisentraut.org>
From: Peter Eisentraut <peter@eisentraut.org>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>,
Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2024-03-17T12:51:39Z
Lists: pgsql-hackers
On 14.03.24 15:46, Tomas Vondra wrote: >>>>> 2) The newtarget handling in AlterStatistics seems rather confusing. >>>>> Why >>>>> does it get set to -1 just to ignore the value later? For a while I was >>>>> 99% sure ALTER STATISTICS ... SET STATISTICS DEFAULT will set the field >>>>> to -1. Maybe ditching the first if block and directly checking >>>>> stmt->stxstattarget before setting repl_val/repl_null would be better? >>>> >>>> But we also need to continue accepting -1 for default on input. The >>>> current code achieves that, the proposed variant would not. >>> >>> OK, I did not realize that. But then maybe this should be explained in a >>> comment before the new "if" block, because people won't realize why it >>> needs to be this way. >> >> In the new version, I tried to write this more explicitly, and updated >> tablecmds.c to match. > > WFM. It still seems a bit hard to read, but I don't know how to do it > better. I guess it's how it has to be to deal with multiple default > values in a backwards-compatible way. Good thing is it's localized in > two places. I have committed this patch series. Thanks.
Commits
-
Initialize variables to placate compiler.
- 949300402bde 17.0 landed
-
Add attstattarget to FormExtraData_pg_attribute
- 6a004f1be87d 17.0 landed
-
Generalize handling of nullable pg_attribute columns in DDL
- d939cb2fd612 17.0 landed
-
Make stxstattarget nullable
- 012460ee93c3 17.0 landed
-
Make attstattarget nullable
- 4f622503d6de 17.0 landed