Re: OID and joins

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: OID and joins
Дата
Msg-id Pine.LNX.4.21.0010181815580.3228-100000@peter.localdomain
обсуждение исходный текст
Ответ на OID and joins  (DaVinci <bombadil@wanadoo.es>)
Ответы Re: OID and joins  (Adam Haberlach <adam@newsnipple.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: too many clients?
Следующее
От: Jack V Chung
Дата:
Сообщение: A couple of pgsql questions