Re: Displaying and dumping of table access methods

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Displaying and dumping of table access methods
Дата
Msg-id 52fd7216-8f65-28e5-660d-dc69e169b42c@2ndquadrant.com
обсуждение исходный текст
Ответ на Displaying and dumping of table access methods  (Andres Freund <andres@anarazel.de>)
Ответы Re: Displaying and dumping of table access methods  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On 08/01/2019 00:56, Andres Freund wrote:
> A patch at [2] adds display of a table's access method to \d+ - but that
> means that running the tests with a different default table access
> method (e.g. using PGOPTIONS='-c default_table_access_method=...)
> there'll be a significant number of test failures, even though the test
> results did not meaningfully differ.

For psql, a variable that hides the access method if it's the default.

> Similarly, if pg_dump starts to dump table access methods either
> unconditionally, or for all non-heap AMS, the pg_dump tests fail due to
> unimportant differences.

For pg_dump, track and set the default_table_access_method setting
throughout the dump (similar to how default_with_oids was handled, I
believe).

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: Fast path for empty relids in check_outerjoin_delay()
Следующее
От: Michael Banck
Дата:
Сообщение: Re: Offline enabling/disabling of data checksums