Appendix E. Release Notes

Table of Contents
E.1. Release 7.4.23
E.2. Release 7.4.22
E.3. Release 7.4.21
E.4. Release 7.4.20
E.5. Release 7.4.19
E.6. Release 7.4.18
E.7. Release 7.4.17
E.8. Release 7.4.16
E.9. Release 7.4.15
E.10. Release 7.4.14
E.11. Release 7.4.13
E.12. Release 7.4.12
E.13. Release 7.4.11
E.14. Release 7.4.10
E.15. Release 7.4.9
E.16. Release 7.4.8
E.17. Release 7.4.7
E.18. Release 7.4.6
E.19. Release 7.4.5
E.20. Release 7.4.4
E.21. Release 7.4.3
E.22. Release 7.4.2
E.23. Release 7.4.1
E.24. Release 7.4
E.25. Release 7.3.21
E.26. Release 7.3.20
E.27. Release 7.3.19
E.28. Release 7.3.18
E.29. Release 7.3.17
E.30. Release 7.3.16
E.31. Release 7.3.15
E.32. Release 7.3.14
E.33. Release 7.3.13
E.34. Release 7.3.12
E.35. Release 7.3.11
E.36. Release 7.3.10
E.37. Release 7.3.9
E.38. Release 7.3.8
E.39. Release 7.3.7
E.40. Release 7.3.6
E.41. Release 7.3.5
E.42. Release 7.3.4
E.43. Release 7.3.3
E.44. Release 7.3.2
E.45. Release 7.3.1
E.46. Release 7.3
E.47. Release 7.2.8
E.48. Release 7.2.7
E.49. Release 7.2.6
E.50. Release 7.2.5
E.51. Release 7.2.4
E.52. Release 7.2.3
E.53. Release 7.2.2
E.54. Release 7.2.1
E.55. Release 7.2
E.56. Release 7.1.3
E.57. Release 7.1.2
E.58. Release 7.1.1
E.59. Release 7.1
E.60. Release 7.0.3
E.61. Release 7.0.2
E.62. Release 7.0.1
E.63. Release 7.0
E.64. Release 6.5.3
E.65. Release 6.5.2
E.66. Release 6.5.1
E.67. Release 6.5
E.68. Release 6.4.2
E.69. Release 6.4.1
E.70. Release 6.4
E.71. Release 6.3.2
E.72. Release 6.3.1
E.73. Release 6.3
E.74. Release 6.2.1
E.75. Release 6.2
E.76. Release 6.1.1
E.77. Release 6.1
E.78. Release 6.0
E.79. Release 1.09
E.80. Release 1.02
E.81. Release 1.01
E.82. Release 1.0
E.83. Postgres95 Release 0.03
E.84. Postgres95 Release 0.02
E.85. Postgres95 Release 0.01

The release notes contain the significant changes in each PostgreSQL release, with major features and migration issues listed at the top. The release notes do not contain changes that affect only a few users or changes that are internal and therefore not user-visible. For example, the optimizer is improved in almost every release, but the improvements are usually observed by users as simply faster queries.

A complete list of changes for each release can be obtained by viewing the CVS logs for each release. The pgsql-committers email list contains all source code changes as well. There is also a web interface that shows changes to specific files.

The name appearing next to each item represents the major developer for that item. Of course all changes involve community discussion and patch review, so each item is truly a community effort.

E.1. Release 7.4.23

Release date: 2008-11-03

This release contains a variety of fixes from 7.4.22. For information about new features in the 7.4 major release, see Section E.24.

E.1.1. Migration to Version 7.4.23

A dump/restore is not required for those running 7.4.X. However, if you are upgrading from a version earlier than 7.4.11, see the release notes for 7.4.11.

E.1.2. Changes

  • Fix backend crash when the client encoding cannot represent a localized error message (Tom)

    We have addressed similar issues before, but it would still fail if the "character has no equivalent" message itself couldn't be converted. The fix is to disable localization and send the plain ASCII error message when we detect such a situation.

  • Fix incorrect tsearch2 headline generation when single query item matches first word of text (Sushant Sinha)

  • Fix improper display of fractional seconds in interval values when using a non-ISO datestyle in an --enable-integer-datetimes build (Ron Mayer)

  • Ensure SPI_getvalue and SPI_getbinval behave correctly when the passed tuple and tuple descriptor have different numbers of columns (Tom)

    This situation is normal when a table has had columns added or removed, but these two functions didn't handle it properly. The only likely consequence is an incorrect error indication.

  • Fix ecpg's parsing of CREATE USER (Michael)