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

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Matt McClure <matthew(dot)mcclure(at)yale(dot)edu>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] row oids as "foreign keys" in other tables ?
Date: 1998-07-29 01:20:29
Message-ID: 35BE78DD.B0C945C2@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1998-07-29 05:01:05 Re: [GENERAL] Postgres vs commercial products
Previous Message Andrew Gibson 1998-07-28 23:58:20 Mac Connectivity