The NetBSD Project

CVS log for pkgsrc/databases/postgresql81-server/Attic/PLIST

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql81-server

Request diff between arbitrary revisions


Default branch: MAIN


Revision 1.11, Fri Aug 14 19:41:47 2009 UTC (10 years ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2012Q4-base, pkgsrc-2012Q4, pkgsrc-2011Q4-base, pkgsrc-2011Q4, pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2009Q4-base, pkgsrc-2009Q4, HEAD
Changes since 1.10: +1 -1 lines
FILE REMOVED

Retire PostgreSQL 8.1.

Revision 1.10 / (download) - annotate - [select for diffs], Sun Jun 14 17:43:21 2009 UTC (10 years, 2 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2009Q2-base, pkgsrc-2009Q2
Changes since 1.9: +1 -25 lines
Diff to previous 1.9 (colored)

Remove @dirrm entries from PLISTs

Revision 1.9 / (download) - annotate - [select for diffs], Sat Feb 7 17:43:54 2009 UTC (10 years, 6 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2009Q1-base, pkgsrc-2009Q1
Changes since 1.8: +2 -1 lines
Diff to previous 1.8 (colored)

Changes 8.1.16:
* Fix crash in autovacuum
  The crash occurs only after vacuuming a whole database for
  anti-transaction-wraparound purposes, which means that it occurs
  infrequently and is hard to track down.
* Improve handling of URLs in headline() function
* Improve handling of overlength headlines in headline() function
* Prevent possible Assert failure or misconversion if an encoding
  conversion is created with the wrong conversion function for the
  specified pair of encodings
* Avoid unnecessary locking of small tables in "VACUUM"
* Ensure that the contents of a holdable cursor don't depend on the
  contents of TOAST tables
* Fix uninitialized variables in "contrib/tsearch2"'s get_covers()
  function
* Fix configure script to properly report failure when unable to
  obtain linkage information for PL/Perl
* Make all documentation reference pgsql-bugs and/or pgsql-hackers as
  appropriate, instead of the now-decommissioned pgsql-ports and
  pgsql-patches mailing lists
* Update time zone data files to tzdata release 2009a (for Kathmandu
  and historical DST corrections in Switzerland, Cuba)

Revision 1.8 / (download) - annotate - [select for diffs], Tue Nov 4 09:52:29 2008 UTC (10 years, 9 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2008Q4-base, pkgsrc-2008Q4
Changes since 1.7: +2 -1 lines
Diff to previous 1.7 (colored)

Changes 8.1.15:
* Fix GiST index corruption due to marking the wrong index entry
  "dead" after a deletion.
  This would result in index searches failing to find rows they
  should have found.
* Fix backend crash when the client encoding cannot represent a
  localized error message.
  We have addressed similar issues before, but it would still fail if
  the "character has no equivalent" message itself couldn't be
  converted. The fix is to disable localization and send the plain
  ASCII error message when we detect such a situation.
* Fix possible crash when deeply nested functions are invoked from a
  trigger.
* Fix mis-expansion of rule queries when a sub-SELECT appears in a
  function call in FROM, a multi-row VALUES list, or a RETURNING list
* Ensure an error is reported when a newly-defined PL/pgSQL trigger
  function is invoked as a normal function.
* Prevent possible collision of relfilenode numbers when moving a
  table to another tablespace with "ALTER SET TABLESPACE".
  The command tried to re-use the existing filename, instead of
  picking one that is known unused in the destination directory.
* Fix incorrect tsearch2 headline generation when single query item
  matches first word of text.
* Fix improper display of fractional seconds in interval values when
  using a non-ISO datestyle in an "--enable-integer-datetimes" build
* Ensure SPI_getvalue and SPI_getbinval behave correctly when the
  passed tuple and tuple descriptor have different numbers of columns.
* Fix ecpg's parsing of "CREATE ROLE".
* Fix recent breakage of pg_ctl restart.
* Update time zone data files to tzdata release 2008i (for DST law
  changes in Argentina, Brazil, Mauritius, Syria)

Revision 1.7 / (download) - annotate - [select for diffs], Mon Oct 6 09:46:31 2008 UTC (10 years, 10 months ago) by adam
Branch: MAIN
Changes since 1.6: +2 -1 lines
Diff to previous 1.6 (colored)

Changes 8.1.14:
Bug-fix release, see HISTORY for details.

Revision 1.6 / (download) - annotate - [select for diffs], Fri Jun 20 08:27:58 2008 UTC (11 years, 1 month ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, cwrapper, cube-native-xorg-base, cube-native-xorg
Changes since 1.5: +4 -1 lines
Diff to previous 1.5 (colored)

Changes 8.1.13:
* Make pg_get_ruledef() parenthesize negative constants (Tom)
  Before this fix, a negative constant in a view or rule might be
  dumped as, say, -42::integer, which is subtly incorrect: it should
  be (-42)::integer due to operator precedence rules. Usually this
  would make little difference, but it could interact with another
  recent patch to cause PostgreSQL to reject what had been a valid
  "SELECT DISTINCT" view query. Since this could result in pg_dump
  output failing to reload, it is being treated as a high-priority
  fix. The only released versions in which dump output is actually
  incorrect are 8.3.1 and 8.2.7.
* Make "ALTER AGGREGATE ... OWNER TO" update pg_shdepend (Tom)
  This oversight could lead to problems if the aggregate was later
  involved in a "DROP OWNED" or "REASSIGN OWNED" operation.

Revision 1.4.4.1 / (download) - annotate - [select for diffs], Thu Jan 10 07:33:56 2008 UTC (11 years, 7 months ago) by ghen
Branch: pkgsrc-2007Q4
Changes since 1.4: +3 -1 lines
Diff to previous 1.4 (colored) next main 1.5 (colored)

Pullup ticket 2259 - requested by adam
security updates for postgresql

- pkgsrc/databases/postgresql80/Makefile.common		1.31
- pkgsrc/databases/postgresql80/distinfo		1.20
- pkgsrc/databases/postgresql80-client/PLIST		1.18
- pkgsrc/databases/postgresql80-server/PLIST		1.11
- pkgsrc/databases/postgresql81/Makefile.common		1.15
- pkgsrc/databases/postgresql81/distinfo		1.11
- pkgsrc/databases/postgresql81-client/PLIST		1.9
- pkgsrc/databases/postgresql81-server/PLIST		1.5
- pkgsrc/databases/postgresql82/Makefile.common		1.8
- pkgsrc/databases/postgresql82/distinfo		1.10
- pkgsrc/databases/postgresql82/patches/patch-am	1.3
- pkgsrc/databases/postgresql82-client/PLIST		1.7
- pkgsrc/databases/postgresql82-server/PLIST		1.5
- pkgsrc/databases/postgresql82-tsearch2/Makefile	1.3

   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Jan  7 20:14:10 UTC 2008

   Modified Files:
	   pkgsrc/databases/postgresql80: Makefile.common distinfo
	   pkgsrc/databases/postgresql80-client: PLIST
	   pkgsrc/databases/postgresql80-server: PLIST

   Log Message:
   Changes 8.0.15:
   This release contains a variety of fixes from 8.0.14, including fixes
   for significant security issues.

   This is the last 8.0.X release for which the PostgreSQL community will
   produce binary packages for Windows. Windows users are encouraged to
   move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X
   that are impractical to back-port. 8.0.X will continue to be supported
   on other platforms.
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Jan  7 20:14:24 UTC 2008

   Modified Files:
	   pkgsrc/databases/postgresql81: Makefile.common distinfo
	   pkgsrc/databases/postgresql81-client: PLIST
	   pkgsrc/databases/postgresql81-server: PLIST

   Log Message:
   Changes 8.1.11:
   This release contains a variety of fixes from 8.1.10, including fixes
   for significant security issues.

   This is the last 8.1.X release for which the PostgreSQL community will
   produce binary packages for Windows. Windows users are encouraged to
   move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X
   that are impractical to back-port. 8.1.X will continue to be supported
   on other platforms.
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Jan  7 20:14:36 UTC 2008

   Modified Files:
	   pkgsrc/databases/postgresql82: Makefile.common distinfo
	   pkgsrc/databases/postgresql82-client: PLIST
	   pkgsrc/databases/postgresql82-server: PLIST
	   pkgsrc/databases/postgresql82-tsearch2: Makefile
	   pkgsrc/databases/postgresql82/patches: patch-am

   Log Message:
   Changes 8.2.6:
   This release contains a variety of fixes from 8.2.5, including fixes
   for significant security issues.

Revision 1.5 / (download) - annotate - [select for diffs], Mon Jan 7 20:14:24 2008 UTC (11 years, 7 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2008Q1-base, pkgsrc-2008Q1
Changes since 1.4: +3 -1 lines
Diff to previous 1.4 (colored)

Changes 8.1.11:
This release contains a variety of fixes from 8.1.10, including fixes
for significant security issues.

This is the last 8.1.X release for which the PostgreSQL community will
produce binary packages for Windows. Windows users are encouraged to
move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X
that are impractical to back-port. 8.1.X will continue to be supported
on other platforms.

Revision 1.4 / (download) - annotate - [select for diffs], Wed Sep 19 20:01:58 2007 UTC (11 years, 11 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2007Q4-base, pkgsrc-2007Q3-base, pkgsrc-2007Q3
Branch point for: pkgsrc-2007Q4
Changes since 1.3: +2 -1 lines
Diff to previous 1.3 (colored)

Changes 8.1.10:
* Prevent index corruption when a transaction inserts rows and then
  aborts close to the end of a concurrent "VACUUM" on the same table
* Make "CREATE DOMAIN ... DEFAULT NULL" work properly
* Allow the interval data type to accept input consisting only of
  milliseconds or microseconds
* Speed up rtree index insertion
* Fix excessive logging of SSL error messages
* Fix logging so that log messages are never interleaved when using
  the syslogger process
* Fix crash when log_min_error_statement logging runs out of memory
* Fix incorrect handling of some foreign-key corner cases
* Prevent "REINDEX" and "CLUSTER" from failing due to attempting to
  process temporary tables of other sessions
* Update the time zone database rules, particularly New Zealand's
  upcoming changes
* Windows socket improvements
* Suppress timezone name (%Z) in log timestamps on Windows because of
  possible encoding mismatches
* Require non-superusers who use "/contrib/dblink" to use only
  password authentication, as a security measure

Revision 1.2.2.1 / (download) - annotate - [select for diffs], Sat May 12 14:39:51 2007 UTC (12 years, 3 months ago) by salo
Branch: pkgsrc-2007Q1
Changes since 1.2: +7 -1 lines
Diff to previous 1.2 (colored) next main 1.3 (colored)

Pullup ticket 2080 - requested by ghen
security update for postgresql

Revisions pulled up:
- pkgsrc/databases/postgresql80/Makefile.common		1.28, 1.29
- pkgsrc/databases/postgresql80/distinfo		1.18
- pkgsrc/databases/postgresql80-client/PLIST		1.16
- pkgsrc/databases/postgresql80-server/Makefile		1.24
- pkgsrc/databases/postgresql80-server/PLIST		1.9
- pkgsrc/databases/postgresql81/Makefile.common		1.11, 1.12, 1.13
- pkgsrc/databases/postgresql81/distinfo		1.9
- pkgsrc/databases/postgresql81-client/PLIST		1.7
- pkgsrc/databases/postgresql81-server/PLIST		1.3
- pkgsrc/databases/postgresql82/Makefile.common		1.5, 1.6
- pkgsrc/databases/postgresql82/distinfo		1.7
- pkgsrc/databases/postgresql82-client/PLIST		1.5
- pkgsrc/databases/postgresql82-server/PLIST		1.3

   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Apr 30 13:37:01 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql82: Makefile.common distinfo
   	pkgsrc/databases/postgresql82-client: PLIST
   	pkgsrc/databases/postgresql82-server: PLIST

   Log Message:
   Changes 8.2.4:
   * Support explicit placement of the temporary-table schema within
     search_path, and disable searching it for functions and operators
   * Fix shared_preload_libraries for Windows by forcing reload in each
     backend
   * Fix to_char() so it properly upper/lower cases localized day or
     month names
   * "/contrib/tsearch2" crash fixes
   * Require "COMMIT PREPARED" to be executed in the same database as
     the transaction was prepared in
   * Allow "pg_dump" to do binary backups larger than two gigabytes on
     Windows
   * New traditional (Taiwan) Chinese FAQ
   * Prevent the statistics collector from writing to disk too
     frequently
   * Fix potential-data-corruption bug in how "VACUUM FULL" handles
     "UPDATE" chains
   * Fix bug in domains that use array types
   * Fix "pg_dump" so it can dump a serial column's sequence using "-t"
     when not also dumping the owning table
   * Planner fixes, including improving outer join and bitmap scan
     selection logic
   * Fix possible wrong answers or crash when a PL/pgSQL function tries
     to RETURN from within an EXCEPTION block
   * Fix PANIC during enlargement of a hash index
   * Fix POSIX-style timezone specs to follow new USA DST rules
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Apr 30 13:37:23 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql81: Makefile.common distinfo
   	pkgsrc/databases/postgresql81-client: PLIST
   	pkgsrc/databases/postgresql81-server: PLIST

   Log Message:
   Changes 8.1.9:
   * Support explicit placement of the temporary-table schema within
     search_path, and disable searching it for functions and operators
   * "/contrib/tsearch2" crash fixes
   * Require "COMMIT PREPARED" to be executed in the same database as
     the transaction was prepared in
   * Fix potential-data-corruption bug in how "VACUUM FULL" handles
     "UPDATE" chains
   * Planner fixes, including improving outer join and bitmap scan
     selection logic
   * Fix PANIC during enlargement of a hash index (bug introduced in
     8.1.6)
   * Fix POSIX-style timezone specs to follow new USA DST rules
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Apr 30 13:37:36 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql80: Makefile.common distinfo

   Log Message:
   Changes 8.0.13:
   * Support explicit placement of the temporary-table schema within
     search_path, and disable searching it for functions and operators
   * "/contrib/tsearch2" crash fixes
   * Fix potential-data-corruption bug in how "VACUUM FULL" handles
     "UPDATE" chains
   * Fix PANIC during enlargement of a hash index (bug introduced in
     8.0.10)
   * Fix POSIX-style timezone specs to follow new USA DST rules
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 19:44:52 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql81: Makefile.common

   Log Message:
   CONFLICTS fix
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 19:45:52 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql82: Makefile.common

   Log Message:
   CONFLICTS fix
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 20:04:06 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql80: Makefile.common
   	pkgsrc/databases/postgresql80-client: PLIST

   Log Message:
   CONFLICTS and PLIST fix
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 20:04:52 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql81: Makefile.common

   Log Message:
   CONFLICTS fix
---
   Module Name:		pkgsrc
   Committed By:	joerg
   Date:		Tue May  8 15:58:39 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql80-server: Makefile PLIST

   Log Message:
   Fix PLIST after last update.

Revision 1.3 / (download) - annotate - [select for diffs], Mon Apr 30 13:37:22 2007 UTC (12 years, 3 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2007Q2-base, pkgsrc-2007Q2
Changes since 1.2: +7 -1 lines
Diff to previous 1.2 (colored)

Changes 8.1.9:
* Support explicit placement of the temporary-table schema within
  search_path, and disable searching it for functions and operators
* "/contrib/tsearch2" crash fixes
* Require "COMMIT PREPARED" to be executed in the same database as
  the transaction was prepared in
* Fix potential-data-corruption bug in how "VACUUM FULL" handles
  "UPDATE" chains
* Planner fixes, including improving outer join and bitmap scan
  selection logic
* Fix PANIC during enlargement of a hash index (bug introduced in
  8.1.6)
* Fix POSIX-style timezone specs to follow new USA DST rules

Revision 1.2 / (download) - annotate - [select for diffs], Mon Jan 8 18:55:39 2007 UTC (12 years, 7 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2007Q1-base
Branch point for: pkgsrc-2007Q1
Changes since 1.1: +13 -16 lines
Diff to previous 1.1 (colored)

Changes 8.1.6:
* Improve handling of getaddrinfo() on AIX
  This fixes a problem with starting the statistics collector, among
  other things.
* Fix pg_restore to handle a tar-format backup that contains large
  objects (blobs) with comments
* Fix "failed to re-find parent key" errors in "VACUUM"
* Clean out "pg_internal.init" cache files during server restart
  This avoids a hazard that the cache files might contain stale data
  after PITR recovery.
* Fix race condition for truncation of a large relation across a
  gigabyte boundary by "VACUUM"
* Fix bug causing needless deadlock errors on row-level locks
* Fix bugs affecting multi-gigabyte hash indexes
* Fix possible deadlock in Windows signal handling
* Fix error when constructing an ARRAY[] made up of multiple empty
  elements
* Fix ecpg memory leak during connection
* Fix for Darwin (OS X) compilation
* to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for
  new initdb installs
  This is because lc_numeric can potentially change the output of
  these functions.
* Improve index usage of regular expressions that use parentheses
  This improves psql \d performance also.
* Update timezone database
  This affects Australian and Canadian daylight-savings rules in
  particular.

Revision 1.1.1.1 / (download) - annotate - [select for diffs] (vendor branch), Mon Mar 20 14:45:52 2006 UTC (13 years, 5 months ago) by uebayasi
Branch: TNF
CVS Tags: pkgsrc-base, pkgsrc-2006Q4-base, pkgsrc-2006Q4, pkgsrc-2006Q3-base, pkgsrc-2006Q3, pkgsrc-2006Q2-base, pkgsrc-2006Q2, pkgsrc-2006Q1-base, pkgsrc-2006Q1
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

Initial import of PostgreSQL 8.1.3, from pkgsrc-wip.

This is an overview of new features in 8.1.0 against 8.0.x.  8.1.3 includes
many bug fixes since 8.1.0.  Please read documentation of the detailed changes
and procedure of data migration.

Overview

   Major changes in this release:

   Improve concurrent access to the shared buffer cache (Tom)
          Access to the shared buffer cache was identified as a
          significant scalability problem, particularly on multi-CPU
          systems. In this release, the way that locking is done in the
          buffer manager has been overhauled to reduce lock contention and
          improve scalability. The buffer manager has also been changed to
          use a "clock sweep" replacement policy.

   Allow index scans to use an intermediate in-memory bitmap (Tom)
          In previous releases, only a single index could be used to do
          lookups on a table. With this feature, if a query has "WHERE
          tab.col1 = 4 and tab.col2 = 9", and there is no multicolumn
          index on col1 and col2, but there is an index on col1 and
          another on col2, it is possible to search both indexes and
          combine the results in memory, then do heap fetches for only the
          rows matching both the col1 and col2 restrictions. This is very
          useful in environments that have a lot of unstructured queries
          where it is impossible to create indexes that match all possible
          access conditions. Bitmap scans are useful even with a single
          index, as they reduce the amount of random access needed; a
          bitmap index scan is efficient for retrieving fairly large
          fractions of the complete table, whereas plain index scans are
          not.

   Add two-phase commit (Heikki Linnakangas, Alvaro, Tom)
          Two-phase commit allows transactions to be "prepared" on several
          computers, and once all computers have successfully prepared
          their transactions (none failed), all transactions can be
          committed. Even if a machine crashes after a prepare, the
          prepared transaction can be committed after the machine is
          restarted. New syntax includes "PREPARE TRANSACTION" and
          "COMMIT/ROLLBACK PREPARED". A new system view pg_prepared_xacts
          has also been added.

   Create a new role system that replaces users and groups (Stephen Frost)
          Roles are a combination of users and groups. Like users, they
          can have login capability, and like groups, a role can have
          other roles as members. Roles basically remove the distinction
          between users and groups. For example, a role can:

          + Have login capability (optionally)
          + Own objects
          + Hold access permissions for database objects
          + Inherit permissions from other roles it is a member of

          Once a user logs into a role, she obtains capabilities of the
          login role plus any inherited roles, and can use "SET ROLE" to
          switch to other roles she is a member of. This feature is a
          generalization of the SQL standard's concept of roles. This
          change also replaces pg_shadow and pg_group by new role-capable
          catalogs pg_authid and pg_auth_members. The old tables are
          redefined as read-only views on the new role tables.

   Automatically use indexes for MIN() and MAX() (Tom)
          In previous releases, the only way to use an index for MIN() or
          MAX() was to rewrite the query as "SELECT col FROM tab ORDER BY
          col LIMIT 1". Index usage now happens automatically.

   Move /contrib/pg_autovacuum into the main server (Alvaro)
          Integrating autovacuum into the server allows it to be
          automatically started and stopped in sync with the database
          server, and allows autovacuum to be configured from
          "postgresql.conf".

   Add shared row level locks using SELECT ... FOR SHARE (Alvaro)
          While PostgreSQL's MVCC locking allows "SELECT" to never be
          blocked by writers and therefore does not need shared row locks
          for typical operations, shared locks are useful for applications
          that require shared row locking. In particular this reduces the
          locking requirements imposed by referential integrity checks.

   Add dependencies on shared objects, specifically roles (Alvaro)
          This extension of the dependency mechanism prevents roles from
          being dropped while there are still database objects they own.
          Formerly it was possible to accidentally "orphan" objects by
          deleting their owner. While this could be recovered from, it was
          messy and unpleasant.

   Improve performance for partitioned tables (Simon)
          The new constraint_exclusion configuration parameter avoids
          lookups on child tables where constraints indicate that no
          matching rows exist in the child table.

          This allows for a basic type of table partitioning. If child
          tables store separate key ranges and this is enforced using
          appropriate "CHECK" constraints, the optimizer will skip child
          table accesses when the constraint guarantees no matching rows
          exist in the child table.

Revision 1.1 / (download) - annotate - [select for diffs], Mon Mar 20 14:45:52 2006 UTC (13 years, 5 months ago) by uebayasi
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.




CVSweb <webmaster@jp.NetBSD.org>