BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error.
The Post Office <noreply@postgresql.org>
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: jiye_sw@126.com
Date: 2022-10-11T09:27:38Z
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@126.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.
Commits
-
Yet further fixes for multi-row VALUES lists for updatable views.
- addde9bc6caf 11.18 landed
- abc510fa2a34 12.13 landed
- 23e2a06acf04 10.23 landed
- b8f2687fdc41 16.0 landed
- 3162bd95cad3 14.6 landed
- 21e042b0bd47 13.9 landed
- 07ce6769824c 15.1 landed