1
1
<!-- doc/src/sgml/release-9.3.sgml -->
2
2
<!-- See header comment in release.sgml about typical markup -->
4
<sect1 id="release-9-3-6">
5
<title>Release 9.3.6</title>
8
<title>Release Date</title>
9
<simpara>2015-02-05</simpara>
13
This release contains a variety of fixes from 9.3.5.
14
For information about new features in the 9.3 major release, see
15
<xref linkend="release-9-3">.
19
<title>Migration to Version 9.3.6</title>
22
A dump/restore is not required for those running 9.3.X.
26
However, if you are a Windows user and are using the <quote>Norwegian
27
(Bokmål)</> locale, manual action is needed after the upgrade to
28
replace any <quote>Norwegian (Bokmål)_Norway</> locale names stored
29
in <productname>PostgreSQL</> system catalogs with the plain-ASCII
30
alias <quote>Norwegian_Norway</>. For details see
31
<ulink url="http://wiki.postgresql.org/wiki/Changes_To_Norwegian_Locale"></>
35
Also, if you are upgrading from a version earlier than 9.3.5,
36
see <xref linkend="release-9-3-5">.
42
<title>Changes</title>
47
Author: Bruce Momjian <bruce@momjian.us>
48
Branch: master [0150ab567] 2015-02-02 10:00:44 -0500
49
Branch: REL9_4_STABLE [1628a0bbf] 2015-02-02 10:00:49 -0500
50
Branch: REL9_3_STABLE [b8b580147] 2015-02-02 10:00:50 -0500
51
Branch: REL9_2_STABLE [5ae3bf1af] 2015-02-02 10:00:50 -0500
52
Branch: REL9_1_STABLE [037529a11] 2015-02-02 10:00:51 -0500
53
Branch: REL9_0_STABLE [611e110aa] 2015-02-02 10:00:52 -0500
54
Author: Bruce Momjian <bruce@momjian.us>
55
Branch: master [9241c84cb] 2015-02-02 10:00:45 -0500
56
Branch: REL9_4_STABLE [56d2bee9d] 2015-02-02 10:00:49 -0500
57
Branch: REL9_3_STABLE [fe2526990] 2015-02-02 10:00:50 -0500
58
Branch: REL9_2_STABLE [e09651e9d] 2015-02-02 10:00:50 -0500
59
Branch: REL9_1_STABLE [2ceb63deb] 2015-02-02 10:00:51 -0500
60
Branch: REL9_0_STABLE [56b970f2e] 2015-02-02 10:00:52 -0500
65
Fix buffer overruns in <function>to_char()</>
70
When <function>to_char()</> processes a numeric formatting template
71
calling for a large number of digits, <productname>PostgreSQL</>
72
would read past the end of a buffer. When processing a crafted
73
timestamp formatting template, <productname>PostgreSQL</> would write
74
past the end of a buffer. Either case could crash the server.
75
We have not ruled out the possibility of attacks that lead to
76
privilege escalation, though they seem unlikely.
82
Author: Bruce Momjian <bruce@momjian.us>
83
Branch: master [29725b3db] 2015-02-02 10:00:45 -0500
84
Branch: REL9_4_STABLE [2ac95c83c] 2015-02-02 10:00:49 -0500
85
Branch: REL9_3_STABLE [bc4d5f2e5] 2015-02-02 10:00:50 -0500
86
Branch: REL9_2_STABLE [c6c6aa288] 2015-02-02 10:00:51 -0500
87
Branch: REL9_1_STABLE [98f2479d8] 2015-02-02 10:00:51 -0500
88
Branch: REL9_0_STABLE [9e05c5063] 2015-02-02 10:00:52 -0500
93
Fix buffer overrun in replacement <function>*printf()</> functions
98
<productname>PostgreSQL</> includes a replacement implementation
99
of <function>printf</> and related functions. This code will overrun
100
a stack buffer when formatting a floating point number (conversion
101
specifiers <literal>e</>, <literal>E</>, <literal>f</>, <literal>F</>,
102
<literal>g</> or <literal>G</>) with requested precision greater than
103
about 500. This will crash the server, and we have not ruled out the
104
possibility of attacks that lead to privilege escalation.
105
A database user can trigger such a buffer overrun through
106
the <function>to_char()</> SQL function. While that is the only
107
affected core <productname>PostgreSQL</> functionality, extension
108
modules that use printf-family functions may be at risk as well.
112
This issue primarily affects <productname>PostgreSQL</> on Windows.
113
<productname>PostgreSQL</> uses the system implementation of these
114
functions where adequate, which it is on other modern platforms.
120
Author: Noah Misch <noah@leadboat.com>
121
Branch: master [1dc755158] 2015-02-02 10:00:45 -0500
122
Branch: REL9_4_STABLE [82806cf4e] 2015-02-02 10:00:49 -0500
123
Branch: REL9_3_STABLE [6994f0790] 2015-02-02 10:00:50 -0500
124
Branch: REL9_2_STABLE [d95ebe0ac] 2015-02-02 10:00:51 -0500
125
Branch: REL9_1_STABLE [11f738a8a] 2015-02-02 10:00:51 -0500
126
Branch: REL9_0_STABLE [ce6f261cd] 2015-02-02 10:00:52 -0500
127
Author: Noah Misch <noah@leadboat.com>
128
Branch: master [8b59672d8] 2015-02-02 10:00:45 -0500
129
Branch: REL9_4_STABLE [258e294db] 2015-02-02 10:00:49 -0500
130
Branch: REL9_3_STABLE [a558ad3a7] 2015-02-02 10:00:50 -0500
131
Branch: REL9_2_STABLE [d1972da8c] 2015-02-02 10:00:51 -0500
132
Branch: REL9_1_STABLE [8d412e02e] 2015-02-02 10:00:52 -0500
133
Branch: REL9_0_STABLE [0a3ee8a5f] 2015-02-02 10:00:52 -0500
138
Fix buffer overruns in <filename>contrib/pgcrypto</>
139
(Marko Tiikkaja, Noah Misch)
143
Errors in memory size tracking within the <filename>pgcrypto</>
144
module permitted stack buffer overruns and improper dependence on the
145
contents of uninitialized memory. The buffer overrun cases can
146
crash the server, and we have not ruled out the possibility of
147
attacks that lead to privilege escalation.
153
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
154
Branch: master [2b3a8b20c] 2015-02-02 17:09:53 +0200
155
Branch: REL9_4_STABLE [57ec87c6b] 2015-02-02 17:09:46 +0200
156
Branch: REL9_3_STABLE [cd19848bd] 2015-02-02 17:09:40 +0200
157
Branch: REL9_2_STABLE [289592b23] 2015-02-02 17:09:35 +0200
158
Branch: REL9_1_STABLE [af9c5c074] 2015-02-02 17:09:31 +0200
159
Branch: REL9_0_STABLE [47ba0fbd7] 2015-02-02 17:09:25 +0200
164
Fix possible loss of frontend/backend protocol synchronization after
170
If any error occurred while the server was in the middle of reading a
171
protocol message from the client, it could lose synchronization and
172
incorrectly try to interpret part of the message's data as a new
173
protocol message. An attacker able to submit crafted binary data
174
within a command parameter might succeed in injecting his own SQL
175
commands this way. Statement timeout and query cancellation are the
176
most likely sources of errors triggering this scenario. Particularly
177
vulnerable are applications that use a timeout and also submit
178
arbitrary user-crafted data as binary query parameters. Disabling
179
statement timeout will reduce, but not eliminate, the risk of
180
exploit. Our thanks to Emil Lenngren for reporting this issue.
186
Author: Stephen Frost <sfrost@snowman.net>
187
Branch: master [804b6b6db] 2015-01-28 12:31:30 -0500
188
Branch: REL9_4_STABLE [3cc74a3d6] 2015-01-28 12:32:06 -0500
189
Branch: REL9_3_STABLE [4b9874216] 2015-01-28 12:32:39 -0500
190
Branch: REL9_2_STABLE [d49f84b08] 2015-01-28 12:32:56 -0500
191
Branch: REL9_1_STABLE [9406884af] 2015-01-28 12:33:15 -0500
192
Branch: REL9_0_STABLE [3a2063369] 2015-01-28 12:33:29 -0500
197
Fix information leak via constraint-violation error messages
202
Some server error messages show the values of columns that violate
203
a constraint, such as a unique constraint. If the user does not have
204
<literal>SELECT</> privilege on all columns of the table, this could
205
mean exposing values that the user should not be able to see. Adjust
206
the code so that values are displayed only when they came from the SQL
207
command or could be selected by the user.
213
Author: Noah Misch <noah@leadboat.com>
214
Branch: master [f6dc6dd5b] 2014-12-17 22:48:40 -0500
215
Branch: REL9_4_STABLE [6b87d423d] 2014-12-17 22:48:45 -0500
216
Branch: REL9_3_STABLE [442dc2c35] 2014-12-17 22:48:46 -0500
217
Branch: REL9_2_STABLE [0046f651d] 2014-12-17 22:48:47 -0500
218
Branch: REL9_1_STABLE [6aa98e957] 2014-12-17 22:48:47 -0500
219
Branch: REL9_0_STABLE [6d45ee572] 2014-12-17 22:48:48 -0500
224
Lock down regression testing's temporary installations on Windows
229
Use SSPI authentication to allow connections only from the OS user
230
who launched the test suite. This closes on Windows the same
231
vulnerability previously closed on other platforms, namely that other
232
users might be able to connect to the test postmaster.
238
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
239
Branch: REL9_3_STABLE [8f80dcf3c] 2014-10-24 19:59:49 +0300
240
Branch: REL9_2_STABLE [d440c4b55] 2014-10-24 19:59:52 +0300
241
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
242
Branch: REL9_3_STABLE [2a1b34959] 2014-10-24 19:36:28 +0300
243
Branch: REL9_2_STABLE [737ae3fc7] 2014-10-24 19:53:27 +0300
244
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
245
Branch: master [aa1d2fc5e] 2015-01-16 13:28:19 +0200
246
Branch: REL9_4_STABLE [2049a7d82] 2015-01-16 13:10:06 +0200
247
Branch: REL9_3_STABLE [1619442a1] 2015-01-16 13:10:15 +0200
248
Branch: REL9_2_STABLE [6bf343c6e] 2015-01-16 13:10:23 +0200
253
Cope with the Windows locale named <quote>Norwegian (Bokmål)</>
258
Non-ASCII locale names are problematic since it's not clear what
259
encoding they should be represented in. Map the troublesome locale
260
name to a plain-ASCII alias, <quote>Norwegian_Norway</>.
265
Author: Tom Lane <tgl@sss.pgh.pa.us>
266
Branch: REL9_3_STABLE [f88300168] 2014-11-04 13:24:14 -0500
267
Branch: REL9_2_STABLE [db72ad02e] 2014-11-04 13:24:17 -0500
268
Branch: REL9_1_STABLE [7c6f55e9e] 2014-11-04 13:24:22 -0500
269
Branch: REL9_0_STABLE [45a607d5c] 2014-11-04 13:24:26 -0500
274
Avoid possible data corruption if <command>ALTER DATABASE SET
275
TABLESPACE</> is used to move a database to a new tablespace and then
276
shortly later move it back to its original tablespace (Tom Lane)
281
Author: Tom Lane <tgl@sss.pgh.pa.us>
282
Branch: REL9_3_STABLE [81f0a5e38] 2014-10-29 18:12:08 -0400
283
Branch: REL9_2_STABLE [40058fbce] 2014-10-29 18:12:11 -0400
284
Branch: REL9_1_STABLE [6ec1c3ef8] 2014-10-29 18:12:17 -0400
285
Branch: REL9_0_STABLE [9d06da58e] 2014-10-29 18:12:20 -0400
286
Author: Tom Lane <tgl@sss.pgh.pa.us>
287
Branch: REL9_3_STABLE [e65b550b3] 2014-10-30 13:03:28 -0400
288
Branch: REL9_2_STABLE [38cb8687a] 2014-10-30 13:03:31 -0400
289
Branch: REL9_1_STABLE [fcf0246b2] 2014-10-30 13:03:34 -0400
290
Branch: REL9_0_STABLE [73f950fc8] 2014-10-30 13:03:39 -0400
295
Avoid corrupting tables when <command>ANALYZE</> inside a transaction
296
is rolled back (Andres Freund, Tom Lane, Michael Paquier)
300
If the failing transaction had earlier removed the last index, rule, or
301
trigger from the table, the table would be left in a corrupted state
302
with the relevant <structname>pg_class</> flags not set though they
308
Author: Andres Freund <andres@anarazel.de>
309
Branch: REL9_3_STABLE [d7624e562] 2014-10-20 23:45:31 +0200
310
Branch: REL9_2_STABLE [fd29810d1] 2014-10-20 23:47:00 +0200
311
Branch: REL9_1_STABLE [d5fef87e9] 2014-10-20 23:47:45 +0200
316
Ensure that unlogged tables are copied correctly
317
during <command>CREATE DATABASE</> or <command>ALTER DATABASE SET
318
TABLESPACE</> (Pavan Deolasee, Andres Freund)
323
Author: Robert Haas <rhaas@postgresql.org>
324
Branch: REL9_3_STABLE [e35db342a] 2014-09-22 16:19:59 -0400
329
Fix incorrect processing
330
of <structname>CreateEventTrigStmt</>.<structfield>eventname</> (Petr
335
This could result in misbehavior if <command>CREATE EVENT TRIGGER</>
336
were executed as a prepared query, or via extended query protocol.
341
Author: Tom Lane <tgl@sss.pgh.pa.us>
342
Branch: REL9_3_STABLE [2a83e0349] 2014-11-11 17:00:21 -0500
343
Branch: REL9_2_STABLE [1c2f9a4f6] 2014-11-11 17:00:25 -0500
344
Branch: REL9_1_STABLE [94d5d57d5] 2014-11-11 17:00:28 -0500
349
Fix <command>DROP</>'s dependency searching to correctly handle the
350
case where a table column is recursively visited before its table
351
(Petr Jelinek, Tom Lane)
355
This case is only known to arise when an extension creates both a
356
datatype and a table using that datatype. The faulty code might
357
refuse a <command>DROP EXTENSION</> unless <literal>CASCADE</> is
358
specified, which should not be required.
363
Author: Tom Lane <tgl@sss.pgh.pa.us>
364
Branch: master [c480cb9d2] 2015-01-15 18:52:58 -0500
365
Branch: REL9_4_STABLE [b75d18bd4] 2015-01-15 18:53:05 -0500
366
Branch: REL9_3_STABLE [34668c8ec] 2015-01-15 18:52:28 -0500
367
Branch: REL9_2_STABLE [0acb32efb] 2015-01-15 18:52:31 -0500
368
Branch: REL9_1_STABLE [450530fce] 2015-01-15 18:52:34 -0500
369
Branch: REL9_0_STABLE [5308e085b] 2015-01-15 18:52:38 -0500
374
Fix use-of-already-freed-memory problem in EvalPlanQual processing
379
In <literal>READ COMMITTED</> mode, queries that lock or update
380
recently-updated rows could crash as a result of this bug.
385
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
386
Branch: master [0e5680f47] 2014-12-26 13:52:27 -0300
387
Branch: REL9_4_STABLE [0e3a1f71d] 2014-12-26 13:52:27 -0300
388
Branch: REL9_3_STABLE [048912386] 2014-12-26 13:52:27 -0300
393
Avoid possible deadlock while trying to acquire tuple locks
394
in EvalPlanQual processing (Álvaro Herrera, Mark Kirkwood)
399
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
400
Branch: master [d5e3d1e96] 2015-01-04 15:48:29 -0300
401
Branch: REL9_4_STABLE [51742063b] 2015-01-04 15:48:29 -0300
402
Branch: REL9_3_STABLE [54a8abc2b] 2015-01-04 15:48:29 -0300
407
Fix failure to wait when a transaction tries to acquire a <literal>FOR
408
NO KEY EXCLUSIVE</> tuple lock, while multiple other transactions
409
currently hold <literal>FOR SHARE</> locks (Álvaro Herrera)
414
Author: Tom Lane <tgl@sss.pgh.pa.us>
415
Branch: REL9_3_STABLE [2ae8a01ca] 2014-12-11 21:02:31 -0500
416
Branch: REL9_2_STABLE [cd63c57e5] 2014-12-11 21:02:34 -0500
417
Branch: REL9_1_STABLE [bca39b578] 2014-12-11 21:02:38 -0500
418
Branch: REL9_0_STABLE [662eebdc6] 2014-12-11 21:02:41 -0500
423
Fix planning of <command>SELECT FOR UPDATE</> when using a partial
424
index on a child table (Kyotaro Horiguchi)
428
In <literal>READ COMMITTED</> mode, <command>SELECT FOR UPDATE</> must
429
also recheck the partial index's <literal>WHERE</> condition when
430
rechecking a recently-updated row to see if it still satisfies the
431
query's <literal>WHERE</> condition. This requirement was missed if the
432
index belonged to an inheritance child table, so that it was possible
433
to incorrectly return rows that no longer satisfy the query condition.
438
Author: Tom Lane <tgl@sss.pgh.pa.us>
439
Branch: REL9_3_STABLE [f14196c35] 2014-12-11 19:37:07 -0500
440
Branch: REL9_2_STABLE [deadbf4f3] 2014-12-11 19:37:10 -0500
441
Branch: REL9_1_STABLE [21946ac9b] 2014-12-11 19:37:14 -0500
442
Branch: REL9_0_STABLE [f5e4e92fb] 2014-12-11 19:37:17 -0500
447
Fix corner case wherein <command>SELECT FOR UPDATE</> could return a row
448
twice, and possibly miss returning other rows (Tom Lane)
452
In <literal>READ COMMITTED</> mode, a <command>SELECT FOR UPDATE</>
453
that is scanning an inheritance tree could incorrectly return a row
454
from a prior child table instead of the one it should return from a
460
Author: Tom Lane <tgl@sss.pgh.pa.us>
461
Branch: master [a5cd70dcb] 2015-01-15 13:18:12 -0500
462
Branch: REL9_4_STABLE [d25192892] 2015-01-15 13:18:16 -0500
463
Branch: REL9_3_STABLE [939f0fb67] 2015-01-15 13:18:19 -0500
468
Improve performance of <command>EXPLAIN</> with large range tables
474
Author: Tom Lane <tgl@sss.pgh.pa.us>
475
Branch: REL9_3_STABLE [7a9c8cefb] 2014-08-09 13:46:42 -0400
476
Branch: REL9_2_STABLE [b4dacab12] 2014-08-09 13:46:45 -0400
477
Branch: REL9_1_STABLE [bbe826f21] 2014-08-09 13:46:48 -0400
478
Branch: REL9_0_STABLE [4ff49746e] 2014-08-09 13:46:52 -0400
483
Reject duplicate column names in the referenced-columns list of
484
a <literal>FOREIGN KEY</> declaration (David Rowley)
488
This restriction is per SQL standard. Previously we did not reject
489
the case explicitly, but later on the code would fail with
490
bizarre-looking errors.
495
Author: Tom Lane <tgl@sss.pgh.pa.us>
496
Branch: REL9_3_STABLE [6306d0712] 2014-07-22 13:30:14 -0400
501
Re-enable error for <literal>SELECT ... OFFSET -1</> (Tom Lane)
505
A negative offset value has been an error since 8.4, but an
506
optimization added in 9.3 accidentally turned the case into a no-op.
507
Restore the expected behavior.
512
Author: Tom Lane <tgl@sss.pgh.pa.us>
513
Branch: REL9_3_STABLE [8b65e0a33] 2014-08-09 18:40:34 -0400
514
Branch: REL9_2_STABLE [15026ab97] 2014-08-09 18:40:38 -0400
519
Restore previous behavior of conversion of domains to JSON
524
This change causes domains over numeric and boolean to be treated
525
like their base types for purposes of conversion to JSON. It worked
526
like that before 9.3.5 and 9.2.9, but was unintentionally changed
527
while fixing a related problem.
532
Author: Tom Lane <tgl@sss.pgh.pa.us>
533
Branch: REL9_3_STABLE [8571ecb24] 2014-12-02 15:02:43 -0500
538
Fix <function>json_agg()</> to not return extra trailing right
539
brackets in its result (Tom Lane)
544
Author: Tom Lane <tgl@sss.pgh.pa.us>
545
Branch: REL9_3_STABLE [25bf13fe1] 2014-09-11 23:30:57 -0400
546
Branch: REL9_2_STABLE [228ed4370] 2014-09-11 23:31:00 -0400
547
Branch: REL9_1_STABLE [cf5c20b06] 2014-09-11 23:31:03 -0400
548
Branch: REL9_0_STABLE [26f8a4691] 2014-09-11 23:31:06 -0400
553
Fix bugs in raising a <type>numeric</> value to a large integral power
558
The previous code could get a wrong answer, or consume excessive
559
amounts of time and memory before realizing that the answer must
565
Author: Tom Lane <tgl@sss.pgh.pa.us>
566
Branch: REL9_3_STABLE [10b81fbdc] 2014-12-01 15:25:08 -0500
567
Branch: REL9_2_STABLE [e640042e9] 2014-12-01 15:25:12 -0500
568
Branch: REL9_1_STABLE [2e3cc3955] 2014-12-01 15:25:15 -0500
569
Branch: REL9_0_STABLE [e6550626c] 2014-12-01 15:25:18 -0500
574
In <function>numeric_recv()</>, truncate away any fractional digits
575
that would be hidden according to the value's <literal>dscale</> field
580
A <type>numeric</> value's display scale (<literal>dscale</>) should
581
never be less than the number of nonzero fractional digits; but
582
apparently there's at least one broken client application that
583
transmits binary <type>numeric</> values in which that's true.
584
This leads to strange behavior since the extra digits are taken into
585
account by arithmetic operations even though they aren't printed.
586
The least risky fix seems to be to truncate away such <quote>hidden</>
587
digits on receipt, so that the value is indeed what it prints as.
592
Author: Tom Lane <tgl@sss.pgh.pa.us>
593
Branch: REL9_3_STABLE [bbfdf5d75] 2014-09-23 20:25:36 -0400
594
Branch: REL9_2_STABLE [3359a818c] 2014-09-23 20:25:39 -0400
599
Fix incorrect search for shortest-first regular expression matches
604
Matching would often fail when the number of allowed iterations is
605
limited by a <literal>?</> quantifier or a bound expression.
610
Author: Tom Lane <tgl@sss.pgh.pa.us>
611
Branch: REL9_3_STABLE [7672bbca0] 2014-07-21 22:41:27 -0400
612
Branch: REL9_2_STABLE [f54d97c5e] 2014-07-21 22:41:30 -0400
613
Branch: REL9_1_STABLE [124331b61] 2014-07-21 22:41:33 -0400
614
Branch: REL9_0_STABLE [6e5a39c9e] 2014-07-21 22:41:36 -0400
619
Reject out-of-range numeric timezone specifications (Tom Lane)
623
Simple numeric timezone specifications exceeding +/- 168 hours (one
624
week) would be accepted, but could then cause null-pointer dereference
625
crashes in certain operations. There's no use-case for such large UTC
626
offsets, so reject them.
631
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
632
Branch: REL9_3_STABLE [1aa526f3f] 2014-10-27 10:51:29 +0200
633
Branch: REL9_2_STABLE [604d94d4c] 2014-10-27 10:51:33 +0200
634
Branch: REL9_1_STABLE [4d1c738d1] 2014-10-27 10:51:36 +0200
635
Branch: REL9_0_STABLE [10059c2da] 2014-10-27 10:51:38 +0200
640
Fix bugs in <type>tsquery</> <literal>@></> <type>tsquery</>
641
operator (Heikki Linnakangas)
645
Two different terms would be considered to match if they had the same
646
CRC. Also, if the second operand had more terms than the first, it
647
would be assumed not to be contained in the first; which is wrong
648
since it might contain duplicate terms.
653
Author: Tom Lane <tgl@sss.pgh.pa.us>
654
Branch: REL9_3_STABLE [385f0d98a] 2014-10-23 13:11:34 -0400
655
Branch: REL9_2_STABLE [f09369da8] 2014-10-23 13:11:37 -0400
656
Branch: REL9_1_STABLE [94de3a679] 2014-10-23 13:11:41 -0400
657
Branch: REL9_0_STABLE [21fa26b65] 2014-10-23 13:11:45 -0400
662
Improve ispell dictionary's defenses against bad affix files (Tom Lane)
667
Author: Tom Lane <tgl@sss.pgh.pa.us>
668
Branch: REL9_3_STABLE [5a74ff373] 2014-11-06 20:52:52 -0500
669
Branch: REL9_2_STABLE [0bb318595] 2014-11-06 20:52:57 -0500
670
Branch: REL9_1_STABLE [076688084] 2014-11-06 20:53:02 -0500
671
Branch: REL9_0_STABLE [39493e4d9] 2014-11-06 20:53:07 -0500
676
Allow more than 64K phrases in a thesaurus dictionary (David Boutin)
680
The previous coding could crash on an oversize dictionary, so this was
681
deemed a back-patchable bug fix rather than a feature addition.
686
Author: Peter Eisentraut <peter_e@gmx.net>
687
Branch: master [79af9a1d2] 2015-01-06 23:06:13 -0500
688
Branch: REL9_4_STABLE [6bbf75192] 2015-01-17 22:11:20 -0500
689
Branch: REL9_3_STABLE [e32cb8d0e] 2015-01-17 22:13:27 -0500
690
Branch: REL9_2_STABLE [c8ef5b1ac] 2015-01-17 22:14:21 -0500
691
Branch: REL9_1_STABLE [c975fa471] 2015-01-17 22:37:07 -0500
692
Branch: REL9_0_STABLE [cebb3f032] 2015-01-17 22:37:32 -0500
697
Fix namespace handling in <function>xpath()</> (Ali Akbar)
701
Previously, the <type>xml</> value resulting from
702
an <function>xpath()</> call would not have namespace declarations if
703
the namespace declarations were attached to an ancestor element in the
704
input <type>xml</> value, rather than to the specific element being
705
returned. Propagate the ancestral declaration so that the result is
706
correct when considered in isolation.
711
Author: Tom Lane <tgl@sss.pgh.pa.us>
712
Branch: REL9_3_STABLE [07ab4ec4c] 2014-11-10 15:21:20 -0500
713
Branch: REL9_2_STABLE [19ccaf9d4] 2014-11-10 15:21:26 -0500
718
Ensure that whole-row variables expose nonempty column names
719
to functions that pay attention to column names within composite
724
In some contexts, constructs like <literal>row_to_json(tab.*)</> may
725
not produce the expected column names. This is fixed properly as of
726
9.4; in older branches, just ensure that we produce some nonempty
727
name. (In some cases this will be the underlying table's column name
728
rather than the query-assigned alias that should theoretically be
734
Author: Tom Lane <tgl@sss.pgh.pa.us>
735
Branch: REL9_3_STABLE [c57cdc9c1] 2014-11-22 16:01:12 -0500
736
Branch: REL9_2_STABLE [906599f65] 2014-11-22 16:01:15 -0500
741
Fix mishandling of system columns,
742
particularly <structfield>tableoid</>, in FDW queries (Etsuro Fujita)
747
Author: Tom Lane <tgl@sss.pgh.pa.us>
748
Branch: master [3d660d33a] 2015-01-30 12:30:59 -0500
749
Branch: REL9_4_STABLE [b6a164e5c] 2015-01-30 12:31:08 -0500
750
Branch: REL9_3_STABLE [527ff8baf] 2015-01-30 12:30:43 -0500
755
Fix assorted oversights in range-operator selectivity estimation
760
This patch fixes corner-case <quote>unexpected operator NNNN</> planner
761
errors, and improves the selectivity estimates for some other cases.
766
Author: Tom Lane <tgl@sss.pgh.pa.us>
767
Branch: REL9_3_STABLE [f6abf8f08] 2014-10-26 16:12:29 -0400
768
Branch: REL9_2_STABLE [4586572d7] 2014-10-26 16:12:32 -0400
773
Avoid doing <literal><replaceable>indexed_column</> = ANY
774
(<replaceable>array</>)</literal> as an index qualifier if that leads
775
to an inferior plan (Andrew Gierth)
779
In some cases, <literal>= ANY</> conditions applied to non-first index
780
columns would be done as index conditions even though it would be
781
better to use them as simple filter conditions.
786
Author: Tom Lane <tgl@sss.pgh.pa.us>
787
Branch: REL9_3_STABLE [4e54685d0] 2014-10-20 12:23:48 -0400
792
Fix <quote>variable not found in subplan target list</> planner
793
failure when an inline-able SQL function taking a composite argument
794
is used in a <literal>LATERAL</> subselect and the composite argument
795
is a lateral reference (Tom Lane)
800
Author: Tom Lane <tgl@sss.pgh.pa.us>
801
Branch: REL9_3_STABLE [b2b95de61] 2014-10-01 19:30:30 -0400
802
Branch: REL9_2_STABLE [71b88cf52] 2014-10-01 19:30:34 -0400
803
Branch: REL9_1_STABLE [477023e94] 2014-10-01 19:30:38 -0400
804
Branch: REL9_0_STABLE [288f15b7c] 2014-10-01 19:30:41 -0400
809
Fix planner problems with nested append relations, such as inherited
810
tables within <literal>UNION ALL</> subqueries (Tom Lane)
815
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
816
Branch: REL9_3_STABLE [ef8ac584e] 2014-10-03 14:50:29 +0300
817
Branch: REL9_2_STABLE [8e137b075] 2014-10-03 14:50:40 +0300
818
Branch: REL9_1_STABLE [f270a1611] 2014-10-03 14:50:46 +0300
819
Branch: REL9_0_STABLE [f04b112d5] 2014-10-03 14:50:58 +0300
824
Fail cleanly when a GiST index tuple doesn't fit on a page, rather
825
than going into infinite recursion (Andrew Gierth)
830
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
831
Branch: REL9_3_STABLE [67ed9d531] 2014-10-03 13:01:27 -0300
832
Branch: REL9_2_STABLE [769d6815e] 2014-10-03 13:01:27 -0300
833
Branch: REL9_1_STABLE [06646f52e] 2014-10-03 13:01:27 -0300
834
Branch: REL9_0_STABLE [50a757698] 2014-10-03 13:01:27 -0300
839
Exempt tables that have per-table <varname>cost_limit</>
840
and/or <varname>cost_delay</> settings from autovacuum's global cost
841
balancing rules (Álvaro Herrera)
845
The previous behavior resulted in basically ignoring these per-table
846
settings, which was unintended. Now, a table having such settings
847
will be vacuumed using those settings, independently of what is going
848
on in other autovacuum workers. This may result in heavier total I/O
849
load than before, so such settings should be re-examined for sanity.
854
Author: Tom Lane <tgl@sss.pgh.pa.us>
855
Branch: REL9_3_STABLE [4cbecdaaa] 2014-07-30 14:41:49 -0400
856
Branch: REL9_2_STABLE [c83aed34b] 2014-07-30 14:41:53 -0400
857
Branch: REL9_1_STABLE [f21afe421] 2014-07-30 14:41:58 -0400
858
Branch: REL9_0_STABLE [91b4a881c] 2014-07-30 14:42:12 -0400
863
Avoid wholesale autovacuuming when autovacuum is nominally off
868
Even when autovacuum is nominally off, we will still launch autovacuum
869
worker processes to vacuum tables that are at risk of XID wraparound.
870
However, such a worker process then proceeded to vacuum all tables in
871
the target database, if they met the usual thresholds for
872
autovacuuming. This is at best pretty unexpected; at worst it delays
873
response to the wraparound threat. Fix it so that if autovacuum is
874
turned off, workers <emphasis>only</> do anti-wraparound vacuums and
880
Author: Andres Freund <andres@anarazel.de>
881
Branch: REL9_3_STABLE [2c3ebfd1a] 2014-11-15 01:21:07 +0100
882
Branch: REL9_2_STABLE [ea8b3833e] 2014-11-15 01:21:45 +0100
883
Branch: REL9_1_STABLE [d85b646d0] 2014-11-15 01:22:32 +0100
884
Author: Andres Freund <andres@anarazel.de>
885
Branch: REL9_3_STABLE [672b43e68] 2014-11-15 01:21:02 +0100
886
Branch: REL9_2_STABLE [c5baa708f] 2014-11-15 01:21:40 +0100
887
Branch: REL9_1_STABLE [fde9994bc] 2014-11-15 01:22:32 +0100
888
Author: Andres Freund <andres@anarazel.de>
889
Branch: REL9_3_STABLE [c7299d32f] 2014-11-15 01:20:29 +0100
890
Branch: REL9_2_STABLE [86673a44a] 2014-11-15 01:21:30 +0100
891
Branch: REL9_1_STABLE [b0a48e996] 2014-11-15 01:22:32 +0100
896
During crash recovery, ensure that unlogged relations are rewritten as
897
empty and are synced to disk before recovery is considered complete
898
(Abhijit Menon-Sen, Andres Freund)
902
This prevents scenarios in which unlogged relations might contain
903
garbage data following database crash recovery.
908
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
909
Branch: REL9_3_STABLE [861d3aa43] 2014-11-13 20:01:55 +0200
910
Branch: REL9_2_STABLE [7eab804c2] 2014-11-13 20:01:18 +0200
911
Branch: REL9_1_STABLE [5f1d931cf] 2014-11-13 20:01:09 +0200
912
Branch: REL9_0_STABLE [681dbe7d4] 2014-11-13 20:00:51 +0200
917
Fix race condition between hot standby queries and replaying a
918
full-page image (Heikki Linnakangas)
922
This mistake could result in transient errors in queries being
923
executed in hot standby.
928
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
929
Branch: REL9_3_STABLE [a2a718b22] 2014-07-29 11:57:52 +0300
930
Branch: REL9_2_STABLE [1578d13dc] 2014-07-29 11:58:01 +0300
931
Branch: REL9_1_STABLE [de88ec6bf] 2014-07-29 11:58:09 +0300
932
Branch: REL9_0_STABLE [804983961] 2014-07-29 11:58:17 +0300
937
Fix several cases where recovery logic improperly ignored WAL records
938
for <literal>COMMIT/ABORT PREPARED</> (Heikki Linnakangas)
942
The most notable oversight was
943
that <varname>recovery_min_apply_delay</> failed to delay application
944
of a two-phase commit.
949
Author: Fujii Masao <fujii@postgresql.org>
950
Branch: REL9_3_STABLE [d45cd9e19] 2014-10-23 16:22:46 +0900
951
Branch: REL9_2_STABLE [f904e9afd] 2014-10-23 16:31:44 +0900
956
Prevent latest WAL file from being archived a second time at completion
957
of crash recovery (Fujii Masao)
962
Author: Fujii Masao <fujii@postgresql.org>
963
Branch: REL9_3_STABLE [3a3b7e316] 2014-11-06 21:25:18 +0900
964
Branch: REL9_2_STABLE [38eb5d9e8] 2014-11-06 21:25:45 +0900
965
Branch: REL9_1_STABLE [4e7468074] 2014-11-06 21:26:15 +0900
966
Branch: REL9_0_STABLE [83c7bfb9a] 2014-11-06 21:26:21 +0900
971
Avoid creating unnecessary <filename>.ready</> marker files for
972
timeline history files (Fujii Masao)
977
Author: Fujii Masao <fujii@postgresql.org>
978
Branch: REL9_3_STABLE [52eed3d42] 2014-09-05 02:19:29 +0900
979
Branch: REL9_2_STABLE [78b1228ef] 2014-09-05 02:19:45 +0900
980
Branch: REL9_1_STABLE [81bffe63c] 2014-09-05 02:19:50 +0900
981
Branch: REL9_0_STABLE [857a5d6b5] 2014-09-05 02:19:57 +0900
986
Fix possible null pointer dereference when an empty prepared statement
987
is used and the <varname>log_statement</> setting is <literal>mod</>
988
or <literal>ddl</> (Fujii Masao)
993
Author: Tom Lane <tgl@sss.pgh.pa.us>
994
Branch: master [75b48e1ff] 2015-01-19 23:01:33 -0500
995
Branch: REL9_4_STABLE [3387cbbcb] 2015-01-19 23:01:36 -0500
996
Branch: REL9_3_STABLE [19794e997] 2015-01-19 23:01:39 -0500
997
Branch: REL9_2_STABLE [33b723538] 2015-01-19 23:01:41 -0500
998
Branch: REL9_1_STABLE [b87c1dcef] 2015-01-19 23:01:44 -0500
999
Branch: REL9_0_STABLE [a1a8d0249] 2015-01-19 23:01:46 -0500
1004
Change <quote>pgstat wait timeout</> warning message to be LOG level,
1005
and rephrase it to be more understandable (Tom Lane)
1009
This message was originally thought to be essentially a can't-happen
1010
case, but it occurs often enough on our slower buildfarm members to be
1011
a nuisance. Reduce it to LOG level, and expend a bit more effort on
1012
the wording: it now reads <quote>using stale statistics instead of
1013
current ones because stats collector is not responding</>.
1018
Author: Andres Freund <andres@anarazel.de>
1019
Branch: REL9_3_STABLE [cbd9619ac] 2014-10-01 14:34:06 +0200
1024
Fix possible corruption of postmaster's list of dynamic background
1025
workers (Andres Freund)
1030
Author: Andres Freund <andres@anarazel.de>
1031
Branch: REL9_3_STABLE [27ef6b653] 2014-09-09 23:37:33 +0200
1032
Branch: REL9_2_STABLE [d0b7ffc0f] 2014-09-09 23:37:50 +0200
1033
Branch: REL9_1_STABLE [5af508f66] 2014-09-09 23:45:07 +0200
1034
Branch: REL9_0_STABLE [f25e89601] 2014-09-09 23:48:03 +0200
1039
Fix SPARC spinlock implementation to ensure correctness if the CPU is
1040
being run in a non-TSO coherency mode, as some non-Solaris kernels do
1046
Author: Noah Misch <noah@leadboat.com>
1047
Branch: master [894459e59] 2015-01-07 22:35:44 -0500
1048
Branch: REL9_4_STABLE [83fb1ca5c] 2015-01-07 22:36:35 -0500
1049
Branch: REL9_3_STABLE [1a366d51e] 2015-01-07 22:40:40 -0500
1050
Branch: REL9_2_STABLE [5ca4e444c] 2015-01-07 22:41:49 -0500
1051
Branch: REL9_1_STABLE [8dc83104e] 2015-01-07 22:42:42 -0500
1052
Branch: REL9_0_STABLE [2e4946169] 2015-01-07 22:46:20 -0500
1057
Warn if OS X's <function>setlocale()</> starts an unwanted extra
1058
thread inside the postmaster (Noah Misch)
1063
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
1064
Branch: REL9_3_STABLE [08cd4d9a6] 2014-11-25 17:39:00 +0200
1065
Branch: REL9_2_STABLE [9b468bcec] 2014-11-25 17:39:04 +0200
1066
Branch: REL9_1_STABLE [95be34362] 2014-11-25 17:39:07 +0200
1067
Branch: REL9_0_STABLE [9880fea4f] 2014-11-25 17:39:09 +0200
1072
Fix processing of repeated <literal>dbname</> parameters
1073
in <function>PQconnectdbParams()</> (Alex Shulgin)
1077
Unexpected behavior ensued if the first occurrence
1078
of <literal>dbname</> contained a connection string or URI to be
1084
Author: Tom Lane <tgl@sss.pgh.pa.us>
1085
Branch: REL9_3_STABLE [52ef33f72] 2014-10-22 18:41:51 -0400
1086
Branch: REL9_2_STABLE [6fa31d8d1] 2014-10-22 18:41:54 -0400
1087
Branch: REL9_1_STABLE [98144378c] 2014-10-22 18:41:57 -0400
1088
Branch: REL9_0_STABLE [ac6e87537] 2014-10-22 18:42:01 -0400
1093
Ensure that <application>libpq</> reports a suitable error message on
1094
unexpected socket EOF (Marko Tiikkaja, Tom Lane)
1098
Depending on kernel behavior, <application>libpq</> might return an
1099
empty error string rather than something useful when the server
1100
unexpectedly closed the socket.
1105
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
1106
Branch: REL9_3_STABLE [1325b239b] 2014-10-29 14:40:47 +0200
1107
Branch: REL9_2_STABLE [1a27fbd07] 2014-10-29 14:39:10 +0200
1108
Branch: REL9_1_STABLE [8f7bd8e91] 2014-10-29 14:36:19 +0200
1109
Branch: REL9_0_STABLE [49ef4eba2] 2014-10-29 14:35:39 +0200
1114
Clear any old error message during <function>PQreset()</>
1115
(Heikki Linnakangas)
1119
If <function>PQreset()</> is called repeatedly, and the connection
1120
cannot be re-established, error messages from the failed connection
1121
attempts kept accumulating in the <structname>PGconn</>'s error
1127
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
1128
Branch: REL9_3_STABLE [d3b162a3d] 2014-11-25 14:10:29 +0200
1129
Branch: REL9_2_STABLE [abcab2a64] 2014-11-25 14:10:43 +0200
1130
Branch: REL9_1_STABLE [5053ad206] 2014-11-25 14:10:48 +0200
1131
Branch: REL9_0_STABLE [1f3517039] 2014-11-25 14:10:54 +0200
1136
Properly handle out-of-memory conditions while parsing connection
1137
options in <application>libpq</> (Alex Shulgin, Heikki Linnakangas)
1142
Author: Tom Lane <tgl@sss.pgh.pa.us>
1143
Branch: REL9_3_STABLE [d3cfe20c6] 2014-10-06 21:23:35 -0400
1144
Branch: REL9_2_STABLE [b513205bc] 2014-10-06 21:23:39 -0400
1145
Branch: REL9_1_STABLE [037b912ec] 2014-10-06 21:23:45 -0400
1146
Branch: REL9_0_STABLE [d9a1e9de5] 2014-10-06 21:23:50 -0400
1151
Fix array overrun in <application>ecpg</>'s version
1152
of <function>ParseDateTime()</> (Michael Paquier)
1157
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
1158
Branch: REL9_3_STABLE [2df66f01a] 2014-12-05 14:31:51 +0200
1159
Branch: REL9_2_STABLE [2b53d583d] 2014-12-05 14:31:45 +0200
1160
Branch: REL9_1_STABLE [729202754] 2014-12-05 14:31:37 +0200
1161
Branch: REL9_0_STABLE [d67be559e] 2014-12-05 14:30:55 +0200
1166
In <application>initdb</>, give a clearer error message if a password
1167
file is specified but is empty (Mats Erik Andersson)
1172
Author: Tom Lane <tgl@sss.pgh.pa.us>
1173
Branch: REL9_3_STABLE [b0fd5c552] 2014-09-08 16:09:52 -0400
1174
Branch: REL9_2_STABLE [886b58b47] 2014-09-08 16:09:56 -0400
1175
Branch: REL9_1_STABLE [440fcc568] 2014-09-08 16:10:01 -0400
1176
Branch: REL9_0_STABLE [44c518328] 2014-09-08 16:10:05 -0400
1181
Fix <application>psql</>'s <command>\s</> command to work nicely with
1182
libedit, and add pager support (Stepan Rutz, Tom Lane)
1186
When using libedit rather than readline, <command>\s</> printed the
1187
command history in a fairly unreadable encoded format, and on recent
1188
libedit versions might fail altogether. Fix that by printing the
1189
history ourselves rather than having the library do it. A pleasant
1190
side-effect is that the pager is used if appropriate.
1194
This patch also fixes a bug that caused newline encoding to be applied
1195
inconsistently when saving the command history with libedit.
1196
Multiline history entries written by older <application>psql</>
1197
versions will be read cleanly with this patch, but perhaps not
1198
vice versa, depending on the exact libedit versions involved.
1203
Author: Tom Lane <tgl@sss.pgh.pa.us>
1204
Branch: master [28551797a] 2014-12-31 12:18:50 -0500
1205
Branch: REL9_4_STABLE [c35249939] 2014-12-31 12:16:57 -0500
1206
Branch: REL9_3_STABLE [7582cce56] 2014-12-31 12:17:00 -0500
1207
Branch: REL9_2_STABLE [64c506535] 2014-12-31 12:17:04 -0500
1208
Branch: REL9_1_STABLE [1773e0702] 2014-12-31 12:17:08 -0500
1209
Branch: REL9_0_STABLE [2600e4436] 2014-12-31 12:17:12 -0500
1214
Improve consistency of parsing of <application>psql</>'s special
1215
variables (Tom Lane)
1219
Allow variant spellings of <literal>on</> and <literal>off</> (such
1220
as <literal>1</>/<literal>0</>) for <literal>ECHO_HIDDEN</>
1221
and <literal>ON_ERROR_ROLLBACK</>. Report a warning for unrecognized
1222
values for <literal>COMP_KEYWORD_CASE</>, <literal>ECHO</>,
1223
<literal>ECHO_HIDDEN</>, <literal>HISTCONTROL</>,
1224
<literal>ON_ERROR_ROLLBACK</>, and <literal>VERBOSITY</>. Recognize
1225
all values for all these variables case-insensitively; previously
1226
there was a mishmash of case-sensitive and case-insensitive behaviors.
1231
Author: Fujii Masao <fujii@postgresql.org>
1232
Branch: REL9_3_STABLE [4b1953079] 2014-11-28 02:44:40 +0900
1237
Make <application>psql</>'s <command>\watch</> command display
1238
nulls as specified by <command>\pset null</> (Fujii Masao)
1243
Author: Stephen Frost <sfrost@snowman.net>
1244
Branch: REL9_3_STABLE [7ec399094] 2014-09-12 11:24:28 -0400
1245
Branch: REL9_2_STABLE [5d63f2159] 2014-09-12 11:24:32 -0400
1246
Branch: REL9_1_STABLE [4d96e93cb] 2014-09-12 11:24:36 -0400
1247
Branch: REL9_0_STABLE [1f89fc218] 2014-09-12 11:24:39 -0400
1252
Fix <application>psql</>'s expanded-mode display to work
1253
consistently when using <literal>border</> = 3
1254
and <literal>linestyle</> = <literal>ascii</> or <literal>unicode</>
1260
Author: Tom Lane <tgl@sss.pgh.pa.us>
1261
Branch: master [adfc157dd] 2015-01-05 19:27:04 -0500
1262
Branch: REL9_4_STABLE [c99e41f68] 2015-01-05 19:27:06 -0500
1263
Branch: REL9_3_STABLE [bb1e2426b] 2015-01-05 19:27:09 -0500
1268
Fix <application>pg_dump</> to handle comments on event triggers
1269
without failing (Tom Lane)
1274
Author: Kevin Grittner <kgrittn@postgresql.org>
1275
Branch: master [cff1bd2a3] 2015-01-30 08:57:24 -0600
1276
Branch: REL9_4_STABLE [cb0168528] 2015-01-30 08:57:53 -0600
1277
Branch: REL9_3_STABLE [cc609c46f] 2015-01-30 09:01:36 -0600
1282
Allow parallel <application>pg_dump</> to
1283
use <option>--serializable-deferrable</> (Kevin Grittner)
1288
Author: Tom Lane <tgl@sss.pgh.pa.us>
1289
Branch: REL9_3_STABLE [51fc61334] 2014-07-25 19:48:48 -0400
1290
Branch: REL9_2_STABLE [a6c567437] 2014-07-25 19:48:51 -0400
1291
Branch: REL9_1_STABLE [40c333c39] 2014-07-25 19:48:54 -0400
1296
Improve performance of <application>pg_dump</> when the database
1297
contains many instances of multiple dependency paths between the same
1298
two objects (Tom Lane)
1303
Author: Tom Lane <tgl@sss.pgh.pa.us>
1304
Branch: REL9_3_STABLE [9fc887121] 2014-11-13 18:19:32 -0500
1305
Branch: REL9_2_STABLE [3c5ce5102] 2014-11-13 18:19:35 -0500
1310
Fix <application>pg_dumpall</> to restore its ability to dump from
1311
pre-8.1 servers (Gilles Darold)
1316
Author: Robert Haas <rhaas@postgresql.org>
1317
Branch: REL9_3_STABLE [d72ecc91c] 2014-09-26 11:23:43 -0400
1318
Branch: REL9_2_STABLE [a97c8c393] 2014-09-26 11:25:57 -0400
1319
Branch: REL9_1_STABLE [d1844c21b] 2014-09-26 11:36:25 -0400
1320
Branch: REL9_0_STABLE [bbe3c069a] 2014-09-26 11:43:56 -0400
1325
Fix possible deadlock during parallel restore of a schema-only dump
1326
(Robert Haas, Tom Lane)
1331
Author: Tom Lane <tgl@sss.pgh.pa.us>
1332
Branch: REL9_3_STABLE [9a540c1ef] 2014-10-17 12:49:06 -0400
1333
Branch: REL9_2_STABLE [787e20bd4] 2014-10-17 12:49:09 -0400
1334
Branch: REL9_1_STABLE [0c9391e52] 2014-10-17 12:49:11 -0400
1335
Branch: REL9_0_STABLE [31021e7ba] 2014-10-17 12:49:15 -0400
1340
Fix core dump in <literal>pg_dump --binary-upgrade</> on zero-column
1341
composite type (Rushabh Lathia)
1346
Author: Andres Freund <andres@anarazel.de>
1347
Branch: REL9_3_STABLE [26a4e0ed7] 2014-11-15 01:21:11 +0100
1352
Fix failure to fsync tables in nondefault tablespaces
1353
during <application>pg_upgrade</> (Abhijit Menon-Sen, Andres Freund)
1357
With an operating system crash and some bad luck, this could result in
1358
data loss during an upgrade.
1363
Author: Bruce Momjian <bruce@momjian.us>
1364
Branch: REL9_3_STABLE [fca9f349b] 2014-08-07 14:56:13 -0400
1369
In <application>pg_upgrade</>, cope with cases where the new cluster
1370
creates a TOAST table for a table that didn't previously have one
1375
Previously this could result in failures due to OID conflicts.
1380
Author: Bruce Momjian <bruce@momjian.us>
1381
Branch: REL9_3_STABLE [24ae44914] 2014-08-04 11:45:45 -0400
1386
In <application>pg_upgrade</>, don't try to
1387
set <literal>autovacuum_multixact_freeze_max_age</> for the old cluster
1392
This could result in failure because not all 9.3.X versions have that
1393
parameter. Fortunately, we don't actually need to set it at all.
1398
Author: Bruce Momjian <bruce@momjian.us>
1399
Branch: REL9_3_STABLE [5724f491d] 2014-09-11 18:39:46 -0400
1404
In <application>pg_upgrade</>, preserve the transaction ID epoch
1409
This oversight did not bother <productname>PostgreSQL</> proper,
1410
but could confuse some external replication tools.
1415
Author: Andres Freund <andres@anarazel.de>
1416
Branch: master [2c0a48589] 2015-01-03 20:54:12 +0100
1417
Branch: REL9_4_STABLE [90e4a2bf9] 2015-01-03 20:54:13 +0100
1418
Branch: REL9_3_STABLE [f6cea4502] 2015-01-03 20:54:13 +0100
1419
Branch: REL9_2_STABLE [f961ad479] 2015-01-03 20:54:13 +0100
1420
Branch: REL9_1_STABLE [2a0bfa4d6] 2015-01-03 20:54:13 +0100
1425
Prevent WAL files created by <literal>pg_basebackup -x/-X</> from
1426
being archived again when the standby is promoted (Andres Freund)
1431
Author: Fujii Masao <fujii@postgresql.org>
1432
Branch: REL9_3_STABLE [9747a9898] 2014-08-02 15:19:45 +0900
1437
Fix memory leak in <application>pg_receivexlog</> (Fujii Masao)
1442
Author: Fujii Masao <fujii@postgresql.org>
1443
Branch: REL9_3_STABLE [39217ce41] 2014-08-02 14:59:10 +0900
1448
Fix unintended suppression of <application>pg_receivexlog</> verbose
1449
messages (Fujii Masao)
1454
Author: Tom Lane <tgl@sss.pgh.pa.us>
1455
Branch: REL9_3_STABLE [9474c9d81] 2014-09-19 13:19:02 -0400
1456
Branch: REL9_2_STABLE [5ff8c2d7d] 2014-09-19 13:19:05 -0400
1461
Fix failure of <filename>contrib/auto_explain</> to print per-node
1462
timing information when doing <command>EXPLAIN ANALYZE</> (Tom Lane)
1467
Author: Tom Lane <tgl@sss.pgh.pa.us>
1468
Branch: REL9_3_STABLE [0ad403c98] 2014-08-28 18:21:14 -0400
1469
Branch: REL9_2_STABLE [f3998521f] 2014-08-28 18:21:17 -0400
1470
Branch: REL9_1_STABLE [9807c8220] 2014-08-28 18:21:20 -0400
1475
Fix upgrade-from-unpackaged script for <filename>contrib/citext</>
1481
Author: Tom Lane <tgl@sss.pgh.pa.us>
1482
Branch: REL9_3_STABLE [f44290b7b] 2014-11-04 16:54:59 -0500
1487
Avoid integer overflow and buffer overrun
1488
in <filename>contrib/hstore</>'s <function>hstore_to_json()</>
1489
(Heikki Linnakangas)
1494
Author: Andrew Dunstan <andrew@dunslane.net>
1495
Branch: REL9_3_STABLE [55c880797] 2014-12-01 11:44:48 -0500
1500
Fix recognition of numbers in <function>hstore_to_json_loose()</>,
1501
so that JSON numbers and strings are correctly distinguished
1507
Author: Tom Lane <tgl@sss.pgh.pa.us>
1508
Branch: REL9_3_STABLE [f59c8eff7] 2014-07-22 11:45:53 -0400
1509
Branch: REL9_2_STABLE [810f0d2a2] 2014-07-22 11:45:57 -0400
1510
Branch: REL9_1_STABLE [3c5232ae8] 2014-07-22 11:46:00 -0400
1511
Branch: REL9_0_STABLE [9dc2a3fd0] 2014-07-22 11:46:04 -0400
1516
Fix block number checking
1517
in <filename>contrib/pageinspect</>'s <function>get_raw_page()</>
1522
The incorrect checking logic could prevent access to some pages in
1523
non-main relation forks.
1528
Author: Tom Lane <tgl@sss.pgh.pa.us>
1529
Branch: REL9_3_STABLE [419de696a] 2014-11-11 17:22:38 -0500
1530
Branch: REL9_2_STABLE [4a9710e6e] 2014-11-11 17:22:44 -0500
1531
Branch: REL9_1_STABLE [4ddd9e72f] 2014-11-11 17:22:51 -0500
1532
Branch: REL9_0_STABLE [ef5a3b957] 2014-11-11 17:22:58 -0500
1537
Fix <filename>contrib/pgcrypto</>'s <function>pgp_sym_decrypt()</>
1538
to not fail on messages whose length is 6 less than a power of 2
1544
Author: Robert Haas <rhaas@postgresql.org>
1545
Branch: REL9_3_STABLE [8cf825974] 2014-11-19 12:14:22 -0500
1546
Branch: REL9_2_STABLE [57ce74661] 2014-11-19 12:20:47 -0500
1547
Branch: REL9_1_STABLE [a855c90a7] 2014-11-19 12:26:06 -0500
1552
Fix file descriptor leak in <filename>contrib/pg_test_fsync</>
1557
This could cause failure to remove temporary files on Windows.
1562
Author: Tom Lane <tgl@sss.pgh.pa.us>
1563
Branch: master [37507962c] 2015-01-29 20:18:33 -0500
1564
Branch: REL9_4_STABLE [202621d04] 2015-01-29 20:18:37 -0500
1565
Branch: REL9_3_STABLE [53ae24692] 2015-01-29 20:18:40 -0500
1566
Branch: REL9_2_STABLE [66cc74680] 2015-01-29 20:18:42 -0500
1567
Branch: REL9_1_STABLE [290c2daad] 2015-01-29 20:18:44 -0500
1568
Branch: REL9_0_STABLE [dc9a506e6] 2015-01-29 20:18:46 -0500
1573
Handle unexpected query results, especially NULLs, safely in
1574
<filename>contrib/tablefunc</>'s <function>connectby()</>
1579
<function>connectby()</> previously crashed if it encountered a NULL
1580
key value. It now prints that row but doesn't recurse further.
1585
Author: Tom Lane <tgl@sss.pgh.pa.us>
1586
Branch: REL9_3_STABLE [c393847a1] 2014-11-27 11:12:51 -0500
1587
Branch: REL9_2_STABLE [a1cd04cd0] 2014-11-27 11:12:55 -0500
1588
Branch: REL9_1_STABLE [168636a99] 2014-11-27 11:12:59 -0500
1589
Branch: REL9_0_STABLE [6a694bbab] 2014-11-27 11:13:03 -0500
1594
Avoid a possible crash in <filename>contrib/xml2</>'s
1595
<function>xslt_process()</> (Mark Simonetti)
1599
<application>libxslt</> seems to have an undocumented dependency on
1600
the order in which resources are freed; reorder our calls to avoid a
1606
Author: Tom Lane <tgl@sss.pgh.pa.us>
1607
Branch: REL9_3_STABLE [0247935c7] 2014-11-05 11:34:19 -0500
1608
Branch: REL9_2_STABLE [0ef754cad] 2014-11-05 11:34:22 -0500
1609
Branch: REL9_1_STABLE [7225abf00] 2014-11-05 11:34:25 -0500
1614
Mark some <filename>contrib</> I/O functions with correct volatility
1615
properties (Tom Lane)
1619
The previous over-conservative marking was immaterial in normal use,
1620
but could cause optimization problems or rejection of valid index
1621
expression definitions. Since the consequences are not large, we've
1622
just adjusted the function definitions in the extension modules'
1623
scripts, without changing version numbers.
1628
Author: Tom Lane <tgl@sss.pgh.pa.us>
1629
Branch: master [a59ee8819] 2015-01-30 13:05:30 -0500
1630
Branch: REL9_4_STABLE [70da7aeba] 2015-01-30 13:04:59 -0500
1631
Branch: REL9_3_STABLE [f08cf8ad9] 2015-01-30 13:05:01 -0500
1632
Branch: REL9_2_STABLE [a97dfdfd9] 2015-01-30 13:05:04 -0500
1633
Branch: REL9_1_STABLE [8f51c432c] 2015-01-30 13:05:07 -0500
1634
Branch: REL9_0_STABLE [7c41a32b3] 2015-01-30 13:05:09 -0500
1635
Author: Tom Lane <tgl@sss.pgh.pa.us>
1636
Branch: REL9_3_STABLE [8824bae87] 2014-11-18 13:28:13 -0500
1637
Author: Robert Haas <rhaas@postgresql.org>
1638
Branch: master [0b49642b9] 2015-01-15 09:26:03 -0500
1639
Branch: REL9_4_STABLE [7b65f194e] 2015-01-15 09:29:41 -0500
1640
Branch: REL9_3_STABLE [ebbef4f39] 2015-01-15 09:29:55 -0500
1641
Branch: REL9_2_STABLE [d452bfd1b] 2015-01-15 09:42:21 -0500
1642
Branch: REL9_1_STABLE [151fb75b0] 2015-01-15 09:42:33 -0500
1643
Branch: REL9_0_STABLE [0a67c0018] 2015-01-15 09:42:47 -0500
1644
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
1645
Branch: master [e37d474f9] 2015-01-13 14:33:05 +0200
1646
Branch: REL9_4_STABLE [4ebb3494e] 2015-01-13 16:01:04 +0200
1647
Author: Andres Freund <andres@anarazel.de>
1648
Branch: master [8cadeb792] 2015-01-04 15:44:49 +0100
1649
Branch: REL9_4_STABLE [7ced1b6c5] 2015-01-04 15:52:52 +0100
1650
Branch: REL9_3_STABLE [a68b8aec7] 2015-01-04 15:53:08 +0100
1651
Branch: REL9_2_STABLE [6f9b84a40] 2015-01-04 15:55:00 +0100
1652
Author: Andres Freund <andres@anarazel.de>
1653
Branch: master [58bc4747b] 2015-01-04 15:35:46 +0100
1654
Branch: REL9_4_STABLE [2d8411a0a] 2015-01-04 15:35:46 +0100
1655
Branch: REL9_3_STABLE [d33f36f16] 2015-01-04 15:35:47 +0100
1656
Branch: REL9_2_STABLE [029e41afd] 2015-01-04 15:35:47 +0100
1657
Branch: REL9_1_STABLE [39cdf365a] 2015-01-04 15:35:47 +0100
1658
Branch: REL9_0_STABLE [17797e18d] 2015-01-04 15:35:48 +0100
1659
Author: Andres Freund <andres@anarazel.de>
1660
Branch: master [0398ece4c] 2015-01-04 14:36:21 +0100
1661
Branch: REL9_4_STABLE [ff7d46b85] 2015-01-04 14:36:21 +0100
1662
Branch: REL9_3_STABLE [ec14f1601] 2015-01-04 14:36:22 +0100
1663
Branch: REL9_2_STABLE [f4060db11] 2015-01-04 14:36:22 +0100
1664
Author: Tatsuo Ishii <ishii@postgresql.org>
1665
Branch: master [3b5a89c48] 2014-12-30 20:33:01 +0900
1666
Branch: REL9_4_STABLE [458e8bc65] 2014-12-30 20:27:26 +0900
1667
Branch: REL9_3_STABLE [ed0e03283] 2014-12-30 20:20:56 +0900
1668
Branch: REL9_2_STABLE [4db7eaae0] 2014-12-30 19:59:26 +0900
1669
Branch: REL9_1_STABLE [4c136b0b6] 2014-12-30 19:48:53 +0900
1670
Branch: REL9_0_STABLE [9b74f3574] 2014-12-30 19:37:55 +0900
1671
Author: Tom Lane <tgl@sss.pgh.pa.us>
1672
Branch: master [66709133c] 2014-12-16 15:35:33 -0500
1673
Branch: REL9_4_STABLE [383d224a0] 2014-12-16 15:35:36 -0500
1674
Branch: REL9_3_STABLE [53960e7eb] 2014-12-16 15:35:40 -0500
1675
Branch: REL9_2_STABLE [e92c67ddc] 2014-12-16 15:35:43 -0500
1676
Branch: REL9_1_STABLE [5c784d96a] 2014-12-16 15:35:46 -0500
1677
Branch: REL9_0_STABLE [a2969bd72] 2014-12-16 15:35:49 -0500
1678
Author: Tom Lane <tgl@sss.pgh.pa.us>
1679
Branch: master [d38e8d30c] 2014-12-16 13:31:42 -0500
1680
Branch: REL9_4_STABLE [6c75384ee] 2014-12-16 13:31:57 -0500
1681
Branch: REL9_3_STABLE [3b750ec15] 2014-12-16 13:32:02 -0500
1682
Branch: REL9_2_STABLE [5b2c8f04a] 2014-12-16 13:32:15 -0500
1683
Branch: REL9_1_STABLE [926da211a] 2014-12-16 13:32:25 -0500
1684
Branch: REL9_0_STABLE [961df1853] 2014-12-16 13:32:38 -0500
1685
Author: Tom Lane <tgl@sss.pgh.pa.us>
1686
Branch: master [586dd5d6a] 2015-01-24 13:05:42 -0500
1687
Branch: REL9_4_STABLE [d51d4ff31] 2015-01-24 13:05:45 -0500
1688
Branch: REL9_3_STABLE [7240f9200] 2015-01-24 13:05:49 -0500
1689
Branch: REL9_2_STABLE [502e5f9c3] 2015-01-24 13:05:53 -0500
1690
Branch: REL9_1_STABLE [b00a08859] 2015-01-24 13:05:56 -0500
1691
Branch: REL9_0_STABLE [3a3ee655c] 2015-01-24 13:05:58 -0500
1696
Numerous cleanups of warnings from Coverity static code analyzer
1697
(Andres Freund, Tatsuo Ishii, Marko Kreen, Tom Lane, Michael Paquier)
1701
These changes are mostly cosmetic but in some cases fix corner-case
1702
bugs, for example a crash rather than a proper error report after an
1703
out-of-memory failure. None are believed to represent security
1709
Author: Robert Haas <rhaas@postgresql.org>
1710
Branch: REL9_3_STABLE [05c0059b3] 2014-07-30 12:10:20 -0400
1715
Fix setup of background workers in EXEC_BACKEND builds, eg Windows
1721
Author: Noah Misch <noah@leadboat.com>
1722
Branch: REL9_3_STABLE [07115248f] 2014-07-22 11:01:41 -0400
1723
Branch: REL9_2_STABLE [cec0c2182] 2014-07-22 11:01:51 -0400
1724
Branch: REL9_1_STABLE [81af4185a] 2014-07-22 11:02:00 -0400
1725
Branch: REL9_0_STABLE [4c6d0abde] 2014-07-22 11:02:25 -0400
1730
Detect incompatible OpenLDAP versions during build (Noah Misch)
1734
With OpenLDAP versions 2.4.24 through 2.4.31,
1735
inclusive, <productname>PostgreSQL</> backends can crash at exit.
1736
Raise a warning during <application>configure</> based on the
1737
compile-time OpenLDAP version number, and test the crashing scenario
1738
in the <filename>contrib/dblink</> regression test.
1743
Author: Noah Misch <noah@leadboat.com>
1744
Branch: REL9_3_STABLE [318fe2321] 2014-08-18 23:01:04 -0400
1745
Branch: REL9_2_STABLE [ebd4d9cdd] 2014-08-18 23:01:09 -0400
1746
Branch: REL9_1_STABLE [ba72fc054] 2014-08-18 23:01:13 -0400
1747
Branch: REL9_0_STABLE [e6841c4d6] 2014-08-18 23:01:23 -0400
1752
In non-MSVC Windows builds, ensure <filename>libpq.dll</> is installed
1753
with execute permissions (Noah Misch)
1758
Author: Tom Lane <tgl@sss.pgh.pa.us>
1759
Branch: master [aa719391d] 2015-01-19 23:44:19 -0500
1760
Branch: REL9_4_STABLE [3de9f22ac] 2015-01-19 23:44:22 -0500
1761
Branch: REL9_3_STABLE [1681e2f74] 2015-01-19 23:44:24 -0500
1762
Branch: REL9_2_STABLE [89b6a19e1] 2015-01-19 23:44:28 -0500
1763
Branch: REL9_1_STABLE [f4f522deb] 2015-01-19 23:44:30 -0500
1764
Branch: REL9_0_STABLE [338ff75fc] 2015-01-19 23:44:33 -0500
1769
Make <application>pg_regress</> remove any temporary installation it
1770
created upon successful exit (Tom Lane)
1774
This results in a very substantial reduction in disk space usage
1775
during <literal>make check-world</>, since that sequence involves
1776
creation of numerous temporary installations.
1781
Author: Tom Lane <tgl@sss.pgh.pa.us>
1782
Branch: REL9_3_STABLE [137e7c164] 2014-10-16 15:22:17 -0400
1783
Branch: REL9_2_STABLE [7c67b9365] 2014-10-16 15:22:20 -0400
1784
Branch: REL9_1_STABLE [2784b68b3] 2014-10-16 15:22:23 -0400
1785
Branch: REL9_0_STABLE [870a980aa] 2014-10-16 15:22:26 -0400
1790
Support time zone abbreviations that change UTC offset from time to
1795
Previously, <productname>PostgreSQL</> assumed that the UTC offset
1796
associated with a time zone abbreviation (such as <literal>EST</>)
1797
never changes in the usage of any particular locale. However this
1798
assumption fails in the real world, so introduce the ability for a
1799
zone abbreviation to represent a UTC offset that sometimes changes.
1800
Update the zone abbreviation definition files to make use of this
1801
feature in timezone locales that have changed the UTC offset of their
1802
abbreviations since 1970 (according to the IANA timezone database).
1803
In such timezones, <productname>PostgreSQL</> will now associate the
1804
correct UTC offset with the abbreviation depending on the given date.
1809
Author: Tom Lane <tgl@sss.pgh.pa.us>
1810
Branch: REL9_3_STABLE [9701f238b] 2014-10-03 17:44:56 -0400
1811
Branch: REL9_2_STABLE [d7d546bbc] 2014-10-03 17:44:59 -0400
1812
Branch: REL9_1_STABLE [252af79d9] 2014-10-03 17:45:03 -0400
1813
Branch: REL9_0_STABLE [cc7bad30c] 2014-10-03 17:45:07 -0400
1814
Author: Tom Lane <tgl@sss.pgh.pa.us>
1815
Branch: REL9_3_STABLE [0190f0a76] 2014-12-24 16:35:40 -0500
1816
Branch: REL9_2_STABLE [5c8665892] 2014-12-24 16:35:44 -0500
1817
Branch: REL9_1_STABLE [310597e31] 2014-12-24 16:35:48 -0500
1818
Branch: REL9_0_STABLE [8b70023af] 2014-12-24 16:35:54 -0500
1823
Update time zone abbreviations lists (Tom Lane)
1827
Add CST (China Standard Time) to our lists.
1828
Remove references to ADT as <quote>Arabia Daylight Time</>, an
1829
abbreviation that's been out of use since 2007; therefore, claiming
1830
there is a conflict with <quote>Atlantic Daylight Time</> doesn't seem
1832
Fix entirely incorrect GMT offsets for CKT (Cook Islands), FJT, and FJST
1833
(Fiji); we didn't even have them on the proper side of the date line.
1838
Author: Tom Lane <tgl@sss.pgh.pa.us>
1839
Branch: REL9_3_STABLE [8470cd473] 2015-01-30 22:46:05 -0500
1840
Branch: REL9_2_STABLE [c9048d353] 2015-01-30 22:46:12 -0500
1841
Branch: REL9_1_STABLE [cb24cd3f4] 2015-01-30 22:46:17 -0500
1842
Branch: REL9_0_STABLE [3553d9c6e] 2015-01-30 22:46:22 -0500
1843
Author: Tom Lane <tgl@sss.pgh.pa.us>
1844
Branch: REL9_3_STABLE [ab45d907b] 2014-11-17 12:08:25 -0500
1845
Branch: REL9_2_STABLE [b1e996035] 2014-11-17 12:08:32 -0500
1846
Branch: REL9_1_STABLE [b96c47a3d] 2014-11-17 12:08:39 -0500
1847
Branch: REL9_0_STABLE [92979576e] 2014-11-17 12:08:46 -0500
1848
Author: Tom Lane <tgl@sss.pgh.pa.us>
1849
Branch: REL9_3_STABLE [c66199151] 2014-10-04 14:18:33 -0400
1850
Branch: REL9_2_STABLE [8f75d7a25] 2014-10-04 14:18:36 -0400
1851
Branch: REL9_1_STABLE [745723c9e] 2014-10-04 14:18:39 -0400
1852
Branch: REL9_0_STABLE [b6391f587] 2014-10-04 14:18:43 -0400
1857
Update time zone data files to <application>tzdata</> release 2015a.
1861
The IANA timezone database has adopted abbreviations of the form
1862
<literal>A<replaceable>x</>ST</literal>/<literal>A<replaceable>x</>DT</literal>
1863
for all Australian time zones, reflecting what they believe to be
1864
current majority practice Down Under. These names do not conflict
1865
with usage elsewhere (other than ACST for Acre Summer Time, which has
1866
been in disuse since 1994). Accordingly, adopt these names into
1867
our <quote>Default</> timezone abbreviation set.
1868
The <quote>Australia</> abbreviation set now contains only CST, EAST,
1869
EST, SAST, SAT, and WST, all of which are thought to be mostly
1870
historical usage. Note that SAST has also been changed to be South
1871
Africa Standard Time in the <quote>Default</> abbreviation set.
1875
Also, add zone abbreviations SRET (Asia/Srednekolymsk) and XJT
1876
(Asia/Urumqi), and use WSST/WSDT for western Samoa. Also, there were
1877
DST law changes in Chile, Mexico, the Turks & Caicos Islands
1878
(America/Grand_Turk), and Fiji. There is a new zone
1879
Pacific/Bougainville for portions of Papua New Guinea. Also, numerous
1880
corrections for historical (pre-1970) time zone data.
4
1889
<sect1 id="release-9-3-5">
5
1890
<title>Release 9.3.5</title>