Обсуждение: Fix projection of pg_type for Greenplum query

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

Fix projection of pg_type for Greenplum query

От
Daniel Gustafsson
Дата:
The bug in https://redmine.postgresql.org/issues/4179 seems to be due to
pg_type being projected from but not selected, the attached patch adds a FROM
clause entry and also adds projection of typname.  This makes the query work on
5X_STABLE for me.

cheers ./daniel


Вложения

Re: Fix projection of pg_type for Greenplum query

От
Dave Page
Дата:
Thanks, patch applied.

On Tue, Jul 23, 2019 at 9:13 AM Daniel Gustafsson <daniel@yesql.se> wrote:
The bug in https://redmine.postgresql.org/issues/4179 seems to be due to
pg_type being projected from but not selected, the attached patch adds a FROM
clause entry and also adds projection of typname.  This makes the query work on
5X_STABLE for me.

cheers ./daniel



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company