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

Commit46e5975

Browse files
author
Alexander Korotkov
committed
Merge tag 'REL9_5_4' into waits_monitoring_95
2 parents60ba742 +eb4dfa2 commit46e5975

File tree

259 files changed

+15141
-12361
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

259 files changed

+15141
-12361
lines changed

‎configure

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
#! /bin/sh
22
# Guess values for system-dependent variables and create Makefiles.
3-
# Generated by GNU Autoconf 2.69 for PostgreSQL 9.5.3.
3+
# Generated by GNU Autoconf 2.69 for PostgreSQL 9.5.4.
44
#
55
# Report bugs to <pgsql-bugs@postgresql.org>.
66
#
@@ -582,8 +582,8 @@ MAKEFLAGS=
582582
# Identity of this package.
583583
PACKAGE_NAME='PostgreSQL'
584584
PACKAGE_TARNAME='postgresql'
585-
PACKAGE_VERSION='9.5.3'
586-
PACKAGE_STRING='PostgreSQL 9.5.3'
585+
PACKAGE_VERSION='9.5.4'
586+
PACKAGE_STRING='PostgreSQL 9.5.4'
587587
PACKAGE_BUGREPORT='pgsql-bugs@postgresql.org'
588588
PACKAGE_URL=''
589589

@@ -1395,7 +1395,7 @@ if test "$ac_init_help" = "long"; then
13951395
# Omit some internal or obsolete options to make the list less imposing.
13961396
# This message is too long to be a string in the A/UX 3.1 sh.
13971397
cat<<_ACEOF
1398-
\`configure' configures PostgreSQL 9.5.3 to adapt to many kinds of systems.
1398+
\`configure' configures PostgreSQL 9.5.4 to adapt to many kinds of systems.
13991399
14001400
Usage:$0 [OPTION]... [VAR=VALUE]...
14011401
@@ -1460,7 +1460,7 @@ fi
14601460

14611461
iftest -n"$ac_init_help";then
14621462
case$ac_init_helpin
1463-
short | recursive )echo"Configuration of PostgreSQL 9.5.3:";;
1463+
short | recursive )echo"Configuration of PostgreSQL 9.5.4:";;
14641464
esac
14651465
cat<<\_ACEOF
14661466
@@ -1610,7 +1610,7 @@ fi
16101610
test -n "$ac_init_help" && exit $ac_status
16111611
if $ac_init_version; then
16121612
cat <<\_ACEOF
1613-
PostgreSQL configure 9.5.3
1613+
PostgreSQL configure 9.5.4
16141614
generated by GNU Autoconf 2.69
16151615
16161616
Copyright (C) 2012 Free Software Foundation, Inc.
@@ -2321,7 +2321,7 @@ cat >config.log <<_ACEOF
23212321
This file contains any messages produced by compilers while
23222322
running configure, to aid debugging if configure makes a mistake.
23232323
2324-
It was created by PostgreSQL$as_me 9.5.3, which was
2324+
It was created by PostgreSQL$as_me 9.5.4, which was
23252325
generated by GNU Autoconf 2.69. Invocation command line was
23262326
23272327
$$0$@
@@ -16195,7 +16195,7 @@ cat >>$CONFIG_STATUS <<\_ACEOF || ac_write_fail=1
1619516195
# report actual input values of CONFIG_FILES etc. instead of their
1619616196
# values after options handling.
1619716197
ac_log="
16198-
This file was extended by PostgreSQL $as_me 9.5.3, which was
16198+
This file was extended by PostgreSQL $as_me 9.5.4, which was
1619916199
generated by GNU Autoconf 2.69. Invocation command line was
1620016200
1620116201
CONFIG_FILES = $CONFIG_FILES
@@ -16265,7 +16265,7 @@ _ACEOF
1626516265
cat >>$CONFIG_STATUS <<_ACEOF || ac_write_fail=1
1626616266
ac_cs_config="`$as_echo"$ac_configure_args" | sed 's/^ //; s/[\\""\`\$]/\\\\&/g'`"
1626716267
ac_cs_version="\\
16268-
PostgreSQL config.status 9.5.3
16268+
PostgreSQL config.status 9.5.4
1626916269
configured by$0, generated by GNU Autoconf 2.69,
1627016270
with options\\"\$ac_cs_config\\"
1627116271

‎configure.in

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -17,7 +17,7 @@ dnl Read the Autoconf manual for details.
1717
dnl
1818
m4_pattern_forbid(^PGAC_)dnl to catch undefined macros
1919

20-
AC_INIT([PostgreSQL], [9.5.3], [pgsql-bugs@postgresql.org])
20+
AC_INIT([PostgreSQL], [9.5.4], [pgsql-bugs@postgresql.org])
2121

2222
m4_if(m4_defn([m4_PACKAGE_VERSION]), [2.69], [], [m4_fatal([Autoconf version 2.69 is required.
2323
Untested combinations of 'autoconf' and PostgreSQL versions are not

‎contrib/btree_gin/btree_gin.c

Lines changed: 2 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -223,10 +223,7 @@ GIN_SUPPORT(int4, false, leftmostvalue_int4, btint4cmp)
223223
staticDatum
224224
leftmostvalue_int8(void)
225225
{
226-
/*
227-
* Use sequence's definition to keep compatibility.
228-
*/
229-
returnInt64GetDatum(SEQ_MINVALUE);
226+
returnInt64GetDatum(PG_INT64_MIN);
230227
}
231228

232229
GIN_SUPPORT(int8, false,leftmostvalue_int8,btint8cmp)
@@ -250,10 +247,7 @@ GIN_SUPPORT(float8, false, leftmostvalue_float8, btfloat8cmp)
250247
staticDatum
251248
leftmostvalue_money(void)
252249
{
253-
/*
254-
* Use sequence's definition to keep compatibility.
255-
*/
256-
returnInt64GetDatum(SEQ_MINVALUE);
250+
returnInt64GetDatum(PG_INT64_MIN);
257251
}
258252

259253
GIN_SUPPORT(money, false,leftmostvalue_money,cash_cmp)

‎contrib/btree_gin/expected/bytea.out

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -4,21 +4,21 @@ SET bytea_output TO escape;
44
CREATE TABLE test_bytea (
55
i bytea
66
);
7-
INSERT INTO test_bytea VALUES ('aaa'),('a'),('abc'),('abb'),('axy'),('xyz');
7+
INSERT INTO test_bytea VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');
88
CREATE INDEX idx_bytea ON test_bytea USING gin (i);
99
SELECT * FROM test_bytea WHERE i<'abc'::bytea ORDER BY i;
1010
i
1111
-----
1212
a
13-
aaa
13+
ab
1414
abb
1515
(3 rows)
1616

1717
SELECT * FROM test_bytea WHERE i<='abc'::bytea ORDER BY i;
1818
i
1919
-----
2020
a
21-
aaa
21+
ab
2222
abb
2323
abc
2424
(4 rows)

‎contrib/btree_gin/expected/text.out

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -2,21 +2,21 @@ set enable_seqscan=off;
22
CREATE TABLE test_text (
33
i text
44
);
5-
INSERT INTO test_text VALUES ('aaa'),('a'),('abc'),('abb'),('axy'),('xyz');
5+
INSERT INTO test_text VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');
66
CREATE INDEX idx_text ON test_text USING gin (i);
77
SELECT * FROM test_text WHERE i<'abc' ORDER BY i;
88
i
99
-----
1010
a
11-
aaa
11+
ab
1212
abb
1313
(3 rows)
1414

1515
SELECT * FROM test_text WHERE i<='abc' ORDER BY i;
1616
i
1717
-----
1818
a
19-
aaa
19+
ab
2020
abb
2121
abc
2222
(4 rows)

‎contrib/btree_gin/expected/varchar.out

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -2,21 +2,21 @@ set enable_seqscan=off;
22
CREATE TABLE test_varchar (
33
i varchar
44
);
5-
INSERT INTO test_varchar VALUES ('aaa'),('a'),('abc'),('abb'),('axy'),('xyz');
5+
INSERT INTO test_varchar VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');
66
CREATE INDEX idx_varchar ON test_varchar USING gin (i);
77
SELECT * FROM test_varchar WHERE i<'abc'::varchar ORDER BY i;
88
i
99
-----
1010
a
11-
aaa
11+
ab
1212
abb
1313
(3 rows)
1414

1515
SELECT * FROM test_varchar WHERE i<='abc'::varchar ORDER BY i;
1616
i
1717
-----
1818
a
19-
aaa
19+
ab
2020
abb
2121
abc
2222
(4 rows)

‎contrib/btree_gin/sql/bytea.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@ CREATE TABLE test_bytea (
66
ibytea
77
);
88

9-
INSERT INTO test_byteaVALUES ('aaa'),('a'),('abc'),('abb'),('axy'),('xyz');
9+
INSERT INTO test_byteaVALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');
1010

1111
CREATEINDEXidx_byteaON test_bytea USING gin (i);
1212

‎contrib/btree_gin/sql/text.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ CREATE TABLE test_text (
44
itext
55
);
66

7-
INSERT INTO test_textVALUES ('aaa'),('a'),('abc'),('abb'),('axy'),('xyz');
7+
INSERT INTO test_textVALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');
88

99
CREATEINDEXidx_textON test_text USING gin (i);
1010

‎contrib/btree_gin/sql/varchar.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ CREATE TABLE test_varchar (
44
ivarchar
55
);
66

7-
INSERT INTO test_varcharVALUES ('aaa'),('a'),('abc'),('abb'),('axy'),('xyz');
7+
INSERT INTO test_varcharVALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz');
88

99
CREATEINDEXidx_varcharON test_varchar USING gin (i);
1010

‎contrib/btree_gist/expected/interval.out

Lines changed: 18 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -89,3 +89,21 @@ SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21
8989
@ 220 days 19 hours 5 mins 42 secs | @ 21 days -2 hours -15 mins -41 secs
9090
(3 rows)
9191

92+
SET enable_indexonlyscan=off;
93+
EXPLAIN (COSTS OFF)
94+
SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21:21:23' LIMIT 3;
95+
QUERY PLAN
96+
---------------------------------------------------------------------------
97+
Limit
98+
-> Index Scan using intervalidx on intervaltmp
99+
Order By: (a <-> '@ 199 days 21 hours 21 mins 23 secs'::interval)
100+
(3 rows)
101+
102+
SELECT a, a <-> '199 days 21:21:23' FROM intervaltmp ORDER BY a <-> '199 days 21:21:23' LIMIT 3;
103+
a | ?column?
104+
-------------------------------------+--------------------------------------
105+
@ 199 days 21 hours 21 mins 23 secs | @ 0
106+
@ 183 days 6 hours 52 mins 48 secs | @ 16 days 14 hours 28 mins 35 secs
107+
@ 220 days 19 hours 5 mins 42 secs | @ 21 days -2 hours -15 mins -41 secs
108+
(3 rows)
109+

‎contrib/btree_gist/expected/not_equal.out

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,6 +9,7 @@ INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
99
INSERT INTO test_ne VALUES('2007-02-03', -91.3);
1010
INSERT INTO test_ne VALUES('2011-09-01', 43.7);
1111
INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
12+
SET enable_indexscan to false;
1213
EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
1314
QUERY PLAN
1415
------------------------------------------------------------------------------------------------------
@@ -25,6 +26,7 @@ SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
2526
Thu Sep 01 00:00:00 2011 | 43.7
2627
(2 rows)
2728

29+
RESET enable_indexscan;
2830
-- test search for "not equals" using an exclusion constraint
2931
CREATE TABLE zoo (
3032
cage INTEGER,

‎contrib/btree_gist/sql/interval.sql

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -35,3 +35,9 @@ SELECT count(*) FROM intervaltmp WHERE a > '199 days 21:21:23'::interval;
3535
EXPLAIN (COSTS OFF)
3636
SELECT a, a<->'199 days 21:21:23'FROM intervaltmpORDER BY a<->'199 days 21:21:23'LIMIT3;
3737
SELECT a, a<->'199 days 21:21:23'FROM intervaltmpORDER BY a<->'199 days 21:21:23'LIMIT3;
38+
39+
SET enable_indexonlyscan=off;
40+
41+
EXPLAIN (COSTS OFF)
42+
SELECT a, a<->'199 days 21:21:23'FROM intervaltmpORDER BY a<->'199 days 21:21:23'LIMIT3;
43+
SELECT a, a<->'199 days 21:21:23'FROM intervaltmpORDER BY a<->'199 days 21:21:23'LIMIT3;

‎contrib/btree_gist/sql/not_equal.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -14,10 +14,14 @@ INSERT INTO test_ne VALUES('2007-02-03', -91.3);
1414
INSERT INTO test_neVALUES('2011-09-01',43.7);
1515
INSERT INTO test_neSELECT'2009-01-01',10.7FROM generate_series(1,1000);
1616

17+
SET enable_indexscan to false;
18+
1719
EXPLAIN (COSTS OFF)SELECT*FROM test_neWHERE a<>'2009-01-01'AND b<>10.7;
1820

1921
SELECT*FROM test_neWHERE a<>'2009-01-01'AND b<>10.7;
2022

23+
RESET enable_indexscan;
24+
2125
-- test search for "not equals" using an exclusion constraint
2226

2327
CREATETABLEzoo (

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp