Re: Views no longer in rangeTabls?

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Views no longer in rangeTabls?
Дата
Msg-id b8a0b834-c936-d135-df66-cc119ceb8205@pgmasters.net
обсуждение исходный текст
Ответ на Re: Views no longer in rangeTabls?  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Views no longer in rangeTabls?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 6/10/23 09:57, Amit Langote wrote:
> On Sat, Jun 10, 2023 at 15:51 David Steele <david@pgmasters.net 
> <mailto:david@pgmasters.net>> wrote:
>     On 6/9/23 19:14, Tom Lane wrote:
>      >
>      > If you see "rte->rtekind == RTE_SUBQUERY && OidIsValid(rte->relid)",
>      > it's dead certain that relid refers to a view, so you could just wire
>      > in that knowledge.
> 
>     Yeah, that's a good trick. Even so, I wonder why relkind is not set
>     when
>     relid is set?
> 
> I too have been thinking that setting relkind might be a good idea, even 
> if only as a crosscheck that only view relations can look like that in 
> the range table.

+1. Even better if we can do it for PG16.

Regards,
-David



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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Views no longer in rangeTabls?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Let's make PostgreSQL multi-threaded