RE: OID decreasing?

From: "Andrew Snow" <als(at)fl(dot)net(dot)au>
To: "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: OID decreasing?
Date: 2000-08-18 00:08:51
Message-ID: NHEALMDKDACEIPBNOOOCOEFICKAA.als@fl.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Choosna Makarasara 2000-08-18 01:40:48 create index with user-defined function
Previous Message Chris Bitmead 2000-08-17 23:54:53 Re: From MSSQL to Postgres