Sequence Roll Over - Mailing list pgsql-general

From Mat
Subject Sequence Roll Over
Date
Msg-id 1057501791.3175.5.camel@Arakis
Whole thread Raw
Responses Re: Sequence Roll Over  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
What happens when a sequence for auto-numbered records gets to its
maximum value and another record is added?

Does using a sequence for this limit the amount of records the table can
hold?

If records are deleted, is there a standard way of renumbering all
records so their ID's are consecutive starting from zero and then
reseting the sequence to the highest ID value?

Thanks,

M


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Tables larger than 1GB
Next
From: Andrew Gould
Date:
Subject: FYI: geometric means in one step without custom functions