I want to understand how safe is the rename command:
ALTER INDEX old_name RENAME TO old_name;
The index was created by command(for the foreign key column):
CREATE INDEX old_name ON table_t1 (user_id);
Does it mean simple update in the postgres system tables or do much more operations. I try to find it in the docs but unsuccess.