Postgres Pro
Downloads
Home   >   mailing lists

Re: Fix projection of pg_type for Greenplum query - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Fix projection of pg_type for Greenplum query
Date
Msg-id CA+OCxoxw7PFnrUsMJe0trL5VjV6B3_w2R3Lt6rRBNtCuTo4V8Q@mail.gmail.com
Whole thread Raw
In response to Fix projection of pg_type for Greenplum query  (Daniel Gustafsson <daniel@yesql.se>)
List pgadmin-hackers
Tree view
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

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Fix generation of reverse engineered SQL for tables w
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Add support for generated columns in Postgres 12+. Fi