Karsten Hilbert wrote:
> On Wed, Jan 21, 2009 at 01:49:44PM -0500, Bruce Momjian wrote:
>
> > Tom Lane wrote:
> > > Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> > > > This is what my 8.3 manual says:
> > >
> > > > conkey ? int2[] ? pg_attribute.attnum ? If a table constraint, list of columns which the constraint constrains
?
> > >
> > > > From that I wouldn't have figured it'd apply to foreign keys
> > > > as well. So I assume it is fair to say that "foreign keys
> > > > are one type of table constraint", right ?
> > >
> > > Right. I think what the comment is actually trying to point out is that
> > > conkey isn't relevant to domain constraints, which also appear in
> > > pg_constraint.
> >
> > Can someone come up with better documentation wording for conkey? I
> > can't:
> >
> > http://developer.postgresql.org/pgdocs/postgres/catalog-pg-constraint.html
>
> How about adding a second line:
>
> "Note: since foreign keys are table constraints, applies to those, too."
>
> or
>
> "If a foreign key, list of columns referencing the target table"
>
> (note, "referencing" as opposed to "referenced by" as in confkey)
I went a different direction with the documentation; I simplified the
wording and made it more explicit; attached and applied.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/catalogs.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v
retrieving revision 2.194
diff -c -c -r2.194 catalogs.sgml
*** doc/src/sgml/catalogs.sgml 4 Feb 2009 21:30:41 -0000 2.194
--- doc/src/sgml/catalogs.sgml 7 Feb 2009 14:52:38 -0000
***************
*** 1983,1989 ****
<entry><structfield>conkey</structfield></entry>
<entry><type>int2[]</type></entry>
<entry><literal><link
linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>.attnum</></entry>
! <entry>If a table constraint, list of columns which the constraint constrains</entry>
</row>
<row>
--- 1983,1989 ----
<entry><structfield>conkey</structfield></entry>
<entry><type>int2[]</type></entry>
<entry><literal><link
linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>.attnum</></entry>
! <entry>If a table constraint (including a foreign key), list of the constrained columns</entry>
</row>
<row>