Re: best way to reference tables

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: best way to reference tables
Дата
Msg-id 20050809202415.GF21039@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: best way to reference tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: best way to reference tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tue, Aug 09, 2005 at 04:01:33PM -0400, Tom Lane wrote:
> "TJ O'Donnell" <tjo@acm.org> writes:
> > I guess what I'm asking is: Is there a better way to keep track of a
> > table once it's registered in my master table than just to put its
> > name in my master table?  Some system oid type thing that stays fixed
> > in spite of renames or other tables mods?
>
> Yeah, you can store the pg_class OID of the table, instead of (or in
> addition to) its name.  This is exactly what the system itself considers
> to be the "identity" of the table.

Maybe it is possible to use a column of type regclass to store it.  Not
sure exactly what advantage that would give, but it's an idea.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)

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

Предыдущее
От: Richard_D_Levine@raytheon.com
Дата:
Сообщение: Re: Testing of MVCC
Следующее
От: "Guy Rouillier"
Дата:
Сообщение: Re: How to write jobs in postgresql