Обсуждение: table oids and comments

Hello:

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)
- 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)


Is this a different oid?

Thanks for the help!
Mija

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)
>
> - 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)
>
> Is this a different oid?



17.12:    The use of OIDs in user tables is considered deprecated

9.19:    System Information Functions


System functions access system tables; they do not access user tables.

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