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
