| From: | Louis-David Mitterrand <cunctator(at)apartia(dot)ch> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | OID decreasing? |
| Date: | 2000-08-17 10:33:57 |
| Message-ID: | 20000817123357.A3008@styx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
--
Louis-David Mitterrand - ldm(at)apartia(dot)org - http://www.apartia.org
Linux: The Ultimate NT Service Pack
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Welche | 2000-08-17 10:46:56 | Re: Regression Tests |
| Previous Message | Daniel Sjölie | 2000-08-17 09:31:46 | Re: Modifying triggers in database in use... |