postgresql, postgresql84 security update

CentOS Errata and Security Advisory CESA-2010:0742

PostgreSQL is an advanced object-relational database management system
(DBMS). PL/Perl and PL/Tcl allow users to write PostgreSQL functions in the
Perl and Tcl languages. The PostgreSQL SECURITY DEFINER parameter, which
can be used when creating a new PostgreSQL function, specifies that the
function will be executed with the privileges of the user that created it.

It was discovered that a user could utilize the features of the PL/Perl and
PL/Tcl languages to modify the behavior of a SECURITY DEFINER function
created by a different user. If the PL/Perl or PL/Tcl language was used to
implement a SECURITY DEFINER function, an authenticated database user could
use a PL/Perl or PL/Tcl script to modify the behavior of that function
during subsequent calls in the same session. This would result in the
modified or injected code also being executed with the privileges of the
user who created the SECURITY DEFINER function, possibly leading to
privilege escalation. (CVE-2010-3433)

For Red Hat Enterprise Linux 4, the updated postgresql packages upgrade
PostgreSQL to version 7.4.30. Refer to the PostgreSQL Release Notes for a
list of changes:

http://www.postgresql.org/docs/7.4/static/release.html

For Red Hat Enterprise Linux 5, the updated postgresql packages upgrade
PostgreSQL to version 8.1.22, and the updated postgresql84 packages upgrade
PostgreSQL to version 8.4.5. Refer to the PostgreSQL Release Notes for a
list of changes:

http://www.postgresql.org/docs/8.1/static/release.html
http://www.postgresql.org/docs/8.4/static/release.html

All PostgreSQL users are advised to upgrade to these updated packages,
which correct this issue. If the postgresql service is running, it will be
automatically restarted after installing this update.

Merged security bulletin from advisories:
https://lists.centos.org/pipermail/centos-announce/2010-October/079203.html
https://lists.centos.org/pipermail/centos-announce/2010-October/079204.html
https://lists.centos.org/pipermail/centos-announce/2010-October/079221.html
https://lists.centos.org/pipermail/centos-announce/2010-October/079222.html
https://lists.centos.org/pipermail/centos-announce/2010-October/079231.html
https://lists.centos.org/pipermail/centos-announce/2010-October/079232.html

Affected packages:
postgresql
postgresql-contrib
postgresql-devel
postgresql-docs
postgresql-jdbc
postgresql-libs
postgresql-pl
postgresql-python
postgresql-server
postgresql-tcl
postgresql-test
postgresql84
postgresql84-contrib
postgresql84-devel
postgresql84-docs
postgresql84-libs
postgresql84-plperl
postgresql84-plpython
postgresql84-pltcl
postgresql84-python
postgresql84-server
postgresql84-tcl
postgresql84-test

Upstream details at:
https://access.redhat.com/errata/RHSA-2010:0742