Doc patch to note which system catalogs have oids - Mailing list pgsql-hackers

From Karl O. Pinc
Subject Doc patch to note which system catalogs have oids
Date
Msg-id 1348451865.32124.1@mofo
Whole thread Raw
Responses Re: Doc patch to note which system catalogs have oids
Re: Doc patch to note which system catalogs have oids
List pgsql-hackers
Hi,

The attached patch documents the oid column of those
system catalogs having an oid.

Distinguish system catalogs with an oid from those without
and make the primary key clear to the newbie.

Found catalogs with an oid by querying a 9.2 installation:

select pg_class.relkind, pg_class.relname
  from pg_class, pg_attribute
  where pg_attribute.attrelid = pg_class.oid
        and pg_attribute.attname = 'oid'
        and pg_class.relname like 'pg_%'
        and (pg_class.relkind = 'r'    -- table
             or pg_class.relkind = 'v') -- view
  order by pg_class.relkind, pg_class.relname;


Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein


Attachment

pgsql-hackers by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Suggestion for --truncate-tables to pg_restore
Next
From: "Karl O. Pinc"
Date:
Subject: Add big fat caution to pg_restore docs regards partial db restores