Postgres Pro
Downloads
Home   >   mailing lists

OID - constantly increasing/ what about the gaps? - Mailing list pgsql-novice

From Thomas Weholt
Subject OID - constantly increasing/ what about the gaps?
Date
Msg-id 006001bfe08e$59e941a0$f0d3d9c1@wintendo
Whole thread Raw
List pgsql-novice
Tree view
Hi,
 
A simple, almost stupid, question :
 
Does the OIDs allways, without exception no matter what I do, increase?
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!
 
Thanks anyway.
 
Thomas
 
 

pgsql-novice by date:

Previous
From: Thomas Swan
Date:
Subject: Finding the names of inheriting classes
Next
From: Tom Lane
Date:
Subject: Re: Installation problem(Error: unknown type oidvector)