| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Mija Lee <mija(at)scharp(dot)org> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: table oids and comments |
| Date: | 2008-06-23 16:42:22 |
| Message-ID: | 485FD26E.7040505@pinpointresearch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Jarvies | 2008-06-25 01:59:16 | editing pg_hba.conf |
| Previous Message | Josh Tolley | 2008-06-22 15:57:34 | Re: Server Programming Interface - spi.exec() overheds issue |