Request a Demo
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 [email protected]
Whole thread Raw
In response to Re: Best approach for a "gap-less" sequence  (Thomas Kellerer <[email protected]>)
List pgsql-general
Tree view 
Thomas Kellerer <[email protected]> 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      <[email protected]>

pgsql-general by date:

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