The NetBSD Project

CVS log for pkgsrc/databases/postgresql74-docs/Attic/PLIST

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql74-docs

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.9
Wed Dec 27 15:57:37 2006 UTC (19 years, 10 months ago) by joerg
Branches: 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, pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, pkgsrc-2008Q1-base, pkgsrc-2008Q1, pkgsrc-2007Q4-base, pkgsrc-2007Q4, pkgsrc-2007Q3-base, pkgsrc-2007Q3, pkgsrc-2007Q2-base, pkgsrc-2007Q2, pkgsrc-2007Q1-base, pkgsrc-2007Q1, pkgsrc-2006Q4-base, pkgsrc-2006Q4, cube-native-xorg-base, cube-native-xorg, HEAD
FILE REMOVED
Changes since revision 1.8: +1 -1 lines
As discussed on tech-pkg, remove PostgreSQL 7.4.

Revision 1.6.4.1: download - view: text, markup, annotated - select for diffs
Tue Oct 31 10:18:19 2006 UTC (20 years ago) by ghen
Branches: pkgsrc-2006Q3
Diff to: previous 1.6: preferred, colored; next MAIN 1.7: preferred, colored
Changes since revision 1.6: +4 -1 lines
Pullup ticket 1879 - requested by joerg
security updates for postgresql

- pkgsrc/databases/postgresql74/Makefile.common		1.37
- pkgsrc/databases/postgresql74/distinfo		1.22
- pkgsrc/databases/postgresql74-client/Makefile		1.21
- pkgsrc/databases/postgresql74-contrib/Makefile	1.14
- pkgsrc/databases/postgresql74-docs/Makefile		1.10-1.11
- pkgsrc/databases/postgresql74-docs/PLIST		1.7-1.8
- pkgsrc/databases/postgresql74-lib/Makefile		1.26
- pkgsrc/databases/postgresql74-server/Makefile		1.27
- pkgsrc/databases/postgresql74-server/PLIST		1.6
- pkgsrc/databases/postgresql80/Makefile.common		1.24
- pkgsrc/databases/postgresql80/distinfo		1.14
- pkgsrc/databases/postgresql80/options.mk		1.4
- pkgsrc/databases/postgresql80-client/Makefile		1.17
- pkgsrc/databases/postgresql80-client/PLIST		1.12
- pkgsrc/databases/postgresql80-server/Makefile		1.22
- pkgsrc/databases/postgresql81/Makefile.common		1.7
- pkgsrc/databases/postgresql81/distinfo		1.3
- pkgsrc/databases/postgresql81/options.mk		1.2
- pkgsrc/databases/postgresql81-client/Makefile		1.4
- pkgsrc/databases/postgresql81-client/PLIST		1.3
- pkgsrc/databases/postgresql81-server/Makefile		1.5

   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:31:24 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81: Makefile.common distinfo options.mk

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:33:21 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81-client: Makefile PLIST

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:34:17 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81-server: Makefile

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:38:57 UTC 2006

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

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:39:09 UTC 2006

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

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:39:19 UTC 2006

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

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 19:24:07 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql74: Makefile.common distinfo
	pkgsrc/databases/postgresql74-client: Makefile
	pkgsrc/databases/postgresql74-contrib: Makefile
	pkgsrc/databases/postgresql74-docs: Makefile PLIST
	pkgsrc/databases/postgresql74-lib: Makefile
	pkgsrc/databases/postgresql74-server: Makefile PLIST

   Log Message:
   Changes 7.4.14:
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Fix backslash escaping in /contrib/dbmirror
   * Adjust regression tests for recent changes in US DST laws
---
   Module Name:	pkgsrc
   Committed By:	ghen
   Date:		Tue Oct 31 10:12:00 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql74-docs: Makefile PLIST

   Log Message:
   Fix PLIST, bump PKGREVISION.

Revision 1.8: download - view: text, markup, annotated - select for diffs
Tue Oct 31 10:12:00 2006 UTC (20 years ago) by ghen
Branches: MAIN
Diff to: previous 1.7: preferred, colored
Changes since revision 1.7: +2 -1 lines
Fix PLIST, bump PKGREVISION.

Revision 1.7: download - view: text, markup, annotated - select for diffs
Wed Oct 18 19:24:07 2006 UTC (20 years, 1 month ago) by adam
Branches: MAIN
Diff to: previous 1.6: preferred, colored
Changes since revision 1.6: +3 -1 lines
Changes 7.4.14:
* Fix core dump when an untyped literal is taken as ANYARRAY
* Fix string_to_array() to handle overlapping matches for the
  separator string
  For example, string_to_array('123xx456xxx789', 'xx').
* Fix corner cases in pattern matching for psql's \d commands
* Fix index-corrupting bugs in /contrib/ltree (Teodor)
* Fix backslash escaping in /contrib/dbmirror
* Adjust regression tests for recent changes in US DST laws

Revision 1.5.2.1: download - view: text, markup, annotated - select for diffs
Wed May 31 11:53:44 2006 UTC (20 years, 5 months ago) by salo
Branches: pkgsrc-2006Q1
Diff to: previous 1.5: preferred, colored; next MAIN 1.6: preferred, colored
Changes since revision 1.5: +3 -1 lines
Pullup ticket 1680 - requested by joerg
security updates for postgresql

Revisions pulled up:
- pkgsrc/databases/postgresql73/Makefile.common		1.19
- pkgsrc/databases/postgresql73/distinfo		1.13
- pkgsrc/databases/postgresql73-docs/PLIST		1.7
- pkgsrc/databases/postgresql74/Makefile.common		1.36
- pkgsrc/databases/postgresql74/distinfo		1.21
- pkgsrc/databases/postgresql74-docs/PLIST		1.6
- pkgsrc/databases/postgresql80/Makefile.common		1.23
- pkgsrc/databases/postgresql80/distinfo		1.13
- pkgsrc/databases/postgresql80-client/PLIST		1.11
- pkgsrc/databases/postgresql81/Makefile.common		1.6
- pkgsrc/databases/postgresql81/distinfo		1.2
- pkgsrc/databases/postgresql81-client/PLIST		1.2

   Module Name:	pkgsrc
   Committed By:	joerg
   Date:		Fri May 26 17:47:58 UTC 2006

   Modified Files:
   	pkgsrc/databases/postgresql73: Makefile.common distinfo
   	pkgsrc/databases/postgresql73-docs: PLIST
   	pkgsrc/databases/postgresql74: Makefile.common distinfo
   	pkgsrc/databases/postgresql74-docs: PLIST
   	pkgsrc/databases/postgresql80: Makefile.common distinfo
   	pkgsrc/databases/postgresql80-client: PLIST
   	pkgsrc/databases/postgresql81: Makefile.common distinfo
   	pkgsrc/databases/postgresql81-client: PLIST

   Log Message:
   Update PostgreSQL to 7.3.15, 7.4.13, 8.0.8 and 8.1.4 respectively.

   Common to all versions:
        * Change the server to reject invalidly-encoded multibyte characters
          in all cases (Tatsuo, Tom) While PostgreSQL has been moving in this
          direction for some time, the checks are now applied uniformly to
          all encodings and all textual input, and are now always errors not
          merely warnings. This change defends against SQL-injection attacks
          of the type described in CVE-2006-2313.
        * Reject unsafe uses of \' in string literals As a server-side
          defense against SQL-injection attacks of the type described in
          CVE-2006-2314, the server now only accepts '' and not \' as a
          representation of ASCII single quote in SQL string literals. By
          default, \' is  rejected  only  when  client_encoding is set to a
          client-only encoding (SJIS, BIG5, GBK, GB18030, or UHC), which is
          the scenario in which SQL injection is possible. A new
          configuration parameter backslash_quote is available  to  adjust
          this  behavior  when needed. Note that full security against
          CVE-2006-2314 may require client-side changes; the purpose of
          backslash_quote is in part to make it obvious that insecure clients
          are insecure.
        * Modify libpq's string-escaping routines to be aware of encoding
          considerations This  fixes  libpq-using applications for the
          security issues described in CVE-2006-2313 and CVE-2006-2314.
          Applications that use multiple PostgreSQL connections concurrently
          should migrate to PQescapeStringConn() and PQescapeByteaConn() to
          ensure that escaping is done correctly for the settings in use in
          each database connection. Applications that do string escaping
          "by hand" should be modified to rely on library routines instead.
        * Fix some incorrect encoding conversion functions win1251_to_iso,
          alt_to_iso, euc_tw_to_big5, euc_tw_to_mic, mic_to_euc_tw were all
          broken to varying extents.
        * Clean up stray remaining uses of \' in strings (Bruce, Jan)
        * Fix server to use custom DH SSL parameters correctly (Michael Fuhr)
        * Fix various minor memory leaks

   Additionally for 7.4.13 and later:
        * Fix bug that sometimes caused OR'd index scans to miss rows they
          should have returned
        * Fix WAL replay for case where a btree index has been truncated
        * Fix SIMILAR TO for patterns involving | (Tom)
        * Fix for Bonjour on Intel Macs (Ashley Clark)

   Additionally for 8.0.8 and 8.1.4:
        * Fix SELECT INTO and CREATE TABLE AS to create tables in the
          default tablespace, not the base directory (Kris Jurka)
        * Fix problem with password prompting on some Win32 systems (Robert
          Kinberg)

   Additionally for 8.1.4:
        * Fix weak key selection in pgcrypto (Marko Kreen)
          Errors in fortuna PRNG reseeding logic could cause a predictable
          session key to be selected by pgp_sym_encrypt() in some cases.
          This only affects non-OpenSSL-using builds.
        * Make autovacuum visible in pg_stat_activity (Alvaro)
        * Disable full_page_writes (Tom)
          In certain cases, having full_page_writes off would cause crash
          recovery to fail. A proper fix will appear in 8.2; for now it's
          just disabled.
        * Various planner fixes, particularly for bitmap index scans and
          MIN/MAX optimization (Tom)
        * Fix incorrect optimization in merge join (Tom)
          Outer joins could sometimes emit multiple copies of unmatched
          rows.
        * Fix crash from using and modifying a plpgsql function in the same
          transaction
        * Improve qsort performance (Dann Corbit)
          Currently this code is only used on Solaris.
        * Improve pg_dump's handling of default values for domains
        * Fix pg_dumpall to handle identically-named users and groups
          reasonably (only possible when dumping from a pre-8.1 server) (Tom)
          The user and group will be merged into a single role with LOGIN
          permission. Formerly the merged role wouldn't have LOGIN
          permission, making it unusable as a user.
        * Fix pg_restore -n to work as documented (Tom)

Revision 1.6: download - view: text, markup, annotated - select for diffs
Fri May 26 17:47:58 2006 UTC (20 years, 5 months ago) by joerg
Branches: MAIN
CVS tags: pkgsrc-2006Q3-base, pkgsrc-2006Q2-base, pkgsrc-2006Q2
Branch point for: pkgsrc-2006Q3
Diff to: previous 1.5: preferred, colored
Changes since revision 1.5: +3 -1 lines
Update PostgreSQL to 7.3.15, 7.4.13, 8.0.8 and 8.1.4 respectively.

Common to all versions:
     * Change the server to reject invalidly-encoded multibyte characters
       in all cases (Tatsuo, Tom) While PostgreSQL has been moving in this
       direction for some time, the checks are now applied uniformly to
       all encodings and all textual input, and are now always errors not
       merely warnings. This change defends against SQL-injection attacks
       of the type described in CVE-2006-2313.
     * Reject unsafe uses of \' in string literals As a server-side
       defense against SQL-injection attacks of the type described in
       CVE-2006-2314, the server now only accepts '' and not \' as a
       representation of ASCII single quote in SQL string literals. By
       default, \' is  rejected  only  when  client_encoding is set to a
       client-only encoding (SJIS, BIG5, GBK, GB18030, or UHC), which is
       the scenario in which SQL injection is possible. A new
       configuration parameter backslash_quote is available  to  adjust
       this  behavior  when needed. Note that full security against
       CVE-2006-2314 may require client-side changes; the purpose of
       backslash_quote is in part to make it obvious that insecure clients
       are insecure.
     * Modify libpq's string-escaping routines to be aware of encoding
       considerations This  fixes  libpq-using applications for the
       security issues described in CVE-2006-2313 and CVE-2006-2314.
       Applications that use multiple PostgreSQL connections concurrently
       should migrate to PQescapeStringConn() and PQescapeByteaConn() to
       ensure that escaping is done correctly for the settings in use in
       each database connection. Applications that do string escaping
       "by hand" should be modified to rely on library routines instead.
     * Fix some incorrect encoding conversion functions win1251_to_iso,
       alt_to_iso, euc_tw_to_big5, euc_tw_to_mic, mic_to_euc_tw were all
       broken to varying extents.
     * Clean up stray remaining uses of \' in strings (Bruce, Jan)
     * Fix server to use custom DH SSL parameters correctly (Michael Fuhr)
     * Fix various minor memory leaks

Additionally for 7.4.13 and later:
     * Fix bug that sometimes caused OR'd index scans to miss rows they
       should have returned
     * Fix WAL replay for case where a btree index has been truncated
     * Fix SIMILAR TO for patterns involving | (Tom)
     * Fix for Bonjour on Intel Macs (Ashley Clark)

Additionally for 8.0.8 and 8.1.4:
     * Fix SELECT INTO and CREATE TABLE AS to create tables in the
       default tablespace, not the base directory (Kris Jurka)
     * Fix problem with password prompting on some Win32 systems (Robert
       Kinberg)

Additionally for 8.1.4:
     * Fix weak key selection in pgcrypto (Marko Kreen)
       Errors in fortuna PRNG reseeding logic could cause a predictable
       session key to be selected by pgp_sym_encrypt() in some cases.
       This only affects non-OpenSSL-using builds.
     * Make autovacuum visible in pg_stat_activity (Alvaro)
     * Disable full_page_writes (Tom)
       In certain cases, having full_page_writes off would cause crash
       recovery to fail. A proper fix will appear in 8.2; for now it's
       just disabled.
     * Various planner fixes, particularly for bitmap index scans and
       MIN/MAX optimization (Tom)
     * Fix incorrect optimization in merge join (Tom)
       Outer joins could sometimes emit multiple copies of unmatched
       rows.
     * Fix crash from using and modifying a plpgsql function in the same
       transaction
     * Improve qsort performance (Dann Corbit)
       Currently this code is only used on Solaris.
     * Improve pg_dump's handling of default values for domains
     * Fix pg_dumpall to handle identically-named users and groups
       reasonably (only possible when dumping from a pre-8.1 server) (Tom)
       The user and group will be merged into a single role with LOGIN
       permission. Formerly the merged role wouldn't have LOGIN
       permission, making it unusable as a user.
     * Fix pg_restore -n to work as documented (Tom)

Revision 1.4.4.1: download - view: text, markup, annotated - select for diffs
Sun Feb 26 22:01:11 2006 UTC (20 years, 8 months ago) by seb
Branches: pkgsrc-2005Q4
Diff to: previous 1.4: preferred, colored; next MAIN 1.5: preferred, colored
Changes since revision 1.4: +9 -1 lines
Pullup ticket 1163 - requested by Joerg Sonnenberger
mostly sync databases/postgresql74, databases/tcl-postgresql74, and databases/postgresql74-{client,contrib,docs,lib,plperl,plpython,server} with HEAD, via patch, including security fix.

Revision 1.5: download - view: text, markup, annotated - select for diffs
Tue Feb 21 20:23:49 2006 UTC (20 years, 8 months ago) by joerg
Branches: MAIN
CVS tags: pkgsrc-2006Q1-base
Branch point for: pkgsrc-2006Q1
Diff to: previous 1.4: preferred, colored
Changes since revision 1.4: +9 -1 lines
Update PostgreSQL 7.4.x to 7.4.12. Take maintainership.

The fix for locales and plperl in 7.4.11 might make an REINDEX necessary.

Changes from 7.4.8 to 7.4.9:
- Fix error that allowed VACUUM to remove ctid chains too soon, and add
more checking in code that follows ctid links
- Fix CHAR() to properly pad spaces to the specified length when using a
multiple-byte character set (Yoshiyuki Asaba)
- Fix the sense of the test for read-only transaction in COPY
- Fix planning problem with outer-join ON clauses that reference only
the inner-side relation
- Further fixes for x FULL JOIN y ON true corner cases
- Make array_in and array_recv more paranoid about validating their OID
parameter
- Fix missing rows in queries like UPDATE a=... WHERE a... with GiST
index on column a
- Improve robustness of datetime parsing
- Improve checking for partially-written WAL pages
- Improve robustness of signal handling when SSL is enabled
- Don't try to open more than max_files_per_process files during
postmaster startup
- Various memory leakage fixes
- Various portability improvements
- Fix PL/PgSQL to handle var := var correctly when the variable is of
pass-by-reference type
- Update contrib/tsearch2 to use current Snowball code

Changes from 7.4.9 to 7.4.10:
- Fix race condition in transaction log management
- Prevent failure if client sends Bind protocol message when current
transaction is already aborted
- /contrib/ltree fixes (Teodor)
- AIX and HPUX compile fixes (Tom)
- Fix longstanding planning error for outer joins
- Prevent core dump in pg_autovacuum when a table has been dropped

Changes from 7.4.10 to 7.4.11:
- Fix for protocol-level Describe messages issued outside a transaction
or in a failed transaction (Tom)
- Fix character string comparison for locales that consider different
character combinations as equal, such as Hungarian (Tom)
- Set locale environment variables during postmaster startup to ensure
that plperl won't change the locale later
- Fix longstanding bug in strpos() and regular expression handling in
certain rarely used Asian multi-byte character sets (Tatsuo)
- Fix bug in /contrib/pgcrypto gen_salt, which caused it not to use all
available salt space for MD5 and XDES algorithms (Marko Kreen, Solar
Designer)
- Fix /contrib/dblink to throw an error, rather than crashing, when the
number of columns specified is different from what's actually returned
by the query (Joe)

Changes from 7.4.11 to 7.4.12:
- Fix potential crash in SET SESSION AUTHORIZATION (CVE-2006-0553)
- Fix bug with row visibility logic in self-inserted rows (Tom)
- Fix race condition that could lead to "file already exists" errors
during pg_clog file creation (Tom)
- Properly check DOMAIN constraints for UNKNOWN parameters in prepared
statements (Neil)
- Fix to allow restoring dumps that have cross-schema references to
custom operators (Tom)
- Portability fix for testing presence of finite and isinf during
configure (Tom)

Revision 1.3.8.1: download - view: text, markup, annotated - select for diffs
Sat Jul 16 04:27:45 2005 UTC (21 years, 4 months ago) by snj
Branches: pkgsrc-2005Q2
Diff to: previous 1.3: preferred, colored; next MAIN 1.4: preferred, colored
Changes since revision 1.3: +14 -1 lines
Pullup ticket 609 - requested by Thomas Klausner
security update for postgresql74

Revisions pulled up:
- pkgsrc/databases/postgresql74/Makefile.common			1.24
- pkgsrc/databases/postgresql74/distinfo			1.18
- pkgsrc/databases/postgresql74-client/Makefile			1.12
- pkgsrc/databases/postgresql74-client/PLIST			1.4
- pkgsrc/databases/postgresql74-client/files/man.client		1.1
- pkgsrc/databases/postgresql74-client/files/man.exclude	removed
- pkgsrc/databases/postgresql74-docs/PLIST			1.4
- pkgsrc/databases/postgresql74-lib/PLIST			1.5
- pkgsrc/databases/postgresql74/patches/patch-ah		removed
- pkgsrc/databases/tcl-postgresql74/Makefile			1.3

    Module Name:    pkgsrc
    Committed By:   wiz
    Date:           Thu Jun 30 01:50:11 UTC 2005

    Modified Files:
            pkgsrc/databases/postgresql74: Makefile.common distinfo
            pkgsrc/databases/postgresql74-client: Makefile PLIST
            pkgsrc/databases/postgresql74-docs: PLIST
            pkgsrc/databases/postgresql74-lib: PLIST
            pkgsrc/databases/tcl-postgresql74: Makefile
    Added Files:
            pkgsrc/databases/postgresql74-client/files: man.client
    Removed Files:
            pkgsrc/databases/postgresql74-client/files: man.exclude
            pkgsrc/databases/postgresql74/patches: patch-ah

    Log Message:
    Update postgresql74* packages to 7.4.8.

                                    Release Notes

                                    Release 7.4.8

         Release date: 2005-05-09

       This release contains a variety of fixes from 7.4.7, including several
       security-related issues.
         __________________________________________________________________

    Migration to version 7.4.8

       A dump/restore is not required for those running 7.4.X. However, it is
       one possible way of handling two significant security problems that
       have been found in the initial contents of 7.4.X system catalogs. A
       dump/initdb/reload sequence using 7.4.8's initdb will automatically
       correct these problems.

       The larger security problem is that the built-in character set encoding
       conversion functions can be invoked from SQL commands by unprivileged
       users, but the functions were not designed for such use and are not
       secure against malicious choices of arguments. The fix involves
       changing the declared parameter list of these functions so that they
       can no longer be invoked from SQL commands. (This does not affect their
       normal use by the encoding conversion machinery.)

       The lesser problem is that the "contrib/tsearch2" module creates
       several functions that are misdeclared to return internal when they do
       not accept internal arguments. This breaks type safety for all
       functions using internal arguments.

       It is strongly recommended that all installations repair these errors,
       either by initdb or by following the manual repair procedures given
       below. The errors at least allow unprivileged database users to crash
       their server process, and may allow unprivileged users to gain the
       privileges of a database superuser.

    While here, fix postgresql74-client package installation on 2.0
    (broken -X), and avoid the need for gtar in tcl-postgresql74.

Revision 1.4: download - view: text, markup, annotated - select for diffs
Thu Jun 30 01:50:11 2005 UTC (21 years, 4 months ago) by wiz
Branches: MAIN
CVS tags: pkgsrc-2005Q4-base, pkgsrc-2005Q3-base, pkgsrc-2005Q3
Branch point for: pkgsrc-2005Q4
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +14 -1 lines
Update postgresql74* packages to 7.4.8.


                                Release Notes

                                Release 7.4.8

     Release date: 2005-05-09

   This release contains a variety of fixes from 7.4.7, including several
   security-related issues.
     __________________________________________________________________

Migration to version 7.4.8

   A dump/restore is not required for those running 7.4.X. However, it is
   one possible way of handling two significant security problems that
   have been found in the initial contents of 7.4.X system catalogs. A
   dump/initdb/reload sequence using 7.4.8's initdb will automatically
   correct these problems.

   The larger security problem is that the built-in character set encoding
   conversion functions can be invoked from SQL commands by unprivileged
   users, but the functions were not designed for such use and are not
   secure against malicious choices of arguments. The fix involves
   changing the declared parameter list of these functions so that they
   can no longer be invoked from SQL commands. (This does not affect their
   normal use by the encoding conversion machinery.)

   The lesser problem is that the "contrib/tsearch2" module creates
   several functions that are misdeclared to return internal when they do
   not accept internal arguments. This breaks type safety for all
   functions using internal arguments.

   It is strongly recommended that all installations repair these errors,
   either by initdb or by following the manual repair procedures given
   below. The errors at least allow unprivileged database users to crash
   their server process, and may allow unprivileged users to gain the
   privileges of a database superuser.

While here, fix postgresql74-client package installation on 2.0
(broken -X), and avoid the need for gtar in tcl-postgresql74.

Revision 1.3: download - view: text, markup, annotated - select for diffs
Sun Jun 27 16:38:32 2004 UTC (22 years, 4 months ago) by recht
Branches: MAIN
CVS tags: pkgsrc-2005Q2-base, pkgsrc-2005Q1-base, pkgsrc-2005Q1, pkgsrc-2004Q4-base, pkgsrc-2004Q4, pkgsrc-2004Q3-base, pkgsrc-2004Q3
Branch point for: pkgsrc-2005Q2
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +603 -602 lines
update to 7.4.3

changes:

* Fix temporary memory leak when using non-hashed aggregates (Tom)
* ECPG fixes, including some for Informix compatibility (Michael)
* Fixes for compiling with thread-safety, particularly Solaris (Bruce)
* Fix error in COPY IN termination when using the old network
  protocol (ljb)
* Several important fixes in pg_autovacuum (Matthew T. O'Connor)
* Fix problem with reading tar-format dumps on NetBSD and BSD/OS (Bruce)
* Several JDBC fixes
* Fix ALTER SEQUENCE RESTART where last_value equals the restart
  value (Tom)
* Repair failure to recalculate nested sub-selects (Tom)
* Fix problems with non-constant expressions in LIMIT/OFFSET
* Support FULL JOIN with no join clause, such as X FULL JOIN Y ON
  TRUE (Tom)
* Fix another zero-column table bug (Tom)
* Improve handling of non-qualified identifiers in GROUP BY clauses
  in sub-selects (Tom)
* Do not generate "NATURAL CROSS JOIN" when decompiling rules (Tom)
* Add checks for invalid field length in binary COPY (Tom)
* Avoid locking conflict between ANALYZE and LISTEN/NOTIFY
* Numerous translation updates (various contributors)

Revision 1.2: download - view: text, markup, annotated - select for diffs
Mon Apr 19 22:39:55 2004 UTC (22 years, 7 months ago) by recht
Branches: MAIN
CVS tags: pkgsrc-2004Q2-base, pkgsrc-2004Q2
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +601 -601 lines
PostgreSQL has no --with-htmldir, so install the html files by hand
to share/doc/html/postgresql.

Revision 1.1.1.1 (vendor branch): download - view: text, markup, annotated - select for diffs
Mon Apr 19 00:05:29 2004 UTC (22 years, 7 months ago) by recht
Branches: TNF
CVS tags: pkgsrc-base
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +0 -0 lines
Initial import of PostgreSQL 7.4.2
Documentation.

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 package contains the database documentation.

Revision 1.1: download - view: text, markup, annotated - select for diffs
Mon Apr 19 00:05:29 2004 UTC (22 years, 7 months ago) by recht
Branches: MAIN
Initial revision

Diff request

This form allows you to request diffs 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.

Log view options

CVSweb <webmaster@jp.NetBSD.org>