| From: | Chris Bitmead <chris(at)tech(dot)com(dot)au> |
|---|---|
| To: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
| Cc: | Frederic De Leersnijder <frederic(dot)de(dot)leersnijder(at)pandora(dot)be>, "pgsql-sql(at)hub(dot)org" <pgsql-sql(at)hub(dot)org> |
| Subject: | Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? |
| Date: | 1999-07-21 09:36:59 |
| Message-ID: | 379594BB.1496E4FB@tech.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Herouth Maoz wrote:
>
> At 19:54 +0300 on 20/07/1999, Frederic De Leersnijder wrote:
>
> > Hi,
> >
> > when I try to insert a record and it curses with fields with a unique
> > key on them my sequence I use for my primary key does increment. How can
> > I prevent this from happening?
>
> You can't. The point of sequences is that they ensure you of unique values,
> but they DO NOT ensure you of gap-free values. This allows sequences to be
> used momentarily, without being locked for the duration of a transaction,
> thus allowing many users to get values with minimal contention.
I missed the original question, but don't you get sequential numbers as
long as cache is 0?
--
Chris Bitmead
mailto:chris(at)tech(dot)com(dot)au
http://www.techphoto.org - Photography News, Stuff that Matters
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herouth Maoz | 1999-07-21 09:45:16 | Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? |
| Previous Message | Herouth Maoz | 1999-07-21 09:15:49 | Re: [SQL] Can I prevent my sequence to increment if an insert is rejected? |