| From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: serial grows on failed requests |
| Date: | 2007-08-17 11:03:11 |
| Message-ID: | 20070817110311.GA15891@KanotixBox |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
rihad <rihad(at)mail(dot)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°
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phoenix Kiula | 2007-08-17 11:49:08 | Some frustrations with admin tasks on PGSQL database |
| Previous Message | rihad | 2007-08-17 10:51:42 | serial grows on failed requests |