Doc patch to note which system catalogs have oids

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Doc patch to note which system catalogs have oids
Date: 2012-09-24 01:57:45
Message-ID: 1348451865.32124.1@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

Attachment Content-Type Size
oid_doc.patch text/x-patch 12.5 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Karl O. Pinc 2012-09-24 02:22:05 Add big fat caution to pg_restore docs regards partial db restores
Previous Message Karl O. Pinc 2012-09-24 01:52:07 Re: Suggestion for --truncate-tables to pg_restore