Re: ERROR: permission info at index 1 .... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ERROR: permission info at index 1 ....
Date
Msg-id 1263294.1676308917@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: permission info at index 1 ....  (tender wang <tndrwang@gmail.com>)
Responses Re: ERROR: permission info at index 1 ....
List 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



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: proposal: psql: psql variable BACKEND_PID
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: psql: psql variable BACKEND_PID