Re: [GENERAL] row oids as "foreign keys" in other tables ?

[Vadim Mikheev]

Matt McClure wrote:
> 
> You say that vacuum "re-writes" the database.  Does it alter row oids???
                                                 ^^^^^^^^^^^^^^^^^^^^^^
No.

> If so, my scheme completely corrupts my database whenever I do a vacuum,
> since in concert and song the row oids would change, but my inserted
> values would remain the same in concert_song, right?
> 
> If vacuum does not alter row oids, then I have another question.  How does
> postgres re-use oids?  I've seen the numbers grow and grow, but despite
  ^^^^^^^^^^^^^^^^^^^^
It doesn't.

> deletes, etc, I have never seen a lower oid get re-used.  How does this
> work?

Vadim