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
|
Список | 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 по дате отправления: