BUG #17646: create rule named "_RETURN" will cause pg core

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: liukui(at)kingbase(dot)com(dot)cn
Subject: BUG #17646: create rule named "_RETURN" will cause pg core
Date: 2022-10-17 12:03:15
Message-ID: 17646-70c93cfa40365776@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17646
Logged by: kui liu
Email address: liukui(at)kingbase(dot)com(dot)cn
PostgreSQL version: 15.0
Operating system: linux
Description:

Hi, I encounter an error, it may be a bug, thx.

here is a test case

create table t (id integer);
create view v1 as select * from t;
create or replace rule "_RETURN" as on UPDATE to v1 do instead select * from
t;
select * from v1;

execute up sql, will get this error

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-10-17 14:17:55 Re: BUG #17646: create rule named "_RETURN" will cause pg core
Previous Message hubert depesz lubaczewski 2022-10-17 09:14:32 Re: WAL segments removed from primary despite the fact that logical replication slot needs it.