From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
---|---|
To: | Thomas Weholt <thomas(at)cintra(dot)no> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: OID - constantly increasing/ what about the gaps? |
Date: | 2000-07-03 14:03:06 |
Message-ID: | 39609D1A.296AAA95@cupid.suninternet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thomas Weholt wrote:
>
> Hi,
>
> A simple, almost stupid, question :
>
> Does the OIDs allways, without exception no matter what I do,
> increase?
Maybe, but maybe not. Consider them opaque object with no other
meaning.
> If I insert a lot of records, delete some of them, inserted more the
> OID would be :
>
> ( about ) 18000 + number of inserted + more records
>
> I mean, the gaps from the deleted records won`t be filled? So I can
> use this as a measure for new records for example. I could keep track
> of OIDs when users access a page generated with data from my database,
> when they return I give them all the rows with OIDs higher than the
> one I stored at their last visit.
>
> Do I make sense? Damn, I`m tired!
Maybe you want a sequence or the serial type?
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-07-03 14:48:33 | Re: Installation problem(Error: unknown type oidvector) |
Previous Message | kerryb | 2000-07-03 11:00:48 | Re: Installation error |