Hi hackers, I realized a subtle behavior with ALTER INDEX .. RENAME. It seems like a bug to me, please see the steps below.
Test 1: Rename table via RENAME .. INDEX CREATE TABLE test_table (a int); SELECT 'test_table'::regclass::oid; oid ------- 34470 (1 row) -- rename table using ALTER INDEX .. ALTER INDEX test_table RENAME TO test_table_2; -- see that table is rename SELECT 34470::regclass; regclass -------------- test_table_2 (1 row) Test 2: Rename view via RENAME .. INDEX CREATE VIEW test_view AS SELECT * FROM pg_class; SELECT 'test_view'::regclass::oid; oid ------- 34473 (1 row) ALTER INDEX test_view RENAME TO test_view_2; ELECT 34473::regclass; regclass ------------- test_view_2 (1 row) It seems like an oversight in ExecRenameStmt(), and probably applies to sequences, mat. views and foreign tables as well. I can reproduce this on both 13.2 and 14.0. Though haven’t checked earlier versions. Thanks, Onder