Re: OID's

Поиск
Список
Период
Сортировка
От Matt
Тема Re: OID's
Дата
Msg-id 1100611720.4227.49.camel@matt.kynx.org
обсуждение исходный текст
Ответ на Re: OID's  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Ответы Re: OID's  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
Hi,

> > > > OIDS are a system level implementation. They are no longer required
> > > > (you can make tables without OIDS) and they may go away someday.

What about tableoids? Are they from the same generator as row oids (and
hence may suffer wrap-around)? Or are they unique across the db?

I ask because I'm currently using them to join a single table to rows in
arbitrary tables, something like:

+-------------+
| JOINME      |
+-------------+
| foreign_oid |
| foreign_id  |
| ...         |
+-------------+

Where foreign_oid is the tableoid of the table and foreign_id is the
(serial, not oid) id of the row in that table.

I dunno if it's bad design, but it's darn handy.

M




В списке pgsql-general по дате отправления:

Предыдущее
От: "Joolz"
Дата:
Сообщение: XXXXXXXXXXXXXXXXXXXXXXXXX
Следующее
От: "Joolz"
Дата:
Сообщение: CUM ON MY ASSHOLE