Skip site navigation (1) Skip section navigation (2)

Re: table oids and comments

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: Eric JarviesDate: 2008-06-25 01:59:16
Subject: editing pg_hba.conf
Previous:From: Josh TolleyDate: 2008-06-22 15:57:34
Subject: Re: Server Programming Interface - spi.exec() overheds issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group