Reuse serial numbers? - Mailing list pgsql-novice

From A B
Subject Reuse serial numbers?
Date
Msg-id dbbf25900803270236h17eae234x420c9c72756a5090@mail.gmail.com
Whole thread Raw
Responses Re: Reuse serial numbers?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-novice
Hello.
I have a table
create table TBL (a serial, b integer, c integer, unique(b,c));

so I for each combination of b,c get an unique number a.

Now, if the table is filled and I remove some rows, so there is a gap
in the a numbers. Is there a way to reuse the "free" serial numbers?

I don't feel like writing a script to select all numbers and do some
searching for free numbers.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: difference in MVCC in 8.3 vs 8.2
Next
From: "A B"
Date:
Subject: Ignore unique violations?