Re: serial column
От | Bob Pawley |
---|---|
Тема | Re: serial column |
Дата | |
Msg-id | 006e01c6e023$54a674b0$8e904618@owner обсуждение исходный текст |
Ответ на | serial column (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: serial column
|
Список | pgsql-general |
It's the behavior I expect - but the gaps aren't acceptable. Bob ----- Original Message ----- From: "Gevik Babakhani" <pgdev@xs4all.nl> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "Postgresql" <pgsql-general@postgresql.org> Sent: Sunday, September 24, 2006 2:42 PM Subject: Re: [GENERAL] serial column > 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" <pgdev@xs4all.nl> >> To: "Bob Pawley" <rjpawley@shaw.ca> >> 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 >
В списке pgsql-general по дате отправления: