Postgres Pro
Downloads
Home   >   mailing lists

Re: Best approach for a "gap-less" sequence - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Best approach for a "gap-less" sequence
Date
Msg-id 874pwiawj8.fsf@gmail.com
Whole thread Raw
In response to Re: Best approach for a "gap-less" sequence  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
Thomas Kellerer <spam_eater@gmx.net> writes:

> What do you do if a document gets deleted? Renumber the "following" documents
> so that no gaps are present in the already used ids?

There's no deletion possibility.  A RULE sets a column named "active" to
"False" instead (I can set it manually or let the RULE do that for me...).

--
Jorge Godoy      <jgodoy@gmail.com>

pgsql-general by date:

Previous
From: "Sandeep Kumar Jakkaraju"
Date:
Subject: Re: Connection Object
Next
From: RPK
Date:
Subject: Automatic Backup Script