Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot delete rows from a temporal history table #120

Open
mslowin opened this issue Jun 5, 2023 · 3 comments
Open

Cannot delete rows from a temporal history table #120

mslowin opened this issue Jun 5, 2023 · 3 comments

Comments

@mslowin
Copy link

mslowin commented Jun 5, 2023

I have an SQL database with temporal tables that contain the history of changes. When I try to use ResetAsync(), it throws this error. While debugging, I can see that the respawner.DeleteSql property has all the tables I want to be deleted - both regular tables and temporal tables.
@chris-smith-steris
Copy link

Did you set CheckTemporalTables = true within RespawnerOptions?

@JanEggers
Copy link

just stumbled over this. is there any reason not to make CheckTemporalTables = true the default?

@jepzen
Copy link

jepzen commented Nov 15, 2024

Does not make any difference to me if i set CheckTemporalTables = true or False. Do I need to explicitly tell all table names that ends on History to be excluded ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@jepzen @JanEggers @mslowin @chris-smith-steris