Re: sequence problem

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: gabi munteanu <gmunteanu(at)hotmail(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: sequence problem
Date: 2001-05-21 20:24:19
Message-ID: Pine.LNX.4.30.0105212222370.757-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

gabi munteanu writes:

> if I remove a record my ids should always be like this:
>
> 1,2,3,4... and not 1,2,4,5,9,...

Sequences don't make a guarantee that the generated numbers are without
"holes". Implementing that is rather complex.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Boettcher 2001-05-21 20:28:40 how to set ownership of tables?
Previous Message gabi munteanu 2001-05-21 19:33:27 sequence problem