Re: table oids and comments

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: table oids and comments
Дата
Msg-id 485FD26E.7040505@pinpointresearch.com
обсуждение исходный текст
Ответ на table oids and comments  (Mija Lee <mija@scharp.org>)
Список pgsql-novice
Mija Lee wrote:
>
> I think I'm a little confused about the something in the documentation:
>
> - I think table oids have been deprecated
> (http://www.postgresql.org/docs/8.2/interactive/runtime-config-compatible.html)
>
Use of OIDs in *user* tables is deprecated. OIDs *are* used by the
*system* tables.
> - It looks like the only way to retrieve the comments associated with
> a table is to use the function obj_descritption(object_oid,
> catalog_name).
> (http://www.postgresql.org/docs/8.2/interactive/functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE)
>
>
These are system tables. You can leave OIDs set to off for user tables
and still have comments.

Cheers,
Steve


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

Предыдущее
От: "Josh Tolley"
Дата:
Сообщение: Re: Server Programming Interface - spi.exec() overheds issue
Следующее
От: Eric Jarvies
Дата:
Сообщение: editing pg_hba.conf