Re: BUG #18468: CREATE TABLE ... LIKE leaves orphaned column reference in extended statistics

Поиск
Список
Период
Сортировка
От Tender Wang
Тема Re: BUG #18468: CREATE TABLE ... LIKE leaves orphaned column reference in extended statistics
Дата
Msg-id CAHewXN=GgqYBULpWHOrAVU=3JkYEdh=2+VgWPBc8soe9iv8_YQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18468: CREATE TABLE ... LIKE leaves orphaned column reference in extended statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs


Tom Lane <tgl@sss.pgh.pa.us> 于2024年5月18日周六 04:39写道:
I wrote:
> We don't know the column mapping there, either.  What we need to have
> our hands on is the "attmap" computed in expandTableLikeClause, and
> then we can pass the stats expressions through map_variable_attnos().

> I think this might not need to be a really large patch, but it
> definitely has to change where generateClonedExtStatsStmt is
> called from.  I can have a go at it if Tomas doesn't want to.

Yeah, this doesn't require a whole lot more than moving the
processing in transformTableLikeClause to expandTableLikeClause.

I chose to get rid of transformExtendedStatistics, because not
only is there nothing for it to do, there will never be any
statements for it to do nothing to.
 
The patch looks good to me.

--
Tender Wang
OpenPie:  https://en.openpie.com/

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

Предыдущее
От: torikoshia
Дата:
Сообщение: Re: Logical Replica ReorderBuffer Size Accounting Issues
Следующее
От: Önder Kalacı
Дата:
Сообщение: Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption