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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: liukui(at)kingbase(dot)com(dot)cn
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17646: create rule named "_RETURN" will cause pg core
Date: 2022-10-17 14:17:55
Message-ID: 2164336.1666016275@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-10-17 14:18:44 BUG #17647: 12.12 package has difference on ubuntu 18.04
Previous Message PG Bug reporting form 2022-10-17 12:03:15 BUG #17646: create rule named "_RETURN" will cause pg core