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

From Tom Lane
Subject Re: BUG #17646: create rule named "_RETURN" will cause pg core
Date
Msg-id 2164336.1666016275@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17646: create rule named "_RETURN" will cause pg core  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17646: create rule named "_RETURN" will cause pg core
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> 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;

Meh.  We should be preventing you from doing that.

(Although the core dump is also not great --- something should've noticed
the bogosity of the plan earlier than this.)

            regards, tom lane



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17646: create rule named "_RETURN" will cause pg core
Next
From: PG Bug reporting form
Date:
Subject: BUG #17647: 12.12 package has difference on ubuntu 18.04