Re: OID decreasing? - Mailing list pgsql-general

From Louis-David Mitterrand
Subject Re: OID decreasing?
Date
Msg-id 20000818085135.A1401@styx
Whole thread Raw
In response to Re: OID decreasing?  (Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>)
List pgsql-general
On Fri, Aug 18, 2000 at 09:23:43AM +1000, Chris Bitmead wrote:
>
> I'm totally guessing here, but sometimes databases use a scheme where
> each backend process grabs a chunk of oids for its own use to avoid
> process contention on this single resource. Were they created with
> multiple connections?

Right on! There were indeed created through Apache::DBI. Thanks for your
input.

> 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.
--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org

> Any suggestions for setting up WinCVS client + (server) on NT4?
Run away screaming in terror.
                                        --Toby.

pgsql-general by date:

Previous
From: Craig Johannsen
Date:
Subject: Re: Re: [SQL] variables in SQL??
Next
From: "John Clark L. Naldoza"
Date:
Subject: Re: I screwed it up, my installation :(