Brian McKiernan wrote: > My Issue: > My primary keys in a certain table are not contiguous.
If you have a need to have values that are contiguous, you need to ask yourself why and then see what mechanism provides the semantics you need. An easy way is to lock the table containing the column, for example, which of course means only one transaction can do it at a time. For many use cases this is good enough. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
