[EMAIL PROTECTED] wrote: > 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
