PostgreSQL renaming table sequences and primary key

Question

Is it necessary or important to rename table sequences and primary keys when we rename a table in PostgreSQL? Does it affect something?

Tae · Accepted Answer · 2017-10-27 14:31:59Z

1

Technically your database will keep working as always without the rename so I would say it depends. If your primary key has a generic name like id obviously it is still valid regardless of the new table name. If the name is in the form old_table_name_id or something like that then you have semantic inconsistency. In larger projects this can be confusing for humans. Good names are important just like they are in code so I would rename in this case. Same goes for sequences.

answered Oct 27, 2017 at 14:31

Tae

1,6956 gold badges25 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Laurenz Albe · Accepted Answer · 2017-10-27 14:28:32Z

1

No, unless you want to keep the names in sync to avoid confusing people.

The identity of an object is its Oid.

answered Oct 27, 2017 at 14:28

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Collectives™ on Stack Overflow

PostgreSQL renaming table sequences and primary key

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related