Re: general question on OIDs

Tom Lane wrote:
>
> Oliver Vecernik <vecernik(at)aon(dot)at> writes:
> > Using of OIDs as foreign keys is recommended in the docs.
>
> Er ... where? It shouldn't be.

Sorry, it was not in the official docs, but in Bruce's book in the
chapter about OIDs:

| Object identification numbers can be used as primary and foreign key
values in | joins. Since every row has a unique object ID, a separate
column is not needed to | hold the row's unique number.
|
| For example, in Chapter we used a column called customer.customer_id.
This
| column held the customer number and uniquely identified each row.
Alternatively, | we could have used the row's object identification
number as the unique number
| for each row, eliminating the need to create the | | column
customer.customer_id. | In that case, customer.oid would be the unique
customer number.

>
> [...]
>
> This is why it shouldn't be. Reloading a pg_dump-with-OIDs will
> probably yield a conflict-free database, but it's not certain;
> and it is certain that you'll waste lots of OIDs that way. Much
> better to use serial columns for foreign keys.
>
> regards, tom lane

Everthing is clear now. I won't use OIDs for foreign keys.

Regards,
Oliver