2009年9月10日

[installer 2062] postgresql-8.4.1, 8.3.8, 8.2.14, 8.1.18, 8.0.22, 7.4.26

postgresql-8.4.1, 8.3.8, 8.2.14, 8.1.18, 8.0.22, 7.4.26 出ています。

☆ postgresql-8.4.1
http://www.postgresql.org/
ftp://ftp.postgresql.org/pub/source/v8.4.1/postgresql-8.4.1.tar.gz

Release 8.4.1

Release date: 2009-09-09

This release contains a variety of fixes from 8.4. For information
about new features in the 8.4 major release, see the Section called
Release 8.4.
__________________________________________________________________

Migration to Version 8.4.1

A dump/restore is not required for those running 8.4.X.
__________________________________________________________________

Changes

* Fix WAL page header initialization at the end of archive recovery
(Heikki)
This could lead to failure to process the WAL in a subsequent
archive recovery.
* Fix "cannot make new WAL entries during recovery" error (Tom)
* Fix problem that could make expired rows visible after a crash
(Tom)
This bug involved a page status bit potentially not being set
correctly after a server crash.
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous patch that
disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside
security-definer functions. (See CVE-2007-6600)
* Make "LOAD" of an already-loaded loadable module into a no-op (Tom)
Formerly, "LOAD" would attempt to unload and re-load the module,
but this is unsafe and not all that useful.
* Make window function PARTITION BY and ORDER BY items always be
interpreted as simple expressions (Tom)
In 8.4.0 these lists were parsed following the rules used for
top-level GROUP BY and ORDER BY lists. But this was not correct per
the SQL standard, and it led to possible circularity.
* Fix several errors in planning of semi-joins (Tom)
These led to wrong query results in some cases where IN or EXISTS
was used together with another join.
* Fix handling of whole-row references to subqueries that are within
an outer join (Tom)
An example is SELECT COUNT(ss.*) FROM ... LEFT JOIN (SELECT ...) ss
ON .... Here, ss.* would be treated as ROW(NULL,NULL,...) for
null-extended join rows, which is not the same as a simple NULL.
Now it is treated as a simple NULL.
* Fix Windows shared-memory allocation code (Tsutomu Yamada, Magnus)
This bug led to the often-reported "could not reattach to shared
memory" error message.
* Fix locale handling with plperl (Heikki)
This bug could cause the server's locale setting to change when a
plperl function is called, leading to data corruption.
* Fix handling of reloptions to ensure setting one option doesn't
force default values for others (Itagaki Takahiro)
* Ensure that a "fast shutdown" request will forcibly terminate open
sessions, even if a "smart shutdown" was already in progress (Fujii
Masao)
* Avoid memory leak for array_agg() in GROUP BY queries (Tom)
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with
'HH'/'HH12' (Heikki)
It was previously handled as 'th' (lowercase).
* Include the fractional part in the result of EXTRACT(second) and
EXTRACT(milliseconds) for time and time with time zone inputs (Tom)
This has always worked for floating-point datetime configurations,
but was broken in the integer datetime code.
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
and integer datetimes are in use (Alex Hunsaker)
* Improve performance when processing toasted values in index scans
(Tom)
This is particularly useful for PostGIS.
* Fix a typo that disabled commit_delay (Jeff Janes)
* Output early-startup messages to "postmaster.log" if the server is
started in silent mode (Tom)
Previously such error messages were discarded, leading to
difficulty in debugging.
* Remove translated FAQs (Peter)
They are now on the wiki. The main FAQ was moved to the wiki some
time ago.
* Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
empty (Jeff Davis)
* Fix several errors in pg_dump's --binary-upgrade mode (Bruce, Tom)
pg_dump --binary-upgrade is used by pg_migrator.
* Fix "contrib/xml2"'s xslt_process() to properly handle the maximum
number of parameters (twenty) (Tom)
* Improve robustness of libpq's code to recover from errors during
"COPY FROM STDIN" (Tom)
* Avoid including conflicting readline and editline header files when
both libraries are installed (Zdenek Kotala)
* Work around gcc bug that causes "floating-point exception" instead
of "division by zero" on some platforms (Tom)
* Update time zone data files to tzdata release 2009l for DST law
changes in Bangladesh, Egypt, Mauritius.


☆ postgresql-8.3.8
http://www.postgresql.org/
ftp://ftp.postgresql.org/pub/source/v8.3.8/postgresql-8.3.8.tar.gz

Release 8.3.8

Release date: 2009-09-09

This release contains a variety of fixes from 8.3.7. For information
about new features in the 8.3 major release, see the Section called
Release 8.3.
__________________________________________________________________

Migration to Version 8.3.8

A dump/restore is not required for those running 8.3.X. However, if you
have any hash indexes on interval columns, you must "REINDEX" them
after updating to 8.3.8. Also, if you are upgrading from a version
earlier than 8.3.5, see the release notes for 8.3.5.
__________________________________________________________________

Changes

* Fix Windows shared-memory allocation code (Tsutomu Yamada, Magnus)
This bug led to the often-reported "could not reattach to shared
memory" error message.
* Force WAL segment switch during pg_start_backup() (Heikki)
This avoids corner cases that could render a base backup unusable.
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous patch that
disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside
security-definer functions. (See CVE-2007-6600)
* Make "LOAD" of an already-loaded loadable module into a no-op (Tom)
Formerly, "LOAD" would attempt to unload and re-load the module,
but this is unsafe and not all that useful.
* Disallow empty passwords during LDAP authentication (Magnus)
* Fix handling of sub-SELECTs appearing in the arguments of an
outer-level aggregate function (Tom)
* Fix bugs associated with fetching a whole-row value from the output
of a Sort or Materialize plan node (Tom)
* Prevent synchronize_seqscans from changing the results of
scrollable and WITH HOLD cursors (Tom)
* Revert planner change that disabled partial-index and constraint
exclusion optimizations when there were more than 100 clauses in an
AND or OR list (Tom)
* Fix hash calculation for data type interval (Tom)
This corrects wrong results for hash joins on interval values. It
also changes the contents of hash indexes on interval columns. If
you have any such indexes, you must "REINDEX" them after updating.
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with
'HH'/'HH12' (Heikki)
It was previously handled as 'th' (lowercase).
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
and integer datetimes are in use (Alex Hunsaker)
* Fix calculation of distance between a point and a line segment
(Tom)
This led to incorrect results from a number of geometric operators.
* Fix money data type to work in locales where currency amounts have
no fractional digits, e.g. Japan (Itagaki Takahiro)
* Fix LIKE for case where pattern contains %_ (Tom)
* Properly round datetime input like
00:12:57.9999999999999999999999999999 (Tom)
* Fix memory leaks in XML operations (Tom)
* Fix poor choice of page split point in GiST R-tree operator classes
(Teodor)
* Ensure that a "fast shutdown" request will forcibly terminate open
sessions, even if a "smart shutdown" was already in progress (Fujii
Masao)
* Avoid performance degradation in bulk inserts into GIN indexes when
the input values are (nearly) in sorted order (Tom)
* Correctly enforce NOT NULL domain constraints in some contexts in
PL/pgSQL (Tom)
* Fix portability issues in plperl initialization (Andrew Dunstan)
* Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
empty (Jeff Davis)
* Improve pg_dump's efficiency when there are many large objects
(Tamas Vincze)
* Use SIGUSR1, not SIGQUIT, as the failover signal for pg_standby
(Heikki)
* Make pg_standby's maxretries option behave as documented (Fujii
Masao)
* Make "contrib/hstore" throw an error when a key or value is too
long to fit in its data structure, rather than silently truncating
it (Andrew Gierth)
* Fix "contrib/xml2"'s xslt_process() to properly handle the maximum
number of parameters (twenty) (Tom)
* Improve robustness of libpq's code to recover from errors during
"COPY FROM STDIN" (Tom)
* Avoid including conflicting readline and editline header files when
both libraries are installed (Zdenek Kotala)
* Update time zone data files to tzdata release 2009l for DST law
changes in Bangladesh, Egypt, Jordan, Pakistan, Argentina/San_Luis,
Cuba, Jordan (historical correction only), Mauritius, Morocco,
Palestine, Syria, Tunisia.


☆ postgresql-8.2.14
http://www.postgresql.org/
ftp://ftp.postgresql.org/pub/source/v8.2.14/postgresql-8.2.14.tar.gz

Release 8.2.14

Release date: 2009-09-09

This release contains a variety of fixes from 8.2.13. For information
about new features in the 8.2 major release, see the Section called
Release 8.2.
__________________________________________________________________

Migration to Version 8.2.14

A dump/restore is not required for those running 8.2.X. However, if you
have any hash indexes on interval columns, you must "REINDEX" them
after updating to 8.2.14. Also, if you are upgrading from a version
earlier than 8.2.11, see the release notes for 8.2.11.
__________________________________________________________________

Changes

* Force WAL segment switch during pg_start_backup() (Heikki)
This avoids corner cases that could render a base backup unusable.
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous patch that
disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside
security-definer functions. (See CVE-2007-6600)
* Make "LOAD" of an already-loaded loadable module into a no-op (Tom)
Formerly, "LOAD" would attempt to unload and re-load the module,
but this is unsafe and not all that useful.
* Disallow empty passwords during LDAP authentication (Magnus)
* Fix handling of sub-SELECTs appearing in the arguments of an
outer-level aggregate function (Tom)
* Fix bugs associated with fetching a whole-row value from the output
of a Sort or Materialize plan node (Tom)
* Revert planner change that disabled partial-index and constraint
exclusion optimizations when there were more than 100 clauses in an
AND or OR list (Tom)
* Fix hash calculation for data type interval (Tom)
This corrects wrong results for hash joins on interval values. It
also changes the contents of hash indexes on interval columns. If
you have any such indexes, you must "REINDEX" them after updating.
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with
'HH'/'HH12' (Heikki)
It was previously handled as 'th' (lowercase).
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
and integer datetimes are in use (Alex Hunsaker)
* Fix calculation of distance between a point and a line segment
(Tom)
This led to incorrect results from a number of geometric operators.
* Fix money data type to work in locales where currency amounts have
no fractional digits, e.g. Japan (Itagaki Takahiro)
* Properly round datetime input like
00:12:57.9999999999999999999999999999 (Tom)
* Fix poor choice of page split point in GiST R-tree operator classes
(Teodor)
* Avoid performance degradation in bulk inserts into GIN indexes when
the input values are (nearly) in sorted order (Tom)
* Correctly enforce NOT NULL domain constraints in some contexts in
PL/pgSQL (Tom)
* Fix portability issues in plperl initialization (Andrew Dunstan)
* Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
empty (Jeff Davis)
* Make "contrib/hstore" throw an error when a key or value is too
long to fit in its data structure, rather than silently truncating
it (Andrew Gierth)
* Fix "contrib/xml2"'s xslt_process() to properly handle the maximum
number of parameters (twenty) (Tom)
* Improve robustness of libpq's code to recover from errors during
"COPY FROM STDIN" (Tom)
* Avoid including conflicting readline and editline header files when
both libraries are installed (Zdenek Kotala)
* Update time zone data files to tzdata release 2009l for DST law
changes in Bangladesh, Egypt, Jordan, Pakistan, Argentina/San_Luis,
Cuba, Jordan (historical correction only), Mauritius, Morocco,
Palestine, Syria, Tunisia.


☆ postgresql-8.1.18
http://www.postgresql.org/
ftp://ftp.postgresql.org/pub/source/v8.1.18/postgresql-8.1.18.tar.gz

Release 8.1.18

Release date: 2009-09-09

This release contains a variety of fixes from 8.1.17. For information
about new features in the 8.1 major release, see the Section called
Release 8.1.
__________________________________________________________________

Migration to Version 8.1.18

A dump/restore is not required for those running 8.1.X. However, if you
have any hash indexes on interval columns, you must "REINDEX" them
after updating to 8.1.18. Also, if you are upgrading from a version
earlier than 8.1.15, see the release notes for 8.1.15.
__________________________________________________________________

Changes

* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous patch that
disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside
security-definer functions. (See CVE-2007-6600)
* Fix handling of sub-SELECTs appearing in the arguments of an
outer-level aggregate function (Tom)
* Fix hash calculation for data type interval (Tom)
This corrects wrong results for hash joins on interval values. It
also changes the contents of hash indexes on interval columns. If
you have any such indexes, you must "REINDEX" them after updating.
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with
'HH'/'HH12' (Heikki)
It was previously handled as 'th' (lowercase).
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
and integer datetimes are in use (Alex Hunsaker)
* Fix calculation of distance between a point and a line segment
(Tom)
This led to incorrect results from a number of geometric operators.
* Fix money data type to work in locales where currency amounts have
no fractional digits, e.g. Japan (Itagaki Takahiro)
* Properly round datetime input like
00:12:57.9999999999999999999999999999 (Tom)
* Fix poor choice of page split point in GiST R-tree operator classes
(Teodor)
* Fix portability issues in plperl initialization (Andrew Dunstan)
* Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
empty (Jeff Davis)
* Fix "contrib/xml2"'s xslt_process() to properly handle the maximum
number of parameters (twenty) (Tom)
* Improve robustness of libpq's code to recover from errors during
"COPY FROM STDIN" (Tom)
* Avoid including conflicting readline and editline header files when
both libraries are installed (Zdenek Kotala)
* Update time zone data files to tzdata release 2009l for DST law
changes in Bangladesh, Egypt, Jordan, Pakistan, Argentina/San_Luis,
Cuba, Jordan (historical correction only), Mauritius, Morocco,
Palestine, Syria, Tunisia.


☆ postgresql-8.0.22
http://www.postgresql.org/
ftp://ftp.postgresql.org/pub/source/v8.0.22/postgresql-8.0.22.tar.gz

Release 8.0.22

Release date: 2009-09-09

This release contains a variety of fixes from 8.0.21. For information
about new features in the 8.0 major release, see the Section called
Release 8.0.
__________________________________________________________________

Migration to Version 8.0.22

A dump/restore is not required for those running 8.0.X. However, if you
have any hash indexes on interval columns, you must "REINDEX" them
after updating to 8.0.22. Also, if you are upgrading from a version
earlier than 8.0.6, see the release notes for 8.0.6.
__________________________________________________________________

Changes

* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous patch that
disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside
security-definer functions. (See CVE-2007-6600)
* Fix handling of sub-SELECTs appearing in the arguments of an
outer-level aggregate function (Tom)
* Fix hash calculation for data type interval (Tom)
This corrects wrong results for hash joins on interval values. It
also changes the contents of hash indexes on interval columns. If
you have any such indexes, you must "REINDEX" them after updating.
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with
'HH'/'HH12' (Heikki)
It was previously handled as 'th' (lowercase).
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
and integer datetimes are in use (Alex Hunsaker)
* Fix calculation of distance between a point and a line segment
(Tom)
This led to incorrect results from a number of geometric operators.
* Fix money data type to work in locales where currency amounts have
no fractional digits, e.g. Japan (Itagaki Takahiro)
* Properly round datetime input like
00:12:57.9999999999999999999999999999 (Tom)
* Fix poor choice of page split point in GiST R-tree operator classes
(Teodor)
* Fix portability issues in plperl initialization (Andrew Dunstan)
* Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
empty (Jeff Davis)
* Fix "contrib/xml2"'s xslt_process() to properly handle the maximum
number of parameters (twenty) (Tom)
* Improve robustness of libpq's code to recover from errors during
"COPY FROM STDIN" (Tom)
* Avoid including conflicting readline and editline header files when
both libraries are installed (Zdenek Kotala)
* Update time zone data files to tzdata release 2009l for DST law
changes in Bangladesh, Egypt, Jordan, Pakistan, Argentina/San_Luis,
Cuba, Jordan (historical correction only), Mauritius, Morocco,
Palestine, Syria, Tunisia.


☆ postgresql-7.4.26
http://www.postgresql.org/
ftp://ftp.postgresql.org/pub/source/v7.4.26/postgresql-7.4.26.tar.gz

Release 7.4.26

Release date: 2009-09-09

This release contains a variety of fixes from 7.4.25. For information
about new features in the 7.4 major release, see the Section called
Release 7.4.
__________________________________________________________________

Migration to Version 7.4.26

A dump/restore is not required for those running 7.4.X. However, if you
have any hash indexes on interval columns, you must "REINDEX" them
after updating to 7.4.26. Also, if you are upgrading from a version
earlier than 7.4.11, see the release notes for 7.4.11.
__________________________________________________________________

Changes

* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous patch that
disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside
security-definer functions. (See CVE-2007-6600)
* Fix handling of sub-SELECTs appearing in the arguments of an
outer-level aggregate function (Tom)
* Fix hash calculation for data type interval (Tom)
This corrects wrong results for hash joins on interval values. It
also changes the contents of hash indexes on interval columns. If
you have any such indexes, you must "REINDEX" them after updating.
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
and integer datetimes are in use (Alex Hunsaker)
* Fix calculation of distance between a point and a line segment
(Tom)
This led to incorrect results from a number of geometric operators.
* Fix money data type to work in locales where currency amounts have
no fractional digits, e.g. Japan (Itagaki Takahiro)
* Properly round datetime input like
00:12:57.9999999999999999999999999999 (Tom)
* Fix poor choice of page split point in GiST R-tree operator classes
(Teodor)
* Fix portability issues in plperl initialization (Andrew Dunstan)
* Improve robustness of libpq's code to recover from errors during
"COPY FROM STDIN" (Tom)
* Avoid including conflicting readline and editline header files when
both libraries are installed (Zdenek Kotala)

----
こがよういちろう


投稿者 xml-rpc : 2009年9月10日 09:57
役に立ちました?:
過去のフィードバック 平均:(0) 総合:(0) 投票回数:(0)
本記事へのTrackback: http://hoop.euqset.org/blog/mt-tb2006.cgi/88421
トラックバック
コメント
コメントする




画像の中に見える文字を入力してください。