Re: Re: PostgreSQL General Digest V1 #266 - Mailing list pgsql-general

From Richard Harvey Chapman
Subject Re: Re: PostgreSQL General Digest V1 #266
Date
Msg-id Pine.LNX.4.10.10006271858340.14843-100000@smile.3gfp.com
Whole thread Raw
In response to Re: PostgreSQL General Digest V1 #266  (<felix@crowfix.com>)
List 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 by date:

Previous
From: Richard Harvey Chapman
Date:
Subject: Re: Insert into a table with only a SERIAL
Next
From: Richard Harvey Chapman
Date:
Subject: Inserting into views