Commit3624acd

committed

docs: small adjustements to recent SELECT and pg_upgrade improvements

1 parent8879fa0 commit3624acdCopy full SHA for 3624acd

File tree

-6

lines changed

-6

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -458,10 +458,10 @@ psql --username postgres --file script.sql postgres`
`458`	`458`	`<para>`
`459`	`459`	`Once you are satisfied with the upgrade, you can delete the old`
`460`	`460`	`cluster's data directories by running the script mentioned when`
`461`		`- <command>pg_upgrade</command> completes.You can also delete the`
`462`		`-old installation directories`
`463`		`-(e.g. <filename>bin</>, <filename>share</>). This will not work`
`464`		`-if you have tablespaces inside the old data directory.`
	`461`	`+ <command>pg_upgrade</command> completes.(Automatic deletion is not`
	`462`	`+possible if you have user-defined tablespaces inside the old data`
	`463`	`+directory.) You can also delete the old installation directories`
	`464`	`+(e.g. <filename>bin</>, <filename>share</>).`
`465`	`465`	`</para>`
`466`	`466`	`</step>`
`467`	`467`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1497,8 +1497,9 @@ SELECT * FROM <replaceable class="parameter">name</replaceable>`
`1497`	`1497`	`variant in parts of complex queries. Only the <literal>WITH</>,`
`1498`	`1498`	`<literal>UNION</>, <literal>INTERSECT</>, <literal>EXCEPT</>,`
`1499`	`1499`	`<literal>ORDER BY</>, <literal>LIMIT</>, <literal>OFFSET</>,`
`1500`		`- <literal>FETCH</> and locking clauses can be used with <command>TABLE</>;`
`1501`		`- the <literal>WHERE</> clause and any form of aggregation cannot`
	`1500`	`+ <literal>FETCH</> and <literal>FOR</> locking clauses can be used`
	`1501`	`+ with <command>TABLE</>; the <literal>WHERE</> clause and any form of`
	`1502`	`+ aggregation cannot`
`1502`	`1503`	`be used.`
`1503`	`1504`	`</para>`
`1504`	`1505`	`</refsect2>`

Comments

(0)