DSA-1309-1 postgresql-8.1 -- programming error

Debian Security Advisory

DSA-1309-1 postgresql-8.1 -- programming error

Date Reported:

16 Jun 2007

Affected Packages:

postgresql-8.1

Vulnerable:

Yes

Security database references:

In Mitre's CVE dictionary: CVE-2007-2138.

More information:

It was discovered that the PostgreSQL database performs insufficient validation of variables passed to privileged SQL statements, so called security definers, which could lead to SQL privilege escalation.

The oldstable distribution (sarge) doesn't contain PostgreSQL 8.1.

For the stable distribution (etch) this problem has been fixed in version 8.1.9-0etch4.

For the unstable distribution (sid) this problem has been fixed in version 8.1.9-1.

We recommend that you upgrade your PostgreSQL packages.

Fixed in:

Debian GNU/Linux 4.0 (etch)

Source:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4.dsc

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4.diff.gz

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9.orig.tar.gz

Architecture-independent component:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-doc-8.1_8.1.9-0etch4_all.deb

Alpha:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_alpha.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_alpha.deb

AMD64:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_amd64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_amd64.deb

ARM:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_arm.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_arm.deb

HPPA:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_hppa.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_hppa.deb

Intel IA-32:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_i386.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_i386.deb

Intel IA-64:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_ia64.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_ia64.deb

Big endian MIPS:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_mips.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_mips.deb

Little endian MIPS:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_mipsel.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_mipsel.deb

PowerPC:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_powerpc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_powerpc.deb

IBM S/390:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_s390.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_s390.deb

Sun Sparc:

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-compat2_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg-dev_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libecpg5_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpgtypes2_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq-dev_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/libpq4_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-8.1_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-client-8.1_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.9-0etch4_sparc.deb

http://security.debian.org/pool/updates/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.9-0etch4_sparc.deb

MD5 checksums of the listed files are available in the original advisory.