Re: installcheck failure in indirect_toast with default_toast_compression = lz4
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael@paquier.xyz>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>,
Robert Haas <robertmhaas@gmail.com>
Date: 2021-06-05T00:28:59Z
Lists: pgsql-hackers
Michael Paquier <michael@paquier.xyz> writes: > The issue is that the ordering of the tuples returned by UPDATE > RETURNING is not completely stable. Perhaps we should just enforce > the order of those tuples by wrapping the DMLs into a CTE and use an > ORDER BY in the outer query. Hmm. I'm not very clear on what that test is intending to test, but maybe it's dependent on pglz compression, in which case the right fix would be to force default_toast_compression = pglz for the duration of the test. regards, tom lane
Commits
-
Fix portability issue in test indirect_toast
- 68a6d8a87006 14.0 landed