Doc patch to note which system catalogs have oids
Started by Karl O. Pincover 13 years ago12 messages
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
Attachments:
oid_doc.patchtext/x-patch; charset=us-ascii; name=oid_doc.patchDownload
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index f999190..babb11c 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -427,6 +427,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>amname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -683,6 +690,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>amopfamily</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-opfamily"><structname>pg_opfamily</structname></link>.oid</literal></entry>
@@ -819,6 +833,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>amprocfamily</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-opfamily"><structname>pg_opfamily</structname></link>.oid</literal></entry>
@@ -902,6 +923,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>adrelid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
@@ -1257,6 +1285,14 @@
</thead>
<tbody>
+
+ <row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
<row>
<entry><structfield>rolname</structfield></entry>
<entry><type>name</type></entry>
@@ -1462,6 +1498,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>castsource</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
@@ -1577,6 +1620,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>relname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -1984,6 +2034,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>conname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2250,6 +2307,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>collname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2350,6 +2414,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>conname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2443,6 +2514,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>datname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2652,6 +2730,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>defaclrole</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
@@ -3005,6 +3090,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>enumtypid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
@@ -3078,6 +3170,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>extname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3174,6 +3273,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>fdwname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3266,6 +3372,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>srvname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3675,6 +3788,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>lanname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3875,6 +3995,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>lomowner</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
@@ -3927,6 +4054,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>nspname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3995,6 +4129,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>opcmethod</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-am"><structname>pg_am</structname></link>.oid</literal></entry>
@@ -4093,6 +4234,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>oprname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -4243,6 +4391,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>opfmethod</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-am"><structname>pg_am</structname></link>.oid</literal></entry>
@@ -4427,6 +4582,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>proname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -4819,6 +4981,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>rulename</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5488,6 +5657,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>spcname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5556,6 +5732,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>tgrelid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
@@ -5741,6 +5924,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>cfgname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5880,6 +6070,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>dictname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5956,6 +6153,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>prsname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -6046,6 +6250,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>tmplname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -6113,6 +6324,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>typname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -6618,6 +6836,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>umuser</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
@@ -7690,6 +7915,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>rolname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
Re: Doc patch to note which system catalogs have oids
"Karl O. Pinc" <kop@meme.com> writes:
The attached patch documents the oid column of those
system catalogs having an oid.
I think this is fundamentally wrong, or at least misleading, because it
documents OID as if it were an ordinary column. Somebody who did
"select * from pg_class" and didn't see any "oid" in the result would
think the docs were wrong.
It's possible that it's worth expending a boilerplate paragraph in each
of those pages to say "this catalog has OIDs" (or that it doesn't).
But this isn't the way.
regards, tom lane
Re: Doc patch to note which system catalogs have oids
On 09/23/2012 10:14:33 PM, Tom Lane wrote:
"Karl O. Pinc" <kop@meme.com> writes:
The attached patch documents the oid column of those
system catalogs having an oid.I think this is fundamentally wrong, or at least misleading, because
it
documents OID as if it were an ordinary column. Somebody who did
"select * from pg_class" and didn't see any "oid" in the result would
think the docs were wrong.
Ok.
When I went looking at querying the
system catalogs I got confused some time ago because oids were
not listed along with the other columns. (It didn't help that the
catalog I was looking at had another column of type oid.)
It's possible that it's worth expending a boilerplate paragraph in
each
of those pages to say "this catalog has OIDs" (or that it doesn't).
But this isn't the way.
How about modifying the ("printed") table layout as attached?
It begins each ("printed") table documenting each catalog with a
"Has OID column" Yes/No.
Also, I note that pg_constraint and pg_collation are not
collated properly in the docs. (Constraint comes before collation
in the docs, although everything else is sorted by name.)
A second patch (applied on top of the first) fixes this.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
Attachments:
oid_doc_v2.patchtext/x-patch; charset=us-ascii; name=oid_doc_v2.patchDownload
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index f999190..2dfb40f 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -332,6 +332,19 @@
<table>
<title><structname>pg_aggregate</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -415,6 +428,19 @@
<table>
<title><structname>pg_am</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -671,6 +697,19 @@
<table>
<title><structname>pg_amop</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -807,6 +846,19 @@
<table>
<title><structname>pg_amproc</structname> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -890,6 +942,19 @@
<table>
<title><structname>pg_attrdef</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -967,6 +1032,19 @@
<table>
<title><structname>pg_attribute</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1247,6 +1325,19 @@
<table>
<title><structname>pg_authid</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="3">
<thead>
<row>
@@ -1377,6 +1468,19 @@
<table>
<title><structname>pg_auth_members</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1450,6 +1554,19 @@
<table>
<title><structname>pg_cast</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1565,6 +1682,19 @@
<table>
<title><structname>pg_class</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1877,6 +2007,19 @@
<table>
<title><structname>pg_event_trigger</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1972,6 +2115,19 @@
<table>
<title><structname>pg_constraint</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2238,6 +2394,19 @@
<table>
<title><structname>pg_collation</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2338,6 +2507,19 @@
<table>
<title><structname>pg_conversion</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2431,6 +2613,19 @@
<table>
<title><structname>pg_database</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2588,6 +2783,19 @@
<table>
<title><structname>pg_db_role_setting</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2640,6 +2848,19 @@
<table>
<title><structname>pg_default_acl</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2736,6 +2957,19 @@
<table>
<title><structname>pg_depend</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2926,6 +3160,19 @@
<table>
<title><structname>pg_description</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2993,6 +3240,19 @@
<table>
<title><structname>pg_enum</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3066,6 +3326,19 @@
<table>
<title><structname>pg_extension</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3162,6 +3435,19 @@
<table>
<title><structname>pg_foreign_data_wrapper</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3254,6 +3540,19 @@
<table>
<title><structname>pg_foreign_server</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3345,6 +3644,19 @@
<table>
<title><structname>pg_foreign_table</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3400,6 +3712,19 @@
<table>
<title><structname>pg_index</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3600,16 +3925,29 @@
<table>
<title><structname>pg_inherits</> Columns</title>
- <tgroup cols="4">
+ <tgroup cols="1">
<thead>
<row>
- <entry>Name</entry>
- <entry>Type</entry>
- <entry>References</entry>
- <entry>Description</entry>
+ <entry>Has OID column</entry>
</row>
</thead>
-
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
+ <tgroup cols="4">
+ <thead>
+ <row>
+ <entry>Name</entry>
+ <entry>Type</entry>
+ <entry>References</entry>
+ <entry>Description</entry>
+ </row>
+ </thead>
+
<tbody>
<row>
<entry><structfield>inhrelid</structfield></entry>
@@ -3663,6 +4001,19 @@
<table>
<title><structname>pg_language</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3796,6 +4147,19 @@
<table>
<title><structname>pg_largeobject</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3863,6 +4227,19 @@
<table>
<title><structname>pg_largeobject_metadata</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3915,6 +4292,19 @@
<table>
<title><structname>pg_namespace</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3983,6 +4373,19 @@
<table>
<title><structname>pg_opclass</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4081,6 +4484,19 @@
<table>
<title><structname>pg_operator</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4231,6 +4647,19 @@
<table>
<title><structname>pg_opfamily</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4312,6 +4741,19 @@
<table>
<title><structname>pg_pltemplate</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="3">
<thead>
<row>
@@ -4415,6 +4857,19 @@
<table>
<title><structname>pg_proc</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4725,6 +5180,19 @@
<table>
<title><structname>pg_range</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4807,6 +5275,19 @@
<table>
<title><structname>pg_rewrite</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4930,6 +5411,19 @@
<table>
<title><structname>pg_seclabel</structname> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5016,6 +5510,19 @@
<table>
<title><structname>pg_shdepend</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5168,6 +5675,19 @@
<table>
<title><structname>pg_shdescription</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5234,6 +5754,20 @@
<table>
<title><structname>pg_shseclabel</structname> Columns</title>
+
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5338,6 +5872,19 @@
<table>
<title><structname>pg_statistic</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5476,6 +6023,19 @@
<table>
<title><structname>pg_tablespace</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5544,6 +6104,19 @@
<table>
<title><structname>pg_trigger</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5729,6 +6302,19 @@
<table>
<title><structname>pg_ts_config</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5797,6 +6383,19 @@
<table>
<title><structname>pg_ts_config_map</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5868,6 +6467,19 @@
<table>
<title><structname>pg_ts_dict</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5944,6 +6556,19 @@
<table>
<title><structname>pg_ts_parser</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -6034,6 +6659,19 @@
<table>
<title><structname>pg_ts_template</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -6101,6 +6739,19 @@
<table>
<title><structname>pg_type</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -6512,6 +7163,19 @@
<table id="catalog-typcategory-table">
<title><structfield>typcategory</> Codes</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="2">
<thead>
<row>
@@ -6606,6 +7270,19 @@
<table>
<title><structname>pg_user_mapping</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
doc_collation_conversion_order.patchtext/x-patch; charset=us-ascii; name=doc_collation_conversion_order.patchDownload
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 2dfb40f..2b85ba4 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -2087,6 +2087,120 @@
</table>
</sect1>
+ <sect1 id="catalog-pg-collation">
+ <title><structname>pg_collation</structname></title>
+
+ <indexterm zone="catalog-pg-collation">
+ <primary>pg_collation</primary>
+ </indexterm>
+
+ <para>
+ The catalog <structname>pg_collation</structname> describes the
+ available collations, which are essentially mappings from an SQL
+ name to operating system locale categories.
+ See <xref linkend="collation"> for more information.
+ </para>
+
+ <table>
+ <title><structname>pg_collation</> Columns</title>
+
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Has OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
+ <tgroup cols="4">
+ <thead>
+ <row>
+ <entry>Name</entry>
+ <entry>Type</entry>
+ <entry>References</entry>
+ <entry>Description</entry>
+ </row>
+ </thead>
+
+ <tbody>
+ <row>
+ <entry><structfield>collname</structfield></entry>
+ <entry><type>name</type></entry>
+ <entry></entry>
+ <entry>Collation name (unique per namespace and encoding)</entry>
+ </row>
+
+ <row>
+ <entry><structfield>collnamespace</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry><literal><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.oid</literal></entry>
+ <entry>
+ The OID of the namespace that contains this collation
+ </entry>
+ </row>
+
+ <row>
+ <entry><structfield>collowner</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
+ <entry>Owner of the collation</entry>
+ </row>
+
+ <row>
+ <entry><structfield>collencoding</structfield></entry>
+ <entry><type>int4</type></entry>
+ <entry></entry>
+ <entry>Encoding in which the collation is applicable, or -1 if it
+ works for any encoding</entry>
+ </row>
+
+ <row>
+ <entry><structfield>collcollate</structfield></entry>
+ <entry><type>name</type></entry>
+ <entry></entry>
+ <entry><symbol>LC_COLLATE</> for this collation object</entry>
+ </row>
+
+ <row>
+ <entry><structfield>collctype</structfield></entry>
+ <entry><type>name</type></entry>
+ <entry></entry>
+ <entry><symbol>LC_CTYPE</> for this collation object</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
+
+ <para>
+ Note that the unique key on this catalog is (<structfield>collname</>,
+ <structfield>collencoding</>, <structfield>collnamespace</>) not just
+ (<structfield>collname</>, <structfield>collnamespace</>).
+ <productname>PostgreSQL</productname> generally ignores all
+ collations that do not have <structfield>collencoding</> equal to
+ either the current database's encoding or -1, and creation of new entries
+ with the same name as an entry with <structfield>collencoding</> = -1
+ is forbidden. Therefore it is sufficient to use a qualified SQL name
+ (<replaceable>schema</>.<replaceable>name</>) to identify a collation,
+ even though this is not unique according to the catalog definition.
+ The reason for defining the catalog this way is that
+ <application>initdb</> fills it in at cluster initialization time with
+ entries for all locales available on the system, so it must be able to
+ hold entries for all encodings that might ever be used in the cluster.
+ </para>
+
+ <para>
+ In the <literal>template0</> database, it could be useful to create
+ collations whose encoding does not match the database encoding,
+ since they could match the encodings of databases later cloned from
+ <literal>template0</>. This would currently have to be done manually.
+ </para>
+ </sect1>
+
<sect1 id="catalog-pg-constraint">
<title><structname>pg_constraint</structname></title>
@@ -2377,120 +2491,6 @@
</sect1>
- <sect1 id="catalog-pg-collation">
- <title><structname>pg_collation</structname></title>
-
- <indexterm zone="catalog-pg-collation">
- <primary>pg_collation</primary>
- </indexterm>
-
- <para>
- The catalog <structname>pg_collation</structname> describes the
- available collations, which are essentially mappings from an SQL
- name to operating system locale categories.
- See <xref linkend="collation"> for more information.
- </para>
-
- <table>
- <title><structname>pg_collation</> Columns</title>
-
- <tgroup cols="1">
- <thead>
- <row>
- <entry>Has OID column</entry>
- </row>
- </thead>
- <tbody>
- <row>
- <entry>Yes</entry>
- </row>
- </tbody>
- </tgroup>
-
- <tgroup cols="4">
- <thead>
- <row>
- <entry>Name</entry>
- <entry>Type</entry>
- <entry>References</entry>
- <entry>Description</entry>
- </row>
- </thead>
-
- <tbody>
- <row>
- <entry><structfield>collname</structfield></entry>
- <entry><type>name</type></entry>
- <entry></entry>
- <entry>Collation name (unique per namespace and encoding)</entry>
- </row>
-
- <row>
- <entry><structfield>collnamespace</structfield></entry>
- <entry><type>oid</type></entry>
- <entry><literal><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link>.oid</literal></entry>
- <entry>
- The OID of the namespace that contains this collation
- </entry>
- </row>
-
- <row>
- <entry><structfield>collowner</structfield></entry>
- <entry><type>oid</type></entry>
- <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
- <entry>Owner of the collation</entry>
- </row>
-
- <row>
- <entry><structfield>collencoding</structfield></entry>
- <entry><type>int4</type></entry>
- <entry></entry>
- <entry>Encoding in which the collation is applicable, or -1 if it
- works for any encoding</entry>
- </row>
-
- <row>
- <entry><structfield>collcollate</structfield></entry>
- <entry><type>name</type></entry>
- <entry></entry>
- <entry><symbol>LC_COLLATE</> for this collation object</entry>
- </row>
-
- <row>
- <entry><structfield>collctype</structfield></entry>
- <entry><type>name</type></entry>
- <entry></entry>
- <entry><symbol>LC_CTYPE</> for this collation object</entry>
- </row>
- </tbody>
- </tgroup>
- </table>
-
- <para>
- Note that the unique key on this catalog is (<structfield>collname</>,
- <structfield>collencoding</>, <structfield>collnamespace</>) not just
- (<structfield>collname</>, <structfield>collnamespace</>).
- <productname>PostgreSQL</productname> generally ignores all
- collations that do not have <structfield>collencoding</> equal to
- either the current database's encoding or -1, and creation of new entries
- with the same name as an entry with <structfield>collencoding</> = -1
- is forbidden. Therefore it is sufficient to use a qualified SQL name
- (<replaceable>schema</>.<replaceable>name</>) to identify a collation,
- even though this is not unique according to the catalog definition.
- The reason for defining the catalog this way is that
- <application>initdb</> fills it in at cluster initialization time with
- entries for all locales available on the system, so it must be able to
- hold entries for all encodings that might ever be used in the cluster.
- </para>
-
- <para>
- In the <literal>template0</> database, it could be useful to create
- collations whose encoding does not match the database encoding,
- since they could match the encodings of databases later cloned from
- <literal>template0</>. This would currently have to be done manually.
- </para>
- </sect1>
-
<sect1 id="catalog-pg-conversion">
<title><structname>pg_conversion</structname></title>
Re: Doc patch to note which system catalogs have oids
Tom,
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
I think this is fundamentally wrong, or at least misleading, because it
documents OID as if it were an ordinary column. Somebody who did
"select * from pg_class" and didn't see any "oid" in the result would
think the docs were wrong.
Given that it's been quite some time since we defaulted to including
OIDs in tables, and the high level of confusion that individuals trying
to join pg_class and pg_namespace together go through due to select *
not including the oid column, I wonder if perhaps we should consider
changing that. Might be possible to do for just the catalog tables (to
minimize the risk of breaking poorly-written applications), or provide
a GUC to control including the oid column in select *.
It's possible that it's worth expending a boilerplate paragraph in each
of those pages to say "this catalog has OIDs" (or that it doesn't).
But this isn't the way.
I'm afraid I disagree with this. The oid column, in the system
catalog, is user-facing and I like having it included as a column in the
table in the docs, so users know what to use when doing joins.
Including something in the boilerplate about it not being shown by
default (or in the description in the table) might be alright, if we
don't change that.
Thanks,
Stephen
Re: Doc patch to note which system catalogs have oids
On 09/24/2012 09:38:53 AM, Karl O. Pinc wrote:
On 09/23/2012 10:14:33 PM, Tom Lane wrote:
"Karl O. Pinc" <kop@meme.com> writes:
The attached patch documents the oid column of those
system catalogs having an oid.I think this is fundamentally wrong, or at least misleading,
because
it
documents OID as if it were an ordinary column.
How about modifying the ("printed") table layout as attached?
It begins each ("printed") table documenting each catalog with a
"Has OID column" Yes/No.
Changed text from "Has OID column" to "Keyed with an OID column"
since this explains more and there's no worry about horizontal
space.
I like having the documentation of oid be part of the
(printed) table describing the columns, in some way or
another, since that's where the eye is drawn when
looking for column documentation.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
Attachments:
oid_doc_v3.patchtext/x-patch; charset=us-ascii; name=oid_doc_v3.patchDownload
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index f999190..2dfb40f 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -332,6 +332,19 @@
<table>
<title><structname>pg_aggregate</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -415,6 +428,19 @@
<table>
<title><structname>pg_am</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -671,6 +697,19 @@
<table>
<title><structname>pg_amop</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -807,6 +846,19 @@
<table>
<title><structname>pg_amproc</structname> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -890,6 +942,19 @@
<table>
<title><structname>pg_attrdef</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -967,6 +1032,19 @@
<table>
<title><structname>pg_attribute</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1247,6 +1325,19 @@
<table>
<title><structname>pg_authid</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="3">
<thead>
<row>
@@ -1377,6 +1468,19 @@
<table>
<title><structname>pg_auth_members</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1450,6 +1554,19 @@
<table>
<title><structname>pg_cast</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1565,6 +1682,19 @@
<table>
<title><structname>pg_class</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1877,6 +2007,19 @@
<table>
<title><structname>pg_event_trigger</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -1972,6 +2115,19 @@
<table>
<title><structname>pg_constraint</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2238,6 +2394,19 @@
<table>
<title><structname>pg_collation</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2338,6 +2507,19 @@
<table>
<title><structname>pg_conversion</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2431,6 +2613,19 @@
<table>
<title><structname>pg_database</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2588,6 +2783,19 @@
<table>
<title><structname>pg_db_role_setting</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2640,6 +2848,19 @@
<table>
<title><structname>pg_default_acl</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2736,6 +2957,19 @@
<table>
<title><structname>pg_depend</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2926,6 +3160,19 @@
<table>
<title><structname>pg_description</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -2993,6 +3240,19 @@
<table>
<title><structname>pg_enum</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3066,6 +3326,19 @@
<table>
<title><structname>pg_extension</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3162,6 +3435,19 @@
<table>
<title><structname>pg_foreign_data_wrapper</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3254,6 +3540,19 @@
<table>
<title><structname>pg_foreign_server</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3345,6 +3644,19 @@
<table>
<title><structname>pg_foreign_table</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3400,6 +3712,19 @@
<table>
<title><structname>pg_index</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3600,16 +3925,29 @@
<table>
<title><structname>pg_inherits</> Columns</title>
- <tgroup cols="4">
+ <tgroup cols="1">
<thead>
<row>
- <entry>Name</entry>
- <entry>Type</entry>
- <entry>References</entry>
- <entry>Description</entry>
+ <entry>Keyed with an OID column</entry>
</row>
</thead>
-
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
+ <tgroup cols="4">
+ <thead>
+ <row>
+ <entry>Name</entry>
+ <entry>Type</entry>
+ <entry>References</entry>
+ <entry>Description</entry>
+ </row>
+ </thead>
+
<tbody>
<row>
<entry><structfield>inhrelid</structfield></entry>
@@ -3663,6 +4001,19 @@
<table>
<title><structname>pg_language</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3796,6 +4147,19 @@
<table>
<title><structname>pg_largeobject</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3863,6 +4227,19 @@
<table>
<title><structname>pg_largeobject_metadata</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3915,6 +4292,19 @@
<table>
<title><structname>pg_namespace</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -3983,6 +4373,19 @@
<table>
<title><structname>pg_opclass</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4081,6 +4484,19 @@
<table>
<title><structname>pg_operator</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4231,6 +4647,19 @@
<table>
<title><structname>pg_opfamily</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4312,6 +4741,19 @@
<table>
<title><structname>pg_pltemplate</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="3">
<thead>
<row>
@@ -4415,6 +4857,19 @@
<table>
<title><structname>pg_proc</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4725,6 +5180,19 @@
<table>
<title><structname>pg_range</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4807,6 +5275,19 @@
<table>
<title><structname>pg_rewrite</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -4930,6 +5411,19 @@
<table>
<title><structname>pg_seclabel</structname> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5016,6 +5510,19 @@
<table>
<title><structname>pg_shdepend</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5168,6 +5675,19 @@
<table>
<title><structname>pg_shdescription</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5234,6 +5754,20 @@
<table>
<title><structname>pg_shseclabel</structname> Columns</title>
+
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5338,6 +5872,19 @@
<table>
<title><structname>pg_statistic</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5476,6 +6023,19 @@
<table>
<title><structname>pg_tablespace</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5544,6 +6104,19 @@
<table>
<title><structname>pg_trigger</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5729,6 +6302,19 @@
<table>
<title><structname>pg_ts_config</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5797,6 +6383,19 @@
<table>
<title><structname>pg_ts_config_map</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5868,6 +6467,19 @@
<table>
<title><structname>pg_ts_dict</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -5944,6 +6556,19 @@
<table>
<title><structname>pg_ts_parser</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -6034,6 +6659,19 @@
<table>
<title><structname>pg_ts_template</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -6101,6 +6739,19 @@
<table>
<title><structname>pg_type</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
@@ -6512,6 +7163,19 @@
<table id="catalog-typcategory-table">
<title><structfield>typcategory</> Codes</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>No</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="2">
<thead>
<row>
@@ -6606,6 +7270,19 @@
<table>
<title><structname>pg_user_mapping</> Columns</title>
+ <tgroup cols="1">
+ <thead>
+ <row>
+ <entry>Keyed with an OID column</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+
<tgroup cols="4">
<thead>
<row>
Re: Doc patch to note which system catalogs have oids
On 09/24/2012 08:18:00 PM, Stephen Frost wrote:
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
It's possible that it's worth expending a boilerplate paragraph in
each
of those pages to say "this catalog has OIDs" (or that it doesn't).
But this isn't the way.I'm afraid I disagree with this. The oid column, in the system
catalog, is user-facing and I like having it included as a column in
the
table in the docs, so users know what to use when doing joins.
Including something in the boilerplate about it not being shown by
default (or in the description in the table) might be alright, if we
don't change that.
Having information about oid included in the (printed) table
under a separate heading, as in v2 and v3 of this patch,
is something of a compromise. It's hard to visualize
from the sgml so it might be worth building the docs
and viewing with a file:/// url. The trouble is that
it's visually ugly because the two parts of the
table are of separate widths. There is almost surely a way
to change this in the xsl transformation to html/etc., but I
would probably do a bad job of it and can't
speak to the sanity of maintaining such a thing.
(So it's probably a bad idea.)
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
Re: Doc patch to note which system catalogs have oids
On 09/23/2012 08:57:45 PM, Karl O. Pinc wrote:
The attached patch documents the oid column of those
system catalogs having an oid.
Don't use the first version of this patch (oid_doc.patch)
without discarding the last hunk. The last hunk
introduces an error by duplicating the
documentation of the pg_roles.oid column.
(I am reluctant to post a revised version
since there's already 3 versions floating
around representing 2 different approaches
and no consensus as to which approach, if any, should
be taken.)
Regards,
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
Re: Doc patch to note which system catalogs have oids
On Mon, Sep 24, 2012 at 9:18 PM, Stephen Frost <sfrost@snowman.net> wrote:
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
I think this is fundamentally wrong, or at least misleading, because it
documents OID as if it were an ordinary column. Somebody who did
"select * from pg_class" and didn't see any "oid" in the result would
think the docs were wrong.Given that it's been quite some time since we defaulted to including
OIDs in tables, and the high level of confusion that individuals trying
to join pg_class and pg_namespace together go through due to select *
not including the oid column, I wonder if perhaps we should consider
changing that. Might be possible to do for just the catalog tables (to
minimize the risk of breaking poorly-written applications), or provide
a GUC to control including the oid column in select *.It's possible that it's worth expending a boilerplate paragraph in each
of those pages to say "this catalog has OIDs" (or that it doesn't).
But this isn't the way.I'm afraid I disagree with this. The oid column, in the system
catalog, is user-facing and I like having it included as a column in the
table in the docs, so users know what to use when doing joins.
+1.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Re: Doc patch to note which system catalogs have oids
On 09/25/2012 12:28:13 AM, Karl O. Pinc wrote:
On 09/23/2012 08:57:45 PM, Karl O. Pinc wrote:
The attached patch documents the oid column of those
system catalogs having an oid.Don't use the first version of this patch (oid_doc.patch)
without discarding the last hunk. The last hunk
introduces an error by duplicating the
documentation of the pg_roles.oid column.(I am reluctant to post a revised version
since there's already 3 versions floating
around representing 2 different approaches
and no consensus as to which approach, if any, should
be taken.)
I have figured out how to use the commitfest
pages to track what should be reviewed.
Submitting a corrected version of the very
first patch, which treats the oids as
regular columns.
I am now submitting patches to the commitfest
for review. (I'm not sure how I missed this.)
Regards,
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
Attachments:
oid_doc_v4.patchtext/x-patch; charset=us-ascii; name=oid_doc_v4.patchDownload
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index f999190..babb11c 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -427,6 +427,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>amname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -683,6 +690,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>amopfamily</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-opfamily"><structname>pg_opfamily</structname></link>.oid</literal></entry>
@@ -819,6 +833,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>amprocfamily</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-opfamily"><structname>pg_opfamily</structname></link>.oid</literal></entry>
@@ -902,6 +923,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>adrelid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
@@ -1257,6 +1285,14 @@
</thead>
<tbody>
+
+ <row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
<row>
<entry><structfield>rolname</structfield></entry>
<entry><type>name</type></entry>
@@ -1462,6 +1498,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>castsource</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
@@ -1577,6 +1620,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>relname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -1984,6 +2034,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>conname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2250,6 +2307,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>collname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2350,6 +2414,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>conname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2443,6 +2514,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>datname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -2652,6 +2730,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>defaclrole</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
@@ -3005,6 +3090,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>enumtypid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
@@ -3078,6 +3170,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>extname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3174,6 +3273,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>fdwname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3266,6 +3372,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>srvname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3675,6 +3788,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>lanname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3875,6 +3995,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>lomowner</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
@@ -3927,6 +4054,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>nspname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -3995,6 +4129,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>opcmethod</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-am"><structname>pg_am</structname></link>.oid</literal></entry>
@@ -4093,6 +4234,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>oprname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -4243,6 +4391,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>opfmethod</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-am"><structname>pg_am</structname></link>.oid</literal></entry>
@@ -4427,6 +4582,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>proname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -4819,6 +4981,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>rulename</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5488,6 +5657,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>spcname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5556,6 +5732,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>tgrelid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
@@ -5741,6 +5924,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>cfgname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5880,6 +6070,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>dictname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -5956,6 +6153,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>prsname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -6046,6 +6250,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>tmplname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -6113,6 +6324,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>typname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
@@ -6618,6 +6836,13 @@
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier</entry>
+ </row>
+
+ <row>
<entry><structfield>umuser</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
Re: Doc patch to note which system catalogs have oids
On Tue, 2012-10-02 at 10:46 -0500, Karl O. Pinc wrote:
I am now submitting patches to the commitfest
for review. (I'm not sure how I missed this.)
I prefer this version of the patch. I also attached an alternative
version that may address Tom's concern by noting that the OIDs are
hidden in the description.
Marking "ready for committer".
Regards,
Jeff Davis
Attachments:
doc-oids-alternative.patchtext/x-patch; charset=UTF-8; name=doc-oids-alternative.patchDownload
*** a/doc/src/sgml/catalogs.sgml
--- b/doc/src/sgml/catalogs.sgml
***************
*** 427,432 ****
--- 427,439 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>amname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 683,688 ****
--- 690,702 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>amopfamily</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-opfamily"><structname>pg_opfamily</structname></link>.oid</literal></entry>
***************
*** 819,824 ****
--- 833,845 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>amprocfamily</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-opfamily"><structname>pg_opfamily</structname></link>.oid</literal></entry>
***************
*** 902,907 ****
--- 923,935 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>adrelid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
***************
*** 1257,1262 ****
--- 1285,1298 ----
</thead>
<tbody>
+
+ <row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
<row>
<entry><structfield>rolname</structfield></entry>
<entry><type>name</type></entry>
***************
*** 1462,1467 ****
--- 1498,1510 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>castsource</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
***************
*** 1577,1582 ****
--- 1620,1632 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>relname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 1984,1989 ****
--- 2034,2046 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>conname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 2250,2255 ****
--- 2307,2319 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>collname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 2350,2355 ****
--- 2414,2426 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>conname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 2443,2448 ****
--- 2514,2526 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>datname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 2652,2657 ****
--- 2730,2742 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>defaclrole</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
***************
*** 3006,3011 ****
--- 3091,3103 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>enumtypid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry>
***************
*** 3079,3084 ****
--- 3171,3183 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>extname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 3175,3180 ****
--- 3274,3286 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>fdwname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 3267,3272 ****
--- 3373,3385 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>srvname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 3686,3691 ****
--- 3799,3811 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>lanname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 3886,3891 ****
--- 4006,4018 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>lomowner</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
***************
*** 3938,3943 ****
--- 4065,4077 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>nspname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 4006,4011 ****
--- 4140,4152 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>opcmethod</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-am"><structname>pg_am</structname></link>.oid</literal></entry>
***************
*** 4104,4109 ****
--- 4245,4257 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>oprname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 4254,4259 ****
--- 4402,4414 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>opfmethod</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-am"><structname>pg_am</structname></link>.oid</literal></entry>
***************
*** 4438,4443 ****
--- 4593,4605 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>proname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 4830,4835 ****
--- 4992,5004 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>rulename</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 5499,5504 ****
--- 5668,5680 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>spcname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 5567,5572 ****
--- 5743,5755 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>tgrelid</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
***************
*** 5752,5757 ****
--- 5935,5947 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>cfgname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 5891,5896 ****
--- 6081,6093 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>dictname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 5967,5972 ****
--- 6164,6176 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>prsname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 6057,6062 ****
--- 6261,6273 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>tmplname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 6124,6129 ****
--- 6335,6347 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>typname</structfield></entry>
<entry><type>name</type></entry>
<entry></entry>
***************
*** 6629,6634 ****
--- 6847,6859 ----
<tbody>
<row>
+ <entry><structfield>oid</structfield></entry>
+ <entry><type>oid</type></entry>
+ <entry></entry>
+ <entry>Row identifier (hidden attribute; must be explicitly selected)</entry>
+ </row>
+
+ <row>
<entry><structfield>umuser</structfield></entry>
<entry><type>oid</type></entry>
<entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>
Re: Doc patch to note which system catalogs have oids
On 12/14/2012 02:04:45 AM, Jeff Davis wrote:
On Tue, 2012-10-02 at 10:46 -0500, Karl O. Pinc wrote:
I am now submitting patches to the commitfest
for review. (I'm not sure how I missed this.)I prefer this version of the patch. I also attached an alternative
version that may address Tom's concern by noting that the OIDs are
hidden in the description.
For the record, the preferred version referred to above is:
oid_doc_v4.patch
Marking "ready for committer".
Thanks!
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Re: Doc patch to note which system catalogs have oids
On Fri, 2012-12-14 at 00:04 -0800, Jeff Davis wrote:
On Tue, 2012-10-02 at 10:46 -0500, Karl O. Pinc wrote:
I am now submitting patches to the commitfest
for review. (I'm not sure how I missed this.)I prefer this version of the patch. I also attached an alternative
version that may address Tom's concern by noting that the OIDs are
hidden in the description.
Committed this version.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers