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(at)gmx(dot)net>
To: "Kapil Tilwani" <karan_pg_2(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)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(at)gmx(dot)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(at)postgresql(dot)org)
>

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