Is this patch to be applied?
---------------------------------------------------------------------------
Neil Conway wrote:
> This patch fixes a minor inaccuracy in the documentation: NOT NULL is
> not synonymous with CHECK (xxx IS NOT NULL) -- for example, consider
> ALTER TABLE ADD PRIMARY KEY, which checks for 'NOT NULL', not a check
> constraint.
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: doc/src/sgml/ref/create_table.sgml
===================================================================
RCS file: /var/lib/cvs/pgsql-server/doc/src/sgml/ref/create_table.sgml,v
retrieving revision 1.55
diff -c -r1.55 create_table.sgml
*** doc/src/sgml/ref/create_table.sgml 18 May 2002 15:44:47 -0000 1.55
--- doc/src/sgml/ref/create_table.sgml 1 Sep 2002 07:52:51 -0000
***************
*** 247,255 ****
<term><literal>NOT NULL</></term>
<listitem>
<para>
! The column is not allowed to contain NULL values. This is
! equivalent to the column constraint <literal>CHECK (<replaceable
! class="PARAMETER">column</replaceable> NOT NULL)</literal>.
</para>
</listitem>
</varlistentry>
--- 247,253 ----
<term><literal>NOT NULL</></term>
<listitem>
<para>
! The column is not allowed to contain NULL values.
</para>
</listitem>
</varlistentry>
