The SERIAL is always sequential. SERIAL internally creates a SEQUENCE and *binds* it to your table. even if you delete a record and insert a new one , the sequence will continue to increment. however there will be gaps between the values.
Isn't this the behavior you expect? On Sun, 2006-09-24 at 14:19 -0700, Bob Pawley wrote: > Yes > > But the only way of insuring that the serial starts at 1 and is sequential > is to recreate the table. > > I've tried creating and dropping the table but this generates other issues > which I haven't been able to resolve. > > Bob > > ----- Original Message ----- > From: "Gevik Babakhani" <[EMAIL PROTECTED]> > To: "Bob Pawley" <[EMAIL PROTECTED]> > Cc: "Postgresql" <pgsql-general@postgresql.org> > Sent: Sunday, September 24, 2006 2:00 PM > Subject: Re: [GENERAL] serial column > > > > On Sun, 2006-09-24 at 13:50 -0700, Bob Pawley wrote: > >> I need to develop a serial column that always starts at 1 and is > >> sequential even after deletes. > >> > >> Any ideas??? > >> > > > > Did you try the: > > > > create table tbl > > ( > > id SERIAL > > ); > > > > or even with primary key... > > > > create table tbl > > ( > > id SERIAL primary key > > ); > > > > > > -- > > Regards, > > Gevik Babakhani > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
