Re: [SQL] vacuum and serial primary keys

2003-02-01 Thread D'Arcy J.M. Cain
On Saturday 01 February 2003 07:45, Carmen Marincu wrote: > I am using Postgresql 7.1.3 and I have deleted 3000 rows from a table > (with DELETE). > Than I used vacuum to actually delete the rows markes as deleted > by the DELETE command.. > The trouble is that the "counter" for the serial primary

[SQL] vacuum and serial primary keys

2003-02-01 Thread Carmen Marincu
Hello - I am using Postgresql 7.1.3 and I have deleted 3000 rows from a table (with DELETE). Than I used vacuum to actually delete the rows markes as deleted by the DELETE command.. The trouble is that the "counter" for the serial primary key (ID field) wasn't reset. So now althought I have only