Re: OIDs

I would like to make it impossible to be traced as to which record came in
first and which next, however, being sequential reveal that...  How should I
ensure this?

Thanx

----- Original Message -----
From: "Peter Eisentraut" <peter_e@gmx.net>
To: "Kapil Tilwani" <karan_pg_2@yahoo.com>
Cc: <pgsql-general@postgresql.org>
Sent: Saturday, June 30, 2001 9:53 PM
Subject: Re: [GENERAL] OIDs


> Kapil Tilwani writes:
>
> > What happens when OIDs overflow?
>
> You might get spurious problems when you are altering your schema (unique
> contraint violations on the system catalogs), but those can be overcome by
> manually advancing the oid past the area used by the system.
>
> > What are XIDs?
>
> transaction ids
>
> > What if they overflow?
>
> Your database system evaporates.  Seriously.
>
> > Secondly, OIDs are always sequential, right?  Cant they be random....
>
> That would be significantly harder to keep track of.
>
> > I wouldnt like to keep a track (or from anyone finding out) which record
came in first...
>
> That wouldn't be very hard to find out without the oids either.
>
> --
> Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com