RE: OID decreasing? - Mailing list pgsql-general

From Andrew Snow
Subject RE: OID decreasing?
Date
Msg-id NHEALMDKDACEIPBNOOOCOEFICKAA.als@fl.net.au
Whole thread Raw
In response to Re: OID decreasing?  (Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>)
List pgsql-general
> Louis-David Mitterrand wrote:
> >
> > Hello,
> >
> > In this table one can see that OID 178502 was created after OID 178593.
> > Is this normal behaviour? I thought that OID sequences kept going up.
> >
> >   oid   |   login   | price |        created
> > --------+-----------+-------+------------------------
> >  178383 | vindex    | 32500 | 2000-08-14 16:21:04+02
> >  178384 | cunctator | 33000 | 2000-08-17 09:03:17+02
> >  178432 | papy      | 33500 | 2000-08-17 09:15:15+02
> >  178465 | vindex    | 34000 | 2000-08-17 09:15:59+02
> >  178496 | papy      | 34500 | 2000-08-17 09:21:33+02
> >  178497 | vindex    | 35000 | 2000-08-17 09:21:33+02
> >  178499 | papy      | 65000 | 2000-08-17 12:27:09+02
> >  178501 | vindex    | 75000 | 2000-08-17 12:27:09+02
> >  178502 | papy      | 77500 | 2000-08-17 12:27:09+02
> >  178528 | papy      | 35500 | 2000-08-17 12:26:02+02
> >  178529 | vindex    | 36000 | 2000-08-17 12:26:02+02
> >  178561 | papy      | 55000 | 2000-08-17 12:26:25+02
> >  178562 | vindex    | 57500 | 2000-08-17 12:26:25+02
> >  178592 | papy      | 60000 | 2000-08-17 12:26:52+02
> >  178593 | vindex    | 62500 | 2000-08-17 12:26:52+02

Perhaps the system clock was adjusted during the inserts ?


Andrew.



pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: From MSSQL to Postgres
Next
From: Choosna Makarasara
Date:
Subject: create index with user-defined function