Horton

installcheck failure in indirect_toast with default_toast_compression = lz4

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Date: 2021-06-05T00:20:43Z
Lists: pgsql-hackers

Attachments

Hi all,

As said in $subject, installcheck fails once I set up a server with
default_toast_compression = lz4 in the test indirect_toast.  Please
see the attached for the diffs.

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.

Other ideas?
--
Michael

Commits

  1. Fix portability issue in test indirect_toast