From the Postgresql Writer, when a table is truncated and then inserted with new data is it possible to reset the Primary Key sequence to '1'? It currently restarts at the last PK value (+1) from previous entry.
- Participant
- 7 replies
+29
- Celebrity
- 1109 replies
-
2 August 2021
it looks possible, before writing/truncating you could do something like the following
+26
- Influencer
- 1643 replies
-
3 August 2021
Could you drop the table instead of truncating? I would think that should reset it to 1. Of course that might come with it's own set of headaches...
- Participant
- 7 replies
-
3 August 2021
it looks possible, before writing/truncating you could do something like the following
Interesting option. I'll look in to that. Thanks.
- Participant
- 7 replies
-
3 August 2021
Could you drop the table instead of truncating? I would think that should reset it to 1. Of course that might come with it's own set of headaches...
I could but there are going to be views associated to it so, as you said, "it's own set of headaches"...
- Participant
- 7 replies
-
3 August 2021
it looks possible, before writing/truncating you could do something like the following
Worked perfectly.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.