Re: Re: PostgreSQL General Digest V1 #266

Поиск
Список
Период
Сортировка
От Richard Harvey Chapman
Тема Re: Re: PostgreSQL General Digest V1 #266
Дата
Msg-id Pine.LNX.4.10.10006271858340.14843-100000@smile.3gfp.com
обсуждение исходный текст
Ответ на Re: PostgreSQL General Digest V1 #266  (<felix@crowfix.com>)
Список pgsql-general
On Fri, 23 Jun 2000 felix@crowfix.com wrote:

> Ryan Kirkpatrick <pgsql@rkirkpat.net> writes:
>
> > number was next. But if it had holes in the sequence, then I would end up
> > wasting the sequential labels I had already printed. :(
>
> The only time you get a gap is when you abort a transaction or delete
> a record later.  Your preprinted lables should be fine.  And when you
> later get rid of some old equipment, you don't want to reuse the lable
> and number, do you?  Sounds to me like sequences are exactly what you
> need.

But he doesn't want to waste his labels...

R.



В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Harvey Chapman
Дата:
Сообщение: Re: Insert into a table with only a SERIAL
Следующее
От: Richard Harvey Chapman
Дата:
Сообщение: Inserting into views