Re: GenBKI emits useless open;close for catalogs without rows

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: GenBKI emits useless open;close for catalogs without rows
Дата
Msg-id 20230901174330.6jbe4izkew4nlt7k@alvherre.pgsql
обсуждение исходный текст
Ответ на GenBKI emits useless open;close for catalogs without rows  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Ответы Re: GenBKI emits useless open;close for catalogs without rows  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Re: GenBKI emits useless open;close for catalogs without rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 2023-Sep-01, Matthias van de Meent wrote:

> A potential addition to the patch would to stop manually closing
> relations: initdb and check-world succeed without manual 'close'
> operations because the 'open' command auto-closes the previous open
> relation (in boot_openrel). Testing also suggests that the last opened
> relation apparently doesn't need closing - check-world succeeds
> without issues (incl. with TAP enabled). That is therefore implemented
> in attached patch 2 - it removes the 'close' syntax in its entirety.

Hmm, what happens with the last relation in the bootstrap process?  Is
closerel() called via some other path for that one?

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
Essentially, you're proposing Kevlar shoes as a solution for the problem
that you want to walk around carrying a loaded gun aimed at your foot.
(Tom Lane)



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Inefficiency in parallel pg_restore with many tables
Следующее
От: Matthias van de Meent
Дата:
Сообщение: Re: GenBKI emits useless open;close for catalogs without rows