Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgadmin-hackers-owner+archive@lists.postgresql.org>)
	id 1hqfUd-0003pV-Av
	for pgadmin-hackers@arkaria.postgresql.org; Thu, 25 Jul 2019 15:17:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgadmin-hackers-owner+archive@lists.postgresql.org>)
	id 1hqfUc-0007PT-6c
	for pgadmin-hackers@arkaria.postgresql.org; Thu, 25 Jul 2019 15:17:18 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <dpage@pgadmin.org>)
	id 1hqfUb-0007PM-WD
	for pgadmin-hackers@lists.postgresql.org; Thu, 25 Jul 2019 15:17:18 +0000
Received: from mail-wm1-x344.google.com ([2a00:1450:4864:20::344])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <dpage@pgadmin.org>)
	id 1hqfUZ-0002L6-3c
	for pgadmin-hackers@lists.postgresql.org; Thu, 25 Jul 2019 15:17:17 +0000
Received: by mail-wm1-x344.google.com with SMTP id v19so45120298wmj.5
        for <pgadmin-hackers@lists.postgresql.org>;
 Thu, 25 Jul 2019 08:17:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=pgadmin.org; s=google;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=QzFpL38TZeDzWYaTXU058X5W/O/jZMzKXMudb0Obh7I=;
        b=ZeViDVbCLlbp1D/xPrq9AkcTAV8Iwfe4QKE7mPVhho+0GFCHbYiPCPBfE3OEPtXyd+
         r03XATgDnrB9ZwhZy/n+Oh1i14gCwOhYAjBTVsoIlZN2bxCDY8Z3odFn0K9pf2Qc+fAT
         SSlrBJ/5qO/tz580MhGrMUzVHuvRmdaJt5812YzsBUdnnF7Mit49/tiTvTIOnJwnkJtO
         jT/xqY/ZVfr5TpRK1yWuuiHUSQpCAwTuUzCOUDw7p6iPG8NlXNqeqO9z3Q+6/ZwV3G/l
         cObnpkPdlMmCDZReLAcBaVMW/Lo0GntRvstReNPffNOVGZR+85DH6GDCDkiOvT12g9uO
         Rq+Q==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=QzFpL38TZeDzWYaTXU058X5W/O/jZMzKXMudb0Obh7I=;
        b=FauL/tuCxJ4Odr2mPoYgW/Fp+x1/o7RdUp5XkCc2MHYDIcjQ1+2FDicua9UIJeK92A
         fO3sIpmiRK4DVhrL7elFJco+cWW57CUAnyOhqZJ7dMLiBc3eUKTiHVkyv+3hiQ6Yu2gf
         40xw2czrbG/w6ebOMrt9dN1w2LaWt9uJ9trBtUxHtKxJl80AeQwy9cAgQVV2WOt/atMB
         kF074kzmp7n9VsM5TTGMTiII4QlFJonttteKKxyOnUqIm5QmPKo9CK3AEPYjtNxh1oz2
         aGRILWV6hVLcj3jxdF0FfLPa0F32y3cI0nJd7qyPC3rVJtafyDOcqoeqOzgZydh2MaRH
         ELWQ==
X-Gm-Message-State: APjAAAVrJR4ord1/mcEZpCiSs4ihuLFExcTfT9wVdVa13byKqupCeTrP
	9smoo0sZYo5BnGNYlkUo1mJUZtMbZ/pqMJfhjfvEA0Uwd0A=
X-Google-Smtp-Source: 
 APXvYqyc8j7YnSI/NtGlssM21GmBZfrT94cpNq9Va0NPRftmwZB0fvM7UsYL+n9m0PkGDIg8oK4gJAItDmYXcXsm7Z8=
X-Received: by 2002:a7b:c0c6:: with SMTP id s6mr4590783wmh.115.1564067832544;
 Thu, 25 Jul 2019 08:17:12 -0700 (PDT)
MIME-Version: 1.0
References: <7D9FFCE3-7670-4EDB-89B0-18E2B079E3E3@yesql.se>
In-Reply-To: <7D9FFCE3-7670-4EDB-89B0-18E2B079E3E3@yesql.se>
From: Dave Page <dpage@pgadmin.org>
Date: Thu, 25 Jul 2019 16:17:00 +0100
Message-ID: 
 <CA+OCxoxw7PFnrUsMJe0trL5VjV6B3_w2R3Lt6rRBNtCuTo4V8Q@mail.gmail.com>
Subject: Re: Fix projection of pg_type for Greenplum query
To: Daniel Gustafsson <daniel@yesql.se>
Cc: pgadmin-hackers <pgadmin-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000905c90058e82ebe4"
List-Id: <pgadmin-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgadmin-hackers@lists.postgresql.org>
List-Owner: <mailto:pgadmin-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgadmin-hackers>
Precedence: bulk

--000000000000905c90058e82ebe4
Content-Type: text/plain; charset="UTF-8"

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

--000000000000905c90058e82ebe4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks, patch applied.</div><br><div class=3D"gmail_quote"=
><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jul 23, 2019 at 9:13 AM Dani=
el Gustafsson &lt;<a href=3D"mailto:daniel@yesql.se">daniel@yesql.se</a>&gt=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">The bug=
 in <a href=3D"https://redmine.postgresql.org/issues/4179" rel=3D"noreferre=
r" target=3D"_blank">https://redmine.postgresql.org/issues/4179</a> seems t=
o be due to<br>
pg_type being projected from but not selected, the attached patch adds a FR=
OM<br>
clause entry and also adds projection of typname.=C2=A0 This makes the quer=
y work on<br>
5X_STABLE for me.<br>
<br>
cheers ./daniel<br>
<br>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
 class=3D"gmail_signature">Dave Page<br>Blog: <a href=3D"http://pgsnake.blo=
gspot.com" target=3D"_blank">http://pgsnake.blogspot.com</a><br>Twitter: @p=
gsnake<br><br>EnterpriseDB UK: <a href=3D"http://www.enterprisedb.com" targ=
et=3D"_blank">http://www.enterprisedb.com</a><br>The Enterprise PostgreSQL =
Company<br></div>

--000000000000905c90058e82ebe4--