reusing IDs from a table or re factoring the column

See more:

SQL

PostgreSQL

I am having a table which has 4 fields


ID Spathe treeId DateofEmasculation Buttons
1 1 1 mm//dd/yyyy 30
2 1 2 mm//dd/yyyy 18
3 1 3 mm//dd/yyyy 20
4 2 1 mm//dd/yyyy 25
5 3 1 mm//dd/yyyy 18



now if i delete the record with id 4 i get the data for treeId 1

as
ID Spathe treeId DateofEmasculation Buttons
1 1 1 mm//dd/yyyy 30
5 3 1 mm//dd/yyyy 18

and now spathe 2 is missing ....


i can update the spathe column to re sequence in consecutive order but the records which were inserted in first place were already noted down by the user .


so changing the spathe column can cause lot of confusion .


So how can i tackle this issue..