Re: Unqualified pg_catalog casts in pg_dump

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: Unqualified pg_catalog casts in pg_dump
Дата
Msg-id 4B5E249F-3DDD-4C61-9D54-93E8BDC80ED5@yesql.se
обсуждение исходный текст
Ответ на Re: Unqualified pg_catalog casts in pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Unqualified pg_catalog casts in pg_dump  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
> On 23 Mar 2020, at 17:54, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Daniel Gustafsson <daniel@yesql.se> writes:
>> When looking at something different, I happened to notice that pg_dump is a bit
>> inconsistent in how it qualifies casts to pg_catalog entities like regclass and
>> oid.  Most casts are qualified, but not all.  Even though it functionally is
>> the same, being consistent is a good thing IMO and I can't see a reason not to,
>> so the attached patch adds qualifications (the unqualified regclass cast in the
>> TAP test left on purpose).
>
> While this used to be important before we made pg_dump force a minimal
> search_path, I'm not sure that there's any point in being picky about
> it anymore.  (psql's describe.c is a different story though.)

Correct, there is no functional importance with this.  IMO the value is in
readability and grep-ability.

cheers ./daniel


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unqualified pg_catalog casts in pg_dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: weird hash plan cost, starting with pg10