Re: Fix projection of pg_type for Greenplum query

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: pgadmin-hackers <pgadmin-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix projection of pg_type for Greenplum query
Date: 2019-07-25 15:17:00
Message-ID: CA+OCxoxw7PFnrUsMJe0trL5VjV6B3_w2R3Lt6rRBNtCuTo4V8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, patch applied.

On Tue, Jul 23, 2019 at 9:13 AM Daniel Gustafsson <daniel(at)yesql(dot)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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2019-07-25 15:38:29 pgAdmin 4 commit: Add support for generated columns in Postgres 12+. Fi
Previous Message Dave Page 2019-07-25 15:16:51 pgAdmin 4 commit: Fix generation of reverse engineered SQL for tables w