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