Horton

Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Joseph Krogh <andreas@visena.com>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Andrew Dunstan <andrew@dunslane.net>, torikoshia <torikoshia@oss.nttdata.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2021-09-16T16:57:39Z
Lists: pgsql-hackers 
Andreas Joseph Krogh <andreas@visena.com> writes:
> På torsdag 16. september 2021 kl. 01:40:31, skrev Tom Lane <tgl@sss.pgh.pa.us 
> <mailto:tgl@sss.pgh.pa.us>>: 
> [...]
>  regression=# with recursive cte (x,r) as (
>  select 42 as x, row(i, 2.3) as r from generate_series(1,3) i
>  union all 
>  select x, row((c.r).f1, 4.5) from cte c
>  ) 
>  select * from cte;
>  ERROR: record type has not been registered 

> FWIW; I saw this Open Item was set to fixed, but I'm still getting this error 
> in 388726753b638fb9938883bdd057b2ffe6f950f5 

The open item was not about that parser shortcoming, nor did this patch
claim to fix it.

			regards, tom lane

Commits

  1. Fix EXPLAIN of SEARCH BREADTH FIRST queries some more.

  2. Fix EXPLAIN to handle SEARCH BREADTH FIRST queries.

  3. Message style improvements