Re: problem with serial

From: Yvon Thoraval <yvon(dot)thoraval(at)gmail(dot)com>
To: Chris Angelico <rosuav(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with serial
Date: 2012-04-19 15:05:41
Message-ID: CAG6bkBxhNCW2oBfAo+aVfzbTQrB=5fuGf=8Uf7S-h1N_LvANFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2012/4/19 Chris Angelico <rosuav(at)gmail(dot)com>

>
> As a side point, I would recommend against doing this. Once you've
> "used" a rowid, it's not worth reusing it. You'll save yourself some
> headaches down the track if you simply ignore those odd gaps (ditto
> the gaps that result from rolled-back transactions) and just DELETE
> the rows you're throwing out without bothering to setval the sequence
> back.
>

Yes, for sure, however, i did this kind of workaround, because one time
I've seen a rowid of 8, after an insertion even if the max(rowid) was of 42.

--
Yvon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-04-19 15:11:30 Re: problem with serial
Previous Message Chris Angelico 2012-04-19 15:01:43 Re: problem with serial