BUG #17259: RETURN QUERY no longer accepts an UPDATE RETURNING

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17259: RETURN QUERY no longer accepts an UPDATE RETURNING
Дата
Msg-id 17259-fc4d4f2e6924cc42@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17259: RETURN QUERY no longer accepts an UPDATE RETURNING  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17259
Logged by:          Jorge Gualtieri
Email address:      jorge@jrg.com.br
PostgreSQL version: 14.0
Operating system:   Ubuntu 20.04.3 LTS
Description:

In version 14.0 RETURN QUERY with UPDATE RETURNING in a function is
reporting an error and it works in version 13.4.
Test code:
--
create table test (i int primary key, j int);
insert into test values (1,1);


create or replace function f_test() returns setof int 
language plpgsql
as $fn$
begin 
    return query 
    update test
    set j = j+1
    where i = 1 
    returning j;

end;
$fn$;

select * from  f_test();
--
ERROR:  42601: query is not a SELECT
CONTEXT:  query: update test
        set j = j+1
        where i = 1
        returning j
PL/pgSQL function f_test() line 3 at RETURN QUERY
LOCATION:  exec_stmt_return_query, pl_exec.c:3571


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: BUG #17245: Index corruption involving deduplicated entries
Следующее
От: Sandeep Thakkar
Дата:
Сообщение: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data