Horton

Re: Small query yields "error: no relation entry for relid 11"

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2020-12-05T21:17:06Z
Lists: pgsql-bugs 
Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk> writes:
> This small query results in "error: no relation entry for relid 11" in
> Postgres 12 and 13 (beta) on db-fiddle.com.  It runs fine in Posgres
> 11.

Cute ... fix pushed, thanks for the report!

			regards, tom lane

Commits

  1. Fix missed step in removal of useless RESULT RTEs in the planner.