Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: table oids ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 3145 of 3255
Post > Topic >>

Re: table oids and comments

by scrawford@[EMAIL PROTECTED] (Steve Crawford) Jun 23, 2008 at 09:42 AM

Mija Lee wrote:
>
> I think I'm a little confused about the something in the do***entation:
>
> - 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


-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 2 Posts in Topic:
table oids and comments
mija@[EMAIL PROTECTED] (  2008-06-20 16:20:12 
Re: table oids and comments
scrawford@[EMAIL PROTECTE  2008-06-23 09:42:22 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 6:31:06 CDT 2008.