Cookies op Tweakers

Tweakers maakt gebruik van cookies, onder andere om de website te analyseren, het gebruiksgemak te vergroten en advertenties te tonen. Door gebruik te maken van deze website, of door op 'Ga verder' te klikken, geef je toestemming voor het gebruik van cookies. Wil je meer informatie over cookies en hoe ze worden gebruikt, bekijk dan ons cookiebeleid.

Meer informatie

Software-update: PostgreSQL 8.2.4

De PostgreSQL Global Development Group heeft alweer enkele dagen geleden versie 8.2.4 van PostgreSQL uitgebracht. Dit populaire opensource Relational Database Management System draait op een groot aantal besturingssystemen en is daardoor uitstekend inzetbaar voor diverse omgevingen. Het is niet nodig om een dump/restore uit te voeren, wanneer momenteel al een 8.2.x versie wordt gebruikt. De lijst met veranderingen sinds de vorige vermelding in de meuktracker ziet er als volgt uit:

Version 8.2.4:
  • Support explicit placement of the temporary-table schema within search_path, and disable searching it for functions and operators (Tom)
    This is needed to allow a security-definer function to set a truly secure value of search_path. Without it, an unprivileged SQL user can use temporary objects to execute code with the privileges of the security-definer function (CVE-2007-2138). See CREATE FUNCTION for more information.
  • Fix shared_preload_libraries for Windows by forcing reload in each backend (Korry Douglas)
  • Fix to_char() so it properly upper/lower cases localized day or month names (Pavel Stehule)
  • /contrib/tsearch2 crash fixes (Teodor)
  • Require COMMIT PREPARED to be executed in the same database as the transaction was prepared in (Heikki)
  • Allow pg_dump to do binary backups larger than two gigabytes on Windows (Magnus)
  • New traditional (Taiwan) Chinese FAQ (Zhou Daojing)
  • Prevent the statistics collector from writing to disk too frequently (Tom)
  • Fix potential-data-corruption bug in how VACUUM FULL handles UPDATE chains (Tom, Pavan Deolasee)
  • Fix bug in domains that use array types (Tom)
  • Fix pg_dump so it can dump a serial column's sequence using -t when not also dumping the owning table (Tom)
  • Planner fixes, including improving outer join and bitmap scan selection logic (Tom)
  • Fix possible wrong answers or crash when a PL/pgSQL function tries to RETURN from within an EXCEPTION block (Tom)
  • Fix PANIC during enlargement of a hash index (Tom)
  • Fix POSIX-style timezone specs to follow new USA DST rules (Tom)
Version 8.2.3:
  • Remove overly-restrictive check for type length in constraints and functional indexes(Tom)
  • Fix optimization so MIN/MAX in subqueries can again use indexes (Tom)
Version 8.2.2:
  • Remove security vulnerabilities that allowed connected users to read backend memory (Tom)
    The vulnerabilities involve suppressing the normal check that a SQL function returns the data type it's declared to, and changing the data type of a table column (CVE-2007-0555, CVE-2007-0556). These errors can easily be exploited to cause a backend crash, and in principle might be used to read database content that the user should not be able to access.
  • Fix not-so-rare-anymore bug wherein btree index page splits could fail due to choosing an infeasible split point (Heikki Linnakangas)
  • Fix Borland C compile scripts (L Bayuk)
  • Properly handle to_char('CC') for years ending in 00 (Tom)
    Year 2000 is in the twentieth century, not the twenty-first.
  • /contrib/tsearch2 localization improvements (Tatsuo, Teodor)
  • Fix incorrect permission check in information_schema.key_column_usage view (Tom)
    The symptom is "relation with OID nnnnn does not exist" errors. To get this fix without using initdb, use CREATE OR REPLACE VIEW to install the corrected definition found in share/information_schema.sql. Note you will need to do this in each database.
  • Improve VACUUM performance for databases with many tables (Tom)
  • Fix for rare Assert() crash triggered by UNION (Tom)
  • Fix potentially incorrect results from index searches using ROW inequality conditions (Tom)
  • Tighten security of multi-byte character processing for UTF8 sequences over three bytes long (Tom)
  • Fix bogus "permission denied" failures occurring on Windows due to attempts to fsync already-deleted files (Magnus, Tom)
  • Fix bug that could cause the statistics collector to hang on Windows (Magnus)
    This would in turn lead to autovacuum not working.
  • Fix possible crashes when an already-in-use PL/pgSQL function is updated (Tom)
  • Improve PL/pgSQL handling of domain types (Sergiy Vyshnevetskiy, Tom)
  • Fix possible errors in processing PL/pgSQL exception blocks (Tom)
Versienummer 8.2.4
Besturingssystemen Windows NT, Windows 2000, Linux, BSD, Windows XP, macOS, Solaris, UNIX, Windows Server 2003, Windows Vista
Website PostgreSQL
Licentietype Voorwaarden (GNU/BSD/etc.)


Er zijn nog geen reacties geplaatst

Op dit item kan niet meer gereageerd worden.

Call of Duty: Black Ops 4 HTC U12+ dual sim LG W7 Google Pixel 3 XL OnePlus 6 Battlefield V Samsung Galaxy S9 Dual Sim Google Pixel 3

Tweakers vormt samen met Tweakers Elect, Hardware.Info, Autotrack, Nationale Vacaturebank en Intermediair de Persgroep Online Services B.V.
Alle rechten voorbehouden © 1998 - 2018 Hosting door True