Re: Serial

In article <01bd327d$5a33ffe0$84f7f5c8@compaq-4126>, "'rico Ver'ssimo da Silva" <erico@nvc.com.br> wrote: > > Does anybody know how to initialize a serial column? Without dropping the > table, I mean... The problem is that I need to delete all rows in a given > table but my primary key (a serial column, that's pretty obvious by now) > never stops growing! > -- > 'rico Ver'ssimo da Silva > <erico@nvc.com.br> > You could try after deleting: insert into your_table (your_serial_column) values(2147483647) ;Then the next serial number generating will be 1. Bye, Octav mailto:com@netinfo.moldova.net -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading