pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Hans Buschmann <buschmann@nidsa.net>
To: David Rowley <dgrowleyml@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: AW: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1
Date: Mon, 24 May 2021 08:52:43 +0000
Message-ID: <1621846369482.30164@nidsa.net> (raw)
In-Reply-To: <CAApHDvrTaSE2c1y0C2wmxhFCUK2wu6LXB9prW4s=M0syDGpqQw@mail.gmail.com>
References: <17030-5844aecae42fe223@postgresql.org>
	<283092.1621717755@sss.pgh.pa.us>
	<CAApHDvoPLEivigj9mFGJsodP6jSxgoX6+bzinX8rSGRw_tv5Rw@mail.gmail.com>
	<CAApHDvps2VmHUve67qtg9F9nepbgGnybnSbvopRtp8crngc2cg@mail.gmail.com>
	<CAApHDvrTaSE2c1y0C2wmxhFCUK2wu6LXB9prW4s=M0syDGpqQw@mail.gmail.com>

>Hans, I see you're on Windows, but wondering if you have a build
>environment around to test to see if this patch fixes the error for
>your case?

Thanks David for investigating.

I managed to manually patch setrefs.c according to your patchset on a Linux test installation.

The query/explain query (without the unneeded XML-stuff) runs fine now, no more error!

I will try to reactivate my Windows development environment, but the error seems not to be related to operating system version.

Many thanks for your quick reaction!

Hans Buschmann






Message-ID: <1621846369482.30164@nidsa.net>
Permalink:  ../1621846369482.30164@nidsa.net/
Also on:    postgresql.org/message-id/1621846369482.30164@nidsa.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: buschmann@nidsa.net, dgrowleyml@gmail.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
  Subject: Re: AW: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1
  In-Reply-To: <1621846369482.30164@nidsa.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox