> > The best long term solution, IMHO, would be to change postgres so that
> > it has a unique system column for each record, like Oracle does.
Well incidentally, Oracle doesn't really either. If you use rowid for these
things then you're in for some surprises when you make any significant DDL
changes. At the very least it means dumping and reloading the data in a new
database will destroy all your relationships.
But the only reason Oracle even has something like rowid is a quirk of its
implementation. Postgres is implemented differently and in that implementation
there simply is no such identifier available.
--
greg