BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error.

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: jiye_sw(at)126(dot)com
Subject: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error.
Date: 2022-10-11 09:27:38
Message-ID: 17633-98cc85e1fa91e905@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: 17633
Logged by: leafji&#x27;s git home
Email address: jiye_sw(at)126(dot)com
PostgreSQL version: 14.5
Operating system: Centos
Description:

Just execute as follow sql:

drop view v1;
drop table t1;
drop table t2;
create table t1(i int, j int);
create table t2(a int, b int, c int, d int);
create or replace rule t1_r as on insert to t1 do also insert into t2(c,d)
values (new.i, new.j);
insert into t1 values (1,default);
insert into t1 values (1,default),(2, default);
-- create rule on t1 directly no issue
drop rule t1_r on t1;
create view v1 as select * from t1;
— create rule on view query t1 will trigger this issue
create or replace rule v1_r as on insert to v1 do also insert into t2(c,d)
values (new.i, new.j);
insert into v1 values (1,default);
-- must multi values.
insert into v1 values (1,default),(2, default);
=> it will trigger cache lookup failed for type.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2022-10-11 10:05:09 Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error.
Previous Message Japin Li 2022-10-11 09:12:04 Re: BUG #17632: a potential bug of memory leak