lizou
Contributor III

yes, by default option allow duplicated values per design.

I will avoid this option and use only use GENERATED ALWAYS AS IDENTITY 

Using BY DEFAULT option is worse than not using it at all

in BY Default option,

If I forget to set starting value, the ID will be generated from

a lower value and will grow and overlap existing values.👻