id increase when savePolicy about gorm-adapter HOT 6 CLOSED

@tangyang9464 @JalinWang @imp2002

from gorm-adapter.

@wuzhican can you make a PR to fix it?

from gorm-adapter.

According to my test, adding Restart Identity after the truncate table in PostgreSQL can reset the sequence.
However, other databases may not support the Restart Identity syntax and the Restart Identity does not take effect for the sequences in the table created manually by the user. More tests are needed before repairing.
Another way to fix is to modify truncate to delete, which will reset the sequence, but this will be slower than truncate.
Which repair method are you more inclined to?

from gorm-adapter.

@wuzhican delete is good

from gorm-adapter.

please check my PR

from gorm-adapter.

After my retest, truncate resets the id in mysql and mssql. Postgres also resets the ID when it adds the restart identity. However, delete does not reset the ID for all three databases. As for the other databases, I did not test them.

from gorm-adapter.