Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: sequence increment jumps?
- From: Douglas McNaught <doug(at)mcnaught(dot)org>
- To: "John Smith" <jayzee(dot)smith(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: sequence increment jumps?
- Date: Thu, 25 Jan 2007 12:53:57 -0500
- Message-id: <873b5zgfgq(dot)fsf(at)suzuka(dot)mcnaught(dot)org>
"John Smith" <jayzee(dot)smith(at)gmail(dot)com> writes:
> i had insert errors yesterday ("ERROR: invalid input syntax for
> integer" "ERROR: column 'columnname' is of type date but expression is
> of type integer") but they didn't cause any increment jumps. and when
> i insert a record now the sequence increments just fine.
>
> bug or nature of the beast? how to reset? btw using 8.1, got no other
> sessions, no record deletes, no triggers, no rules.
Nature of the beast. Sequence increments aren't rolled back on
transaction abort (for performance and concurrency reasons), so you
should expect gaps.
-Doug
- Follow-Ups:
- Re: sequence increment jumps?
- From: Benjamin Smith
- Re: sequence increment jumps?
- References:
- sequence increment jumps?
- From: John Smith
- sequence increment jumps?
- Prev by Date: Re: column limit
- Next by Date: Re: sequence increment jumps?
- Previous by thread: sequence increment jumps?
- Next by thread: Re: sequence increment jumps?
- Indexes: