Re: OID and joins

DaVinci writes:

> Can I use OIDs for joins between tables without losing functionality?

Sure.

> The problems I am afraid of are:
>
>     - pg_dump/psql: Can I recover OIDs from security copies?.

pg_dump -o

>     - Indexes: joins between tables linked with OIDs use indexes from
>       OIDs?, should I have to make that indexes or they are automatic?.

You have to make one.

>     - Any other limitation I don't achieve to view?.

Nope, this is really a relatively standard thing.  The oid column isn't
special as compared to other columns, aside from the fact that it is
automatically created.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/