Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

create table products (product_id int);
insert into products values (1) returning *;

CREATE TABLE

product_id

1

INSERT 0 1

begin;
alter table products rename to t_products;
create view products
  with (check_option=cascaded,
        security_barrier=true,
        security_invoker=true)
  as table t_products; 
comment on view products is 'legacy layout of "t_products"';
comment on column products.product_id is 'legacy name of "t_products"."entity_id"';
alter table t_products rename product_id to entity_id;
commit;

BEGIN

ALTER TABLE

CREATE VIEW

COMMENT

COMMENT

ALTER TABLE

COMMIT

alter table t_products add column new_column text;--legacy view is safe
select * from products;

ALTER TABLE

product_id

1

SELECT 1

insert into products values (2) returning *;

product_id

2

INSERT 0 1

update products set product_id=3 where product_id=2 returning *;

product_id

3

UPDATE 1

delete from products where product_id=3 returning *;

product_id

3

DELETE 1