RE: [SQL] reinitialise serial counter

2000-11-07 Thread Edmar Wiggers
> after inserting values and doing delete from test if I try to insert > values again, the id starts from where it left off previously. How can I > get the serial counter to restart from 1 ? is it anything to do with > setval(). How to use the setval? The serial value is implemented using a seque

[SQL] reinitialise serial counter

2000-11-07 Thread Indraneel Majumdar
Hi, I have a table create table test (id serial, name text); after inserting values and doing delete from test if I try to insert values again, the id starts from where it left off previously. How can I get the serial counter to restart from 1 ? is it anything to do with setval(). How to use th