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'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.
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 |