Re: Displaying and dumping of table access methods - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Displaying and dumping of table access methods
Date
Msg-id 52fd7216-8f65-28e5-660d-dc69e169b42c@2ndquadrant.com
Whole thread Raw
In response to Displaying and dumping of table access methods  (Andres Freund <andres@anarazel.de>)
Responses Re: Displaying and dumping of table access methods  (Andres Freund <andres@anarazel.de>)
List 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 by date:

Previous
From: Richard Guo
Date:
Subject: Re: Fast path for empty relids in check_outerjoin_delay()
Next
From: Michael Banck
Date:
Subject: Re: Offline enabling/disabling of data checksums