Re: OID and joins - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: OID and joins
Date
Msg-id Pine.LNX.4.21.0010181815580.3228-100000@peter.localdomain
Whole thread Raw
In response to OID and joins  (DaVinci <bombadil@wanadoo.es>)
Responses Re: OID and joins
List pgsql-general
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/


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: too many clients?
Next
From: Jack V Chung
Date:
Subject: A couple of pgsql questions