Re: serial grows on failed requests - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: serial grows on failed requests
Date
Msg-id 20070817110311.GA15891@KanotixBox
Whole thread Raw
In response to serial grows on failed requests  (rihad <rihad@mail.ru>)
List pgsql-general
rihad <rihad@mail.ru> schrieb:

> When I do an insert that fails (like FK inconsistency, illegal value, etc.)
> the users.id grows nonetheless... This is unacceptable for my current

normal behavior.

> needs. Any way to prevent that while still maintaining ease of use? Using
> PostgreSQL 8.2.4

Look at:
http://www.varlena.com/GeneralBits/130.php


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: rihad
Date:
Subject: serial grows on failed requests
Next
From: Kev
Date:
Subject: Re: DML value format