BUG #16856: Crash when add "_RETURN" rule on child table

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: todoubaba(at)gmail(dot)com
Subject: BUG #16856: Crash when add "_RETURN" rule on child table
Date: 2021-02-06 07:46:14
Message-ID: 16856-0363e05c6e1612fd@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: 16856
Logged by: Yang Lin
Email address: todoubaba(at)gmail(dot)com
PostgreSQL version: 12.5
Operating system: ubuntu 20.04
Description:

create table parent(a text);
create table child() inherits (parent);
create or replace rule "_RETURN" as
on select
to child
do instead
select *
from (values('x')) as t(a);

select * from parent;

The psql crash and report:
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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2021-02-06 12:50:24 Re: BUG #16856: Crash when add "_RETURN" rule on child table
Previous Message Michael Paquier 2021-02-06 01:18:31 Re: BUG #16854: initdb fails on ReFS and FAT32 file systems