postgres.git / summary / log / commit / refs

commit    4e32fb1631dc6a7e0bb21b2e4ac77299231c2745
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Fri Aug 12 14:59:00 2022 +0000
First released in: 16.0, 10.23, 11.18, 12.13, 13.9, 14.6, 15.0

    doc:  clarify CREATE TABLE AS ... IF NOT EXISTS
    
    Mention that the table is not modified if it already exists.
    
    Reported-by: frank_limpert@yahoo.com
    
    Discussion: https://postgr.es/m/164441177106.9677.5991676148704507229@wrigleys.postgresql.org
    
    Backpatch-through: 10


 doc/src/sgml/ref/create_table_as.sgml | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml
index 56d06838f16..5361412df02 100644
--- a/doc/src/sgml/ref/create_table_as.sgml
+++ b/doc/src/sgml/ref/create_table_as.sgml
@@ -95,9 +95,8 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
     <term><literal>IF NOT EXISTS</literal></term>
     <listitem>
      <para>
-      Do not throw an error if a relation with the same name already exists.
-      A notice is issued in this case. Refer to <xref linkend="sql-createtable"/>
-      for details.
+      Do not throw an error if a relation with the same name already
+      exists; simply issue a notice and leave the table unmodified.
      </para>
     </listitem>
    </varlistentry>


[parent: 2f65ef5c5b6b]