Re: [BUGS] BUG #2284: missing sequence number

2006-02-27 Thread Michael Fuhr
On Mon, Feb 27, 2006 at 11:52:19AM +, [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. ht

Re: [BUGS] BUG #2284: missing sequence number

2006-02-27 Thread Alvaro Herrera
[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. -- Al

[BUGS] BUG #2284: missing sequence number

2006-02-27 Thread
The following bug has been logged online: Bug reference: 2284 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: linux Description:missing sequence number Details: if the server shuts down abrupotly because of power failuar or a