Commit5b3dca0

committed

Clarify temporary table name shadowing in CREATE TABLE docs

Author: David Johnston

1 parent257836a commit5b3dca0Copy full SHA for 5b3dca0

File tree

-2

lines changed

-2

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -171,8 +171,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`171`	`171`	`If specified, the table is created as a temporary table.`
`172`	`172`	`Temporary tables are automatically dropped at the end of a`
`173`	`173`	`session, or optionally at the end of the current transaction`
`174`		`- (see <literal>ON COMMIT</literal> below). Existing permanent`
`175`		`- tables with the same name are not visible to the current session`
	`174`	`+ (see <literal>ON COMMIT</literal> below). The default`
	`175`	`+ search_path includes the temporary schema first and so identically`
	`176`	`+ named existing permanent tables are not chosen for new plans`
`176`	`177`	`while the temporary table exists, unless they are referenced`
`177`	`178`	`with schema-qualified names. Any indexes created on a temporary`
`178`	`179`	`table are automatically temporary as well.`

Comments

(0)