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/

On Wed, Oct 18, 2000 at 06:18:07PM +0200, Peter Eisentraut wrote:

- 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.

...and isn't preserved in backups by default, causes problems while
seleting from one table into another for purposes of removing a column,
and isn't preserved during cluster generation...

...oh yeah, and it isn't standard, so it'l make it hard to migrate to a
different database system should you need to do that for some reason...

--
Adam Haberlach | ASCII /~\
adam@newsnipple.com | Ribbon \ / Against
http://www.newsnipple.com | Campaign X HTML
'88 EX500 | / \ E-mail