Home > mailing lists

sequence advances on failed insert - Mailing list pgsql-general

From	Matthew Terenzio
Subject	sequence advances on failed insert
Date	April 8, 2005 04:00:22
Msg-id	57436e812f994006f1111388d6069618@jobsforge.com Whole thread Raw
Responses	Re: sequence advances on failed insert (David Fetter <david@fetter.org>)
List	pgsql-general

I'm noticing that a sequence is advancing even if the insertion fails.
Is this weird or expected?

Matt Terenzio

From: "Steve - DND"
Date: 08 April 2005, 01:24:21
Subject: Re: Iterate OLD/NEW columns in a trigger?

From: David Fetter
Date: 08 April 2005, 04:16:55
Subject: Re: sequence advances on failed insert