1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Release 9.3.11</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.3.13 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="Release Notes"
HREF="release.html"><LINK
REL="PREVIOUS"
TITLE="Release 9.3.12"
HREF="release-9-3-12.html"><LINK
REL="NEXT"
TITLE="Release 9.3.10"
HREF="release-9-3-10.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2016-05-09T21:13:26"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.3.13 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Release 9.3.12"
HREF="release-9-3-12.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="release.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Appendix E. Release Notes</TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Release 9.3.10"
HREF="release-9-3-10.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="RELEASE-9-3-11"
>E.3. Release 9.3.11</A
></H1
><DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
><P
><B
>Release Date: </B
>2016-02-11</P
></BLOCKQUOTE
></DIV
><P
> This release contains a variety of fixes from 9.3.10.
For information about new features in the 9.3 major release, see
<A
HREF="release-9-3.html"
>Section E.14</A
>.
</P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN114759"
>E.3.1. Migration to Version 9.3.11</A
></H2
><P
> A dump/restore is not required for those running 9.3.X.
</P
><P
> However, if you are upgrading from a version earlier than 9.3.9,
see <A
HREF="release-9-3-9.html"
>Section E.5</A
>.
</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN114764"
>E.3.2. Changes</A
></H2
><P
></P
><UL
><LI
><P
> Fix infinite loops and buffer-overrun problems in regular expressions
(Tom Lane)
</P
><P
> Very large character ranges in bracket expressions could cause
infinite loops in some cases, and memory overwrites in other cases.
(CVE-2016-0773)
</P
></LI
><LI
><P
> Perform an immediate shutdown if the <TT
CLASS="FILENAME"
>postmaster.pid</TT
> file
is removed (Tom Lane)
</P
><P
> The postmaster now checks every minute or so
that <TT
CLASS="FILENAME"
>postmaster.pid</TT
> is still there and still contains its
own PID. If not, it performs an immediate shutdown, as though it had
received <SPAN
CLASS="SYSTEMITEM"
>SIGQUIT</SPAN
>. The main motivation for this change
is to ensure that failed buildfarm runs will get cleaned up without
manual intervention; but it also serves to limit the bad effects if a
DBA forcibly removes <TT
CLASS="FILENAME"
>postmaster.pid</TT
> and then starts a new
postmaster.
</P
></LI
><LI
><P
> In <TT
CLASS="LITERAL"
>SERIALIZABLE</TT
> transaction isolation mode, serialization
anomalies could be missed due to race conditions during insertions
(Kevin Grittner, Thomas Munro)
</P
></LI
><LI
><P
> Fix failure to emit appropriate WAL records when doing <TT
CLASS="LITERAL"
>ALTER
TABLE ... SET TABLESPACE</TT
> for unlogged relations (Michael Paquier,
Andres Freund)
</P
><P
> Even though the relation's data is unlogged, the move must be logged or
the relation will be inaccessible after a standby is promoted to master.
</P
></LI
><LI
><P
> Fix possible misinitialization of unlogged relations at the end of
crash recovery (Andres Freund, Michael Paquier)
</P
></LI
><LI
><P
> Ensure walsender slots are fully re-initialized when being re-used
(Magnus Hagander)
</P
></LI
><LI
><P
> Fix <TT
CLASS="COMMAND"
>ALTER COLUMN TYPE</TT
> to reconstruct inherited check
constraints properly (Tom Lane)
</P
></LI
><LI
><P
> Fix <TT
CLASS="COMMAND"
>REASSIGN OWNED</TT
> to change ownership of composite types
properly (Álvaro Herrera)
</P
></LI
><LI
><P
> Fix <TT
CLASS="COMMAND"
>REASSIGN OWNED</TT
> and <TT
CLASS="COMMAND"
>ALTER OWNER</TT
> to correctly
update granted-permissions lists when changing owners of data types,
foreign data wrappers, or foreign servers (Bruce Momjian,
Álvaro Herrera)
</P
></LI
><LI
><P
> Fix <TT
CLASS="COMMAND"
>REASSIGN OWNED</TT
> to ignore foreign user mappings,
rather than fail (Álvaro Herrera)
</P
></LI
><LI
><P
> Fix possible crash after doing query rewrite for an updatable view
(Stephen Frost)
</P
></LI
><LI
><P
> Fix planner's handling of <TT
CLASS="LITERAL"
>LATERAL</TT
> references (Tom
Lane)
</P
><P
> This fixes some corner cases that led to <SPAN
CLASS="QUOTE"
>"failed to build any
N-way joins"</SPAN
> or <SPAN
CLASS="QUOTE"
>"could not devise a query plan"</SPAN
> planner
failures.
</P
></LI
><LI
><P
> Add more defenses against bad planner cost estimates for GIN index
scans when the index's internal statistics are very out-of-date
(Tom Lane)
</P
></LI
><LI
><P
> Make planner cope with hypothetical GIN indexes suggested by an index
advisor plug-in (Julien Rouhaud)
</P
></LI
><LI
><P
> Speed up generation of unique table aliases in <TT
CLASS="COMMAND"
>EXPLAIN</TT
> and
rule dumping, and ensure that generated aliases do not
exceed <TT
CLASS="LITERAL"
>NAMEDATALEN</TT
> (Tom Lane)
</P
></LI
><LI
><P
> Fix dumping of whole-row Vars in <TT
CLASS="LITERAL"
>ROW()</TT
>
and <TT
CLASS="LITERAL"
>VALUES()</TT
> lists (Tom Lane)
</P
></LI
><LI
><P
> Fix possible internal overflow in <TT
CLASS="TYPE"
>numeric</TT
> division
(Dean Rasheed)
</P
></LI
><LI
><P
> Fix enforcement of restrictions inside parentheses within regular
expression lookahead constraints (Tom Lane)
</P
><P
> Lookahead constraints aren't allowed to contain backrefs, and
parentheses within them are always considered non-capturing, according
to the manual. However, the code failed to handle these cases properly
inside a parenthesized subexpression, and would give unexpected
results.
</P
></LI
><LI
><P
> Conversion of regular expressions to indexscan bounds could produce
incorrect bounds from regexps containing lookahead constraints
(Tom Lane)
</P
></LI
><LI
><P
> Fix regular-expression compiler to handle loops of constraint arcs
(Tom Lane)
</P
><P
> The code added for CVE-2007-4772 was both incomplete, in that it didn't
handle loops involving more than one state, and incorrect, in that it
could cause assertion failures (though there seem to be no bad
consequences of that in a non-assert build). Multi-state loops would
cause the compiler to run until the query was canceled or it reached
the too-many-states error condition.
</P
></LI
><LI
><P
> Improve memory-usage accounting in regular-expression compiler
(Tom Lane)
</P
><P
> This causes the code to emit <SPAN
CLASS="QUOTE"
>"regular expression is too
complex"</SPAN
> errors in some cases that previously used unreasonable
amounts of time and memory.
</P
></LI
><LI
><P
> Improve performance of regular-expression compiler (Tom Lane)
</P
></LI
><LI
><P
> Make <TT
CLASS="LITERAL"
>%h</TT
> and <TT
CLASS="LITERAL"
>%r</TT
> escapes
in <TT
CLASS="VARNAME"
>log_line_prefix</TT
> work for messages emitted due
to <TT
CLASS="VARNAME"
>log_connections</TT
> (Tom Lane)
</P
><P
> Previously, <TT
CLASS="LITERAL"
>%h</TT
>/<TT
CLASS="LITERAL"
>%r</TT
> started to work just after a
new session had emitted the <SPAN
CLASS="QUOTE"
>"connection received"</SPAN
> log message;
now they work for that message too.
</P
></LI
><LI
><P
> On Windows, ensure the shared-memory mapping handle gets closed in
child processes that don't need it (Tom Lane, Amit Kapila)
</P
><P
> This oversight resulted in failure to recover from crashes
whenever <TT
CLASS="VARNAME"
>logging_collector</TT
> is turned on.
</P
></LI
><LI
><P
> Fix possible failure to detect socket EOF in non-blocking mode on
Windows (Tom Lane)
</P
><P
> It's not entirely clear whether this problem can happen in pre-9.5
branches, but if it did, the symptom would be that a walsender process
would wait indefinitely rather than noticing a loss of connection.
</P
></LI
><LI
><P
> Avoid leaking a token handle during SSPI authentication
(Christian Ullrich)
</P
></LI
><LI
><P
> In <SPAN
CLASS="APPLICATION"
>psql</SPAN
>, ensure that <SPAN
CLASS="APPLICATION"
>libreadline</SPAN
>'s idea
of the screen size is updated when the terminal window size changes
(Merlin Moncure)
</P
><P
> Previously, <SPAN
CLASS="APPLICATION"
>libreadline</SPAN
> did not notice if the window
was resized during query output, leading to strange behavior during
later input of multiline queries.
</P
></LI
><LI
><P
> Fix <SPAN
CLASS="APPLICATION"
>psql</SPAN
>'s <TT
CLASS="LITERAL"
>\det</TT
> command to interpret its
pattern argument the same way as other <TT
CLASS="LITERAL"
>\d</TT
> commands with
potentially schema-qualified patterns do (Reece Hart)
</P
></LI
><LI
><P
> Avoid possible crash in <SPAN
CLASS="APPLICATION"
>psql</SPAN
>'s <TT
CLASS="LITERAL"
>\c</TT
> command
when previous connection was via Unix socket and command specifies a
new hostname and same username (Tom Lane)
</P
></LI
><LI
><P
> In <TT
CLASS="LITERAL"
>pg_ctl start -w</TT
>, test child process status directly
rather than relying on heuristics (Tom Lane, Michael Paquier)
</P
><P
> Previously, <SPAN
CLASS="APPLICATION"
>pg_ctl</SPAN
> relied on an assumption that the new
postmaster would always create <TT
CLASS="FILENAME"
>postmaster.pid</TT
> within five
seconds. But that can fail on heavily-loaded systems,
causing <SPAN
CLASS="APPLICATION"
>pg_ctl</SPAN
> to report incorrectly that the
postmaster failed to start.
</P
><P
> Except on Windows, this change also means that a <TT
CLASS="LITERAL"
>pg_ctl start
-w</TT
> done immediately after another such command will now reliably
fail, whereas previously it would report success if done within two
seconds of the first command.
</P
></LI
><LI
><P
> In <TT
CLASS="LITERAL"
>pg_ctl start -w</TT
>, don't attempt to use a wildcard listen
address to connect to the postmaster (Kondo Yuta)
</P
><P
> On Windows, <SPAN
CLASS="APPLICATION"
>pg_ctl</SPAN
> would fail to detect postmaster
startup if <TT
CLASS="VARNAME"
>listen_addresses</TT
> is set to <TT
CLASS="LITERAL"
>0.0.0.0</TT
>
or <TT
CLASS="LITERAL"
>::</TT
>, because it would try to use that value verbatim as
the address to connect to, which doesn't work. Instead assume
that <TT
CLASS="LITERAL"
>127.0.0.1</TT
> or <TT
CLASS="LITERAL"
>::1</TT
>, respectively, is the
right thing to use.
</P
></LI
><LI
><P
> In <SPAN
CLASS="APPLICATION"
>pg_ctl</SPAN
> on Windows, check service status to decide
where to send output, rather than checking if standard output is a
terminal (Michael Paquier)
</P
></LI
><LI
><P
> In <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> and <SPAN
CLASS="APPLICATION"
>pg_basebackup</SPAN
>, adopt
the GNU convention for handling tar-archive members exceeding 8GB
(Tom Lane)
</P
><P
> The POSIX standard for <TT
CLASS="LITERAL"
>tar</TT
> file format does not allow
archive member files to exceed 8GB, but most modern implementations
of <SPAN
CLASS="APPLICATION"
>tar</SPAN
> support an extension that fixes that. Adopt
this extension so that <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> with <TT
CLASS="OPTION"
>-Ft</TT
> no
longer fails on tables with more than 8GB of data, and so
that <SPAN
CLASS="APPLICATION"
>pg_basebackup</SPAN
> can handle files larger than 8GB.
In addition, fix some portability issues that could cause failures for
members between 4GB and 8GB on some platforms. Potentially these
problems could cause unrecoverable data loss due to unreadable backup
files.
</P
></LI
><LI
><P
> Fix assorted corner-case bugs in <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
>'s processing
of extension member objects (Tom Lane)
</P
></LI
><LI
><P
> Make <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> mark a view's triggers as needing to be
processed after its rule, to prevent possible failure during
parallel <SPAN
CLASS="APPLICATION"
>pg_restore</SPAN
> (Tom Lane)
</P
></LI
><LI
><P
> Ensure that relation option values are properly quoted
in <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> (Kouhei Sutou, Tom Lane)
</P
><P
> A reloption value that isn't a simple identifier or number could lead
to dump/reload failures due to syntax errors in CREATE statements
issued by <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
>. This is not an issue with any
reloption currently supported by core <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>, but
extensions could allow reloptions that cause the problem.
</P
></LI
><LI
><P
> Avoid repeated password prompts during parallel <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
>
(Zeus Kronion)
</P
></LI
><LI
><P
> Fix <SPAN
CLASS="APPLICATION"
>pg_upgrade</SPAN
>'s file-copying code to handle errors
properly on Windows (Bruce Momjian)
</P
></LI
><LI
><P
> Install guards in <SPAN
CLASS="APPLICATION"
>pgbench</SPAN
> against corner-case overflow
conditions during evaluation of script-specified division or modulo
operators (Fabien Coelho, Michael Paquier)
</P
></LI
><LI
><P
> Fix failure to localize messages emitted
by <SPAN
CLASS="APPLICATION"
>pg_receivexlog</SPAN
> and <SPAN
CLASS="APPLICATION"
>pg_recvlogical</SPAN
>
(Ioseph Kim)
</P
></LI
><LI
><P
> Avoid dump/reload problems when using both <SPAN
CLASS="APPLICATION"
>plpython2</SPAN
>
and <SPAN
CLASS="APPLICATION"
>plpython3</SPAN
> (Tom Lane)
</P
><P
> In principle, both versions of <SPAN
CLASS="APPLICATION"
>PL/Python</SPAN
> can be used in
the same database, though not in the same session (because the two
versions of <SPAN
CLASS="APPLICATION"
>libpython</SPAN
> cannot safely be used concurrently).
However, <SPAN
CLASS="APPLICATION"
>pg_restore</SPAN
> and <SPAN
CLASS="APPLICATION"
>pg_upgrade</SPAN
> both
do things that can fall foul of the same-session restriction. Work
around that by changing the timing of the check.
</P
></LI
><LI
><P
> Fix <SPAN
CLASS="APPLICATION"
>PL/Python</SPAN
> regression tests to pass with Python 3.5
(Peter Eisentraut)
</P
></LI
><LI
><P
> Fix premature clearing of <SPAN
CLASS="APPLICATION"
>libpq</SPAN
>'s input buffer when
socket EOF is seen (Tom Lane)
</P
><P
> This mistake caused <SPAN
CLASS="APPLICATION"
>libpq</SPAN
> to sometimes not report the
backend's final error message before reporting <SPAN
CLASS="QUOTE"
>"server closed the
connection unexpectedly"</SPAN
>.
</P
></LI
><LI
><P
> Prevent certain <SPAN
CLASS="APPLICATION"
>PL/Java</SPAN
> parameters from being set by
non-superusers (Noah Misch)
</P
><P
> This change mitigates a <SPAN
CLASS="APPLICATION"
>PL/Java</SPAN
> security bug
(CVE-2016-0766), which was fixed in <SPAN
CLASS="APPLICATION"
>PL/Java</SPAN
> by marking
these parameters as superuser-only. To fix the security hazard for
sites that update <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> more frequently
than <SPAN
CLASS="APPLICATION"
>PL/Java</SPAN
>, make the core code aware of them also.
</P
></LI
><LI
><P
> Improve <SPAN
CLASS="APPLICATION"
>libpq</SPAN
>'s handling of out-of-memory situations
(Michael Paquier, Amit Kapila, Heikki Linnakangas)
</P
></LI
><LI
><P
> Fix order of arguments
in <SPAN
CLASS="APPLICATION"
>ecpg</SPAN
>-generated <TT
CLASS="LITERAL"
>typedef</TT
> statements
(Michael Meskes)
</P
></LI
><LI
><P
> Use <TT
CLASS="LITERAL"
>%g</TT
> not <TT
CLASS="LITERAL"
>%f</TT
> format
in <SPAN
CLASS="APPLICATION"
>ecpg</SPAN
>'s <CODE
CLASS="FUNCTION"
>PGTYPESnumeric_from_double()</CODE
>
(Tom Lane)
</P
></LI
><LI
><P
> Fix <SPAN
CLASS="APPLICATION"
>ecpg</SPAN
>-supplied header files to not contain comments
continued from a preprocessor directive line onto the next line
(Michael Meskes)
</P
><P
> Such a comment is rejected by <SPAN
CLASS="APPLICATION"
>ecpg</SPAN
>. It's not yet clear
whether <SPAN
CLASS="APPLICATION"
>ecpg</SPAN
> itself should be changed.
</P
></LI
><LI
><P
> Fix <CODE
CLASS="FUNCTION"
>hstore_to_json_loose()</CODE
>'s test for whether
an <TT
CLASS="TYPE"
>hstore</TT
> value can be converted to a JSON number (Tom Lane)
</P
><P
> Previously this function could be fooled by non-alphanumeric trailing
characters, leading to emitting syntactically-invalid JSON.
</P
></LI
><LI
><P
> Ensure that <TT
CLASS="FILENAME"
>contrib/pgcrypto</TT
>'s <CODE
CLASS="FUNCTION"
>crypt()</CODE
>
function can be interrupted by query cancel (Andreas Karlsson)
</P
></LI
><LI
><P
> Accept <SPAN
CLASS="APPLICATION"
>flex</SPAN
> versions later than 2.5.x
(Tom Lane, Michael Paquier)
</P
><P
> Now that flex 2.6.0 has been released, the version checks in our build
scripts needed to be adjusted.
</P
></LI
><LI
><P
> Improve reproducibility of build output by ensuring filenames are given
to the linker in a fixed order (Christoph Berg)
</P
><P
> This avoids possible bitwise differences in the produced executable
files from one build to the next.
</P
></LI
><LI
><P
> Install our <TT
CLASS="FILENAME"
>missing</TT
> script where PGXS builds can find it
(Jim Nasby)
</P
><P
> This allows sane behavior in a PGXS build done on a machine where build
tools such as <SPAN
CLASS="APPLICATION"
>bison</SPAN
> are missing.
</P
></LI
><LI
><P
> Ensure that <TT
CLASS="FILENAME"
>dynloader.h</TT
> is included in the installed
header files in MSVC builds (Bruce Momjian, Michael Paquier)
</P
></LI
><LI
><P
> Add variant regression test expected-output file to match behavior of
current <SPAN
CLASS="APPLICATION"
>libxml2</SPAN
> (Tom Lane)
</P
><P
> The fix for <SPAN
CLASS="APPLICATION"
>libxml2</SPAN
>'s CVE-2015-7499 causes it not to
output error context reports in some cases where it used to do so.
This seems to be a bug, but we'll probably have to live with it for
some time, so work around it.
</P
></LI
><LI
><P
> Update time zone data files to <SPAN
CLASS="APPLICATION"
>tzdata</SPAN
> release 2016a for
DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal
Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.
</P
></LI
></UL
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="release-9-3-12.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="release-9-3-10.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Release 9.3.12</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="release.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Release 9.3.10</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
|