That's not a bug it's normal behaviour. Suvarna wrote:
we are using postgresql 7.3.2 version. We are facing a problem in nextval of sequence. The problem is as follows, 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 server the nextval of sequence doest match with the last number.
---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq