NOTICE: This package has been removed from pkgsrc

./databases/postgresql82, Robust, next generation, object-relational DBMS

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ]


Branch: CURRENT, Version: 8.2.18, Package name: postgresql82-8.2.18, Maintainer: adam

PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
derived from the Berkeley Postgres database management system. While
PostgreSQL retains the powerful object-relational data model, rich data types
and easy extensibility of Postgres, it replaces the PostQuel query language
with an extended subset of SQL.

PostgreSQL is free and the complete source is available.

This is the meta-package for the PostgreSQL database system.


Required to run:
[databases/postgresql82-server] [databases/postgresql82-client]

Required to build:
[devel/gmake] [devel/bison]

Master sites: (Expand)

SHA1: ec6bd4cd830b5df50c3d6038186cf1af03b609ff
RMD160: b1aa60338c3f6dc886caedc60e924128d64971dd
Filesize: 12425.635 KB

Version history: (Expand)


CVS history: (Expand)


   2010-10-07 17:52:06 by Adam Ciarcinski | Files touched by this commit (6)
Log message:
Changes 8.2.18:

* Use a separate interpreter for each calling SQL userid in PL/Perl and PL/Tcl
* Prevent possible crashes in pg_get_expr() by disallowing it from being called
  with an argument that is not one of the system catalog columns it's intended
  to be used with
* Fix Windows shared-memory allocation code
* Treat exit code 128 (ERROR_WAIT_NO_CHILDREN) as non-fatal on Windows
* Fix possible duplicate scans of UNION ALL member relations
* Fix "cannot handle unplanned sub-select" error
* Reduce PANIC to ERROR in some occasionally-reported btree failure cases, and
  provide additional detail in the resulting error messages
* Prevent show_session_authorization() from crashing within autovacuum
  processes
* Defend against functions returning setof record where not all the returned
  rows are actually of the same rowtype
* Fix possible failure when hashing a pass-by-reference function result
* Take care to fsync the contents of lockfiles (both "postmaster.pid" \ 
and the
  socket lockfile) while writing them
* Avoid recursion while assigning XIDs to heavily-nested subtransactions
* Fix log_line_prefix's %i escape, which could produce junk early in backend
  startup
* Fix possible data corruption in "ALTER TABLE ... SET TABLESPACE" when
  archiving is enabled
* Allow "CREATE DATABASE" and "ALTER DATABASE ... SET \ 
TABLESPACE" to be
  interrupted by query-cancel
* In PL/Python, defend against null pointer results from PyCObject_AsVoidPtr
  and PyCObject_FromVoidPtr
* Improve "contrib/dblink"'s handling of tables containing dropped columns
* Fix connection leak after "duplicate connection name" errors in
  "contrib/dblink"
* Fix "contrib/dblink" to handle connection names longer than 62 bytes
  correctly
   2010-05-20 14:36:15 by Adam Ciarcinski | Files touched by this commit (7)
Log message:
Changes 8.2.17:
* Enforce restrictions in plperl using an opmask applied to the whole
  interpreter, instead of using "Safe.pm"
* Prevent PL/Tcl from executing untrustworthy code from pltcl_modules
* Fix possible crash if a cache reset message is received during
  rebuild of a relcache entry
* Do not allow an unprivileged user to reset superuser-only parameter
  settings
* Avoid possible crash during backend shutdown if shutdown occurs
  when a CONTEXT addition would be made to log entries
* Update pl/perl's "ppport.h" for modern Perl versions
* Fix assorted memory leaks in pl/python
* Prevent infinite recursion in psql when expanding a variable that
  refers to itself
* Fix psql's \copy to not add spaces around a dot within \copy
  (select ...)
* Ensure that "contrib/pgstattuple" functions respond to cancel
  interrupts promptly
* Make server startup deal properly with the case that shmget()
  returns EINVAL for an existing shared memory segment
* Avoid possible crashes in syslogger process on Windows
* Deal more robustly with incomplete time zone information in the
  Windows registry
* Update the set of known Windows time zone names
* Update time zone data files to tzdata release 2010j for DST law
  changes in Argentina, Australian Antarctic, Bangladesh, Mexico,
  Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; also
  historical corrections for Taiwan.
  Also, add PKST (Pakistan Summer Time) to the default set of
  timezone abbreviations.
   2010-04-23 18:03:24 by Adam Ciarcinski | Files touched by this commit (3)
Log message:
Fixed meta package building
   2010-04-12 11:48:49 by Adam Ciarcinski | Files touched by this commit (13)
Log message:
Changes 8.2.16:
* Add new configuration parameter ssl_renegotiation_limit to control
  how often we do session key renegotiation for an SSL connection
* Fix possible deadlock during backend startup
* Fix possible crashes due to not handling errors during relcache
  reload cleanly
* Fix possible crashes when trying to recover from a failure in
   subtransaction start
* Fix server memory leak associated with use of savepoints and a
  client encoding different from server's encoding
* Fix incorrect WAL data emitted during end-of-recovery cleanup of a
  GIST index page split
* Make substring() for bit types treat any negative length as meaning
  "all the rest of the string"
  The previous coding treated only -1 that way, and would produce an
  invalid result value for other negative values, possibly leading to
  a crash (CVE-2010-0442).
* Fix integer-to-bit-string conversions to handle the first
  fractional byte correctly when the output bit width is wider than
  the given integer by something other than a multiple of 8 bits
* Fix some cases of pathologically slow regular expression matching
* Fix the STOP WAL LOCATION entry in backup history files to report
  the next WAL segment's name when the end location is exactly at a
  segment boundary
* Fix some more cases of temporary-file leakage
* Improve constraint exclusion processing of boolean-variable cases,
  in particular make it possible to exclude a partition that has a
  "bool_column = false" constraint
* When reading "pg_hba.conf" and related files, do not treat
  @something as a file inclusion request if the @ appears inside
  quote marks; also, never treat @ by itself as a file inclusion
  request
* Prevent infinite loop on some platforms if a directory is named as
  an inclusion target in "pg_hba.conf" and related files
* Fix possible infinite loop if SSL_read or SSL_write fails without
  setting errno
  This is reportedly possible with some Windows versions of openssl.
* Fix psql's numericlocale option to not format strings it shouldn't
  in latex and troff output formats
* Make psql return the correct exit status (3) when ON_ERROR_STOP and
  --single-transaction are both specified and an error occurs during
  the implied "COMMIT"
* Fix plpgsql failure in one case where a composite column is set to NULL
* Fix possible failure when calling PL/Perl functions from PL/PerlU
  or vice versa
* Add volatile markings in PL/Python to avoid possible
  compiler-specific misbehavior
* Ensure PL/Tcl initializes the Tcl interpreter fully
  The only known symptom of this oversight is that the Tcl clock
  command misbehaves if using Tcl 8.5 or later.
* Prevent crash in "contrib/dblink" when too many key columns are
  specified to a dblink_build_sql_* function
* Fix assorted crashes in "contrib/xml2" caused by sloppy memory
  management
* Make building of "contrib/xml2" more robust on Windows
* Fix race condition in Windows signal handling
  One known symptom of this bug is that rows in pg_listener could be
  dropped under heavy load.
* Update time zone data files to tzdata release 2010e for DST law
  changes in Bangladesh, Chile, Fiji, Mexico, Paraguay, Samoa.
   2010-01-22 21:12:11 by Adam Ciarcinski | Files touched by this commit (6)
Log message:
Added support for gssapi and krb5 authentication as options
   2009-12-16 22:18:31 by Adam Ciarcinski | Files touched by this commit (6)
Log message:
Changes 8.2.15:
* Protect against indirect security threats caused by index functions
  changing session-local state
* Reject SSL certificates containing an embedded null byte in the
  common name (CN) field
* Fix possible crash during backend-startup-time cache initialization
* Prevent signals from interrupting VACUUM at unsafe times
* Fix possible crash due to integer overflow in hash table size
  calculation
* Fix very rare crash in inet/cidr comparisons
* Ensure that shared tuple-level locks held by prepared transactions
  are not ignored
* Fix premature drop of temporary files used for a cursor that is
  accessed within a subtransaction
* Fix incorrect logic for GiST index page splits, when the split
  depends on a non-first column of the index
* Don't error out if recycling or removing an old WAL file fails at
  the end of checkpoint
* Ensure WAL files aren't repeatedly archived on Windows
* Fix PAM password processing to be more robust
* Fix processing of ownership dependencies during CREATE OR REPLACE
  FUNCTION
* Fix bug with calling plperl from plperlu or vice versa
* Fix session-lifespan memory leak when a PL/Perl function is
  redefined
* Ensure that Perl arrays are properly converted to PostgreSQL arrays
  when returned by a set-returning PL/Perl function
* More...
   2009-09-10 12:07:41 by Adam Ciarcinski | Files touched by this commit (4)
Log message:
Changes 8.2.14:
* Force WAL segment switch during pg_start_backup()
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
  security-definer functions
* Make "LOAD" of an already-loaded loadable module into a no-op
* Disallow empty passwords during LDAP authentication
* Fix handling of sub-SELECTs appearing in the arguments of an
  outer-level aggregate function
* Fix bugs associated with fetching a whole-row value from the output
  of a Sort or Materialize plan node
* Revert planner change that disabled partial-index and constraint
  exclusion optimizations when there were more than 100 clauses in an
  AND or OR list
* Fix hash calculation for data type interval
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with 'HH'/'HH12'
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
  and integer datetimes are in use
* Fix calculation of distance between a point and a line segment
* Fix money data type to work in locales where currency amounts have
  no fractional digits, e.g. Japan
* Properly round datetime input like 00:12:57.9999999999999999999999999999
* Fix poor choice of page split point in GiST R-tree operator classes
* Avoid performance degradation in bulk inserts into GIN indexes when
  the input values are (nearly) in sorted order
   2009-03-20 17:02:13 by Adam Ciarcinski | Files touched by this commit (4)
Log message:
Changes 8.2.13:
* Prevent error recursion crashes when encoding conversion fails.
* Disallow "CREATE CONVERSION" with the wrong encodings for the
  specified conversion function.
* Fix core dump when to_char() is given format codes that are
  inappropriate for the type of the data argument.
* Fix possible failure in "contrib/tsearch2" when C locale is used
  with a multi-byte encoding.
* Fix extreme inefficiency in "contrib/tsearch2" parser's handling of
  an email-like string containing multiple @ characters.
* Fix decompilation of CASE WHEN with an implicit coercion.
* Fix possible misassignment of the owner of a TOAST table's rowtype.
* Fix PL/pgSQL to not treat INTO after "INSERT" as an INTO-variables
  clause anywhere in the string, not only at the start; in
  particular, don't fail for "INSERT INTO" within "CREATE RULE".
* Clean up PL/pgSQL error status variables fully at block exit.
* Retry failed calls to CallNamedPipe() on Windows.
* Add MUST (Mauritius Island Summer Time) to the default list of
  known timezone abbreviations.