Re: Re: PostgreSQL General Digest V1 #266

From: Richard Harvey Chapman <hchapman(at)3gfp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: PostgreSQL General Digest V1 #266
Date: 2000-06-28 01:59:18
Message-ID: Pine.LNX.4.10.10006271858340.14843-100000@smile.3gfp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 23 Jun 2000 felix(at)crowfix(dot)com wrote:

> Ryan Kirkpatrick <pgsql(at)rkirkpat(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Harvey Chapman 2000-06-28 03:00:55 Inserting into views
Previous Message Richard Harvey Chapman 2000-06-28 01:56:01 Re: Insert into a table with only a SERIAL