Re: BUG #17646: create rule named "_RETURN" will cause pg core - Mailing list pgsql-bugs

From Ilya Anfimov
Subject Re: BUG #17646: create rule named "_RETURN" will cause pg core
Date
Msg-id 20221017143838.GB3864491@azor.tzirechnoy.ru
Whole thread Raw
In response to BUG #17646: create rule named "_RETURN" will cause pg core  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Mon, Oct 17, 2022 at 12:03:15PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      17646
> Logged by:          kui liu
> Email address:      liukui@kingbase.com.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.
> !?>

btw, I'm confirming the bug for postgres from at least 8.4 to 14.

Version 11 and less instead of segfault prints someting like:

ilan=*# select * from v1;
ERROR:  could not open file "base/24576/57373": No such file or directory

> 




pgsql-bugs by date:

Previous
From: Ilya Anfimov
Date:
Subject: Re: BUG #17646: create rule named "_RETURN" will cause pg core
Next
From: Tom Lane
Date:
Subject: Re: BUG #17646: create rule named "_RETURN" will cause pg core