On Thu, Mar 21, 2019 at 5:01 PM Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > I already argued that TABLESPACE and OWNER TO are documented to work > that way, and have been for a long time, whereas REPLICA IDENTITY has > never been. If you want to change long-standing behavior, be my guest, > but that's not my patch. On the other hand, there's no consensus that > those should be changed, whereas there no opposition specifically > against changing this one, and in fact it was reported as a bug to me by > actual users.
Well, you have a commit bit, and I cannot prevent you from using it, and nobody else is backing me up here, but it doesn't change my opinion. I think it is HIGHLY irresponsible for you to try to characterize clear behavior changes in this area as "bug fixes." The fact that a user say that something is a bug does not make it a bug -- and you have been a committer long enough to know the difference between repairing a defect and inventing entirely new behavior. Yet you keep doing the latter and calling the former. Commit 33e6c34c32677a168bee4bc6c335aa8d73211a56 is a clear behavior change for partitioned indexes and yet has the innocuous subject line "Fix tablespace handling for partitioned indexes." Unbelievably, it was back-patched into 11.1. Everyone except you agreed that it created an inconsistency between tables and indexes, so commit ca4103025dfe26eaaf6a500dec9170fbb176eebc repaired that by doing the same thing for tables. That one wasn't back-patched, but it was still described as "Fix tablespace handling for partitioned tables", even though I said repeatedly that it wasn't a fix, because the actual behavior was the design behavior, and as the major reviewer and committer of those patches I ought to know. That latter patch also broke stuff which it looks like you haven't fixed yet: https://www.postgresql.org/message-id/cakjs1f_1c260not_vbj067az3jxptxvrohdvmlebmudx1ye...@mail.gmail.com That email thread even includes clear definitional concerns about whether this behavior is even properly designed: https://www.postgresql.org/message-id/20190306161744.22jdkg37fyi2zyke%40alap3.anarazel.de But I assume that's not going to stop you from propagating the same kinds of problems into more places. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company