installcheck failure in indirect_toast with default_toast_compression = lz4 - Mailing list pgsql-hackers

From Michael Paquier
Subject installcheck failure in indirect_toast with default_toast_compression = lz4
Date
Msg-id YLrDWxJgM8WWMoCg@paquier.xyz
Whole thread Raw
Responses Re: installcheck failure in indirect_toast with default_toast_compression = lz4
Re: installcheck failure in indirect_toast with default_toast_compression = lz4
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: alter table set TABLE ACCESS METHOD
Next
From: Tom Lane
Date:
Subject: Re: installcheck failure in indirect_toast with default_toast_compression = lz4