Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commita69833c

Browse files
committed
Mention new =NULL change in Migration section.
1 parent75df678 commita69833c

File tree

1 file changed

+8
-3
lines changed

1 file changed

+8
-3
lines changed

‎HISTORY

Lines changed: 8 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -37,9 +37,14 @@ several languages.
3737
Migration to 7.2
3838

3939
A dump/restore using pg_dump is required for those wishing to migrate
40-
data from any previous release. The SELECT ... LIMIT 10,20 syntax will
41-
be removed in 7.3. You should change your queries to use LIMIT 10
42-
OFFSET 20. Also, pg_hba.conf only loads on SIGHUP now.
40+
data from any previous release. In this release, comparisons using "=
41+
NULL" will always return false. Previous releases automatically
42+
transformed this syntax to "IS NULL", which is the standards-
43+
compliant way to do NULL comparisons. The old behavior can be
44+
re-enabled using a postgresql.conf parameter. The SELECT ... LIMIT
45+
#,# syntax will be removed in 7.3. You should change your queries to
46+
use separate LIMIT and OFFSET clauses, e.g. LIMIT 10 OFFSET 20. Also,
47+
pg_hba.conf now only loads on SIGHUP.
4348

4449

4550

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp