Re: ERROR: permission info at index 1 ....
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: tender wang <tndrwang@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2023-02-13T17:21:57Z
Lists: pgsql-hackers
tender wang <tndrwang@gmail.com> writes: > After a61b1f74823c commit, below query reports error: > create table perm_test1(a int); > create table perm_test2(b int); > select subq.c0 > from (select (select a from perm_test1 order by a limit 1) as c0, b as c1 > from perm_test2 where false order by c0, c1) as subq where false; > ERROR: permission info at index 1 (with relid=16457) does not match > provided RTE (with relid=16460) Yeah, this was also reported by Justin Pryzby [1]. > Below codes can fix this: Right you are. Pushed, thanks! regards, tom lane [1] https://www.postgresql.org/message-id/20230212233711.GA1316%40telsasoft.com
Commits
-
Fix buggy recursion in flatten_rtes_walker().
- c7468c73f7b6 16.0 landed