Commite1785d8

committed

doc: clarify CREATE TABLE AS ... IF NOT EXISTS

Mention that the table is not modified if it already exists.Reported-by: frank_limpert@yahoo.comDiscussion:https://postgr.es/m/164441177106.9677.5991676148704507229@wrigleys.postgresql.orgBackpatch-through: 10

1 parent483c426 commite1785d8Copy full SHA for e1785d8

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -95,9 +95,8 @@ CREATE [ [ GLOBAL \| LOCAL ] { TEMPORARY \| TEMP } \| UNLOGGED ] TABLE [ IF NOT EXI`
`95`	`95`	`<term><literal>IF NOT EXISTS</literal></term>`
`96`	`96`	`<listitem>`
`97`	`97`	`<para>`
`98`		`- Do not throw an error if a relation with the same name already exists.`
`99`		`- A notice is issued in this case. Refer to <xref linkend="sql-createtable"/>`
`100`		`- for details.`
	`98`	`+ Do not throw an error if a relation with the same name already`
	`99`	`+ exists; simply issue a notice and leave the table unmodified.`
`101`	`100`	`</para>`
`102`	`101`	`</listitem>`
`103`	`102`	`</varlistentry>`

Comments

(0)