From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org, alvherre(at)commandprompt(dot)com, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [HACKERS] DOC: catalog.sgml |
Date: | 2006-10-04 17:57:16 |
Message-ID: | 4523F5FC.6010407@sun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> writes:
>> There is new version of catalogs overview patch. This version add only
>> one column into overview table which contains Oid/Filename for each
>> catalog table. Oid information is important if someone need make
>> relation with filename on disk and related catalog table.
>
> I still say this is just confusing clutter. The proposed patch even
> goes so far as to give the OID pride of place as the most important
> item you could possibly want to know about a catalog, which is surely
> silly.
You have right that OID is not important information in many cases, but
how I said It is useful when you want know relation between filename and
catalog table.
> People who actually want to know this information can look into the
> pg_class catalog, which has the advantages of being complete (eg, it
> covers indexes too), guaranteed up-to-date, and easily program-readable.
> I really do not see the value of putting it in the sgml docs.
You can look into pg_class catalog only if database is running. If you
have some data corruption problem, OID should help during recovery. But
you have right, that pg_class have complex information and who want to
"play" with datafiles, he must know more than OID.
OK, thanks for response, forget to this patch
Zdenek
From | Date | Subject | |
---|---|---|---|
Next Message | Graham Davis | 2006-10-04 18:03:16 | Re: formatting intervals with to_char |
Previous Message | Tom Lane | 2006-10-04 17:29:32 | Re: Digging gram.y |
From | Date | Subject | |
---|---|---|---|
Next Message | Zdenek Kotala | 2006-10-04 18:21:50 | Updated version of FAQ_Solaris |
Previous Message | Tom Lane | 2006-10-04 17:11:36 | Re: [PATCHES] qsort_arg needed for msvc build |