Re: ERROR: permission info at index 1 ....

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: permission info at index 1 ....
Дата
Msg-id 1263294.1676308917@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ERROR: permission info at index 1 ....  (tender wang <tndrwang@gmail.com>)
Ответы Re: ERROR: permission info at index 1 ....
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: proposal: psql: psql variable BACKEND_PID
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: psql: psql variable BACKEND_PID