suvarnat (AT) cygnus (DOT) stpp.soft.net wrote:
Quote:
if the server shuts down abrupotly because of power failuar or any other
cause then the sequences tend to skip few numbers.
After restarting the postgresql server the nextval of sequence doest match
with the last number. |
This is per design, i.e. not a bug.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster