installcheck failure in indirect_toast with default_toast_compression = lz4

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема installcheck failure in indirect_toast with default_toast_compression = lz4
Дата
Msg-id YLrDWxJgM8WWMoCg@paquier.xyz
обсуждение исходный текст
Ответы Re: installcheck failure in indirect_toast with default_toast_compression = lz4  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: installcheck failure in indirect_toast with default_toast_compression = lz4  (Justin Pryzby <pryzby@telsasoft.com>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: alter table set TABLE ACCESS METHOD
Следующее
От: Tom Lane
Дата:
Сообщение: Re: installcheck failure in indirect_toast with default_toast_compression = lz4