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.
+3- Contributor
+53- Celebrity
it looks possible, before writing/truncating you could do something like the following
+35- Celebrity
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...
+3- Contributor
it looks possible, before writing/truncating you could do something like the following
Interesting option. I'll look in to that. Thanks.
+3- Contributor
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"...
+3- Contributor
it looks possible, before writing/truncating you could do something like the following
Worked perfectly.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.