Обсуждение: StatisticsObjIsVisibleExt lacks "do not look in temp namespace"

Поиск
Список
Период
Сортировка

StatisticsObjIsVisibleExt lacks "do not look in temp namespace"

От
Noah Misch
Дата:
StatisticsObjIsVisibleExt() lacks the "do not look in temp namespace" code of
the rest of the non-relation, non-type namespace searches.  Patch attached.
See its log messages for the consequences.

Incidentally, stats on temp tables do default to a permanent schema.  That
seems fine, though:

set search_path = public;
CREATE TEMP TABLE ab1 (a INTEGER, b INTEGER, c INTEGER);
CREATE STATISTICS s ON a, b FROM ab1;  -- creates public.s
\dX *.*

Вложения

Re: StatisticsObjIsVisibleExt lacks "do not look in temp namespace"

От
Nathan Bossart
Дата:
On Sat, Sep 20, 2025 at 09:21:16AM -0700, Noah Misch wrote:
> StatisticsObjIsVisibleExt() lacks the "do not look in temp namespace" code of
> the rest of the non-relation, non-type namespace searches.  Patch attached.

LGTM

-- 
nathan