Serial types
How Can I restart the values of a serial type field...??
I mean, I have a table with id_user defined as serial type, if a delete the
data from this table and insert new data the field id_user will start the
counter from the last record it had saved...
So... I want the new records insert into the table begins again with 1.
I used alter table <table> alter id_user set default 1;
But, only I could insert one record with number 1.
Thanks for your answers.
Sonny
--
Los amigos verdaderos se hieren con verdades,
para no perderse con mentiras
---
SELECT SETVAL('sequence_name', 1, 't');
should do it.
On Fri, 15 Feb 2002, Sonia Sanchez Diaz wrote:
Show quoted text
How Can I restart the values of a serial type field...??
I mean, I have a table with id_user defined as serial type, if a delete the
data from this table and insert new data the field id_user will start the
counter from the last record it had saved...So... I want the new records insert into the table begins again with 1.
I used alter table <table> alter id_user set default 1;
But, only I could insert one record with number 1.
Thanks for your answers.
Sonny
--
Los amigos verdaderos se hieren con verdades,
para no perderse con mentiras
------------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster