Greetings.
I am a beginner in the database and wanted to know the correct way to remove an item from the table and update the identification number of the others. This is the typical rookie problem, which removes the item and unconfigures the entire table because the IDs jump from 1, 2, 3 to 5, because row 4 has been deleted.
Note: my application is C # and I use Npgsql to connect to PostgreSQL.