Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql74-lib
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
As discussed on tech-pkg, remove PostgreSQL 7.4.
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.
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
Fix issue with PKGMANDIR.
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.
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)
Recursive revision bump / recommended bump for gettext ABI change.
Ran "pkglint --autofix", which corrected some of the quoting issues in CONFIGURE_ARGS.
Merge DragonFly pre-configure merging back into Makefile.common's post-extract.
Allow PostgreSQL 7.4 to build on DragonFly. Bump revision of -lib, since the PLIST changed. Don't define errno manually in contrib/, depend on errno.h to do so. Explicitly include errno.h in some places.
Drop distinction between PKGSRC_USE_TOOLS and USE_TOOLS by making PKGSRC_USE_TOOLS go away. There is now only a single USE_TOOLS variable that specifies all of the tools we need to build/run the package.
Note that tar is required by this package.
bump PKGREVISION for previous patch against CAN-2005-0247
Update postgresql74 to 7.4.7. This is security release only, fixes recently discovered LOAD vulnerability.
Patch Makefile.shlib so that when creating shared libraries, we don't
only pass only the -L* LDFLAGS to the linker. This is correct for
pkgsrc since the wrapper scripts take care of correctly passing the
rpath info to the linker, so we don't need to filter those out. This
allows plpgsql.so to find libintl.so if we are using the pkgsrc version
of it. Bump the PKGREVISION of postgresql*-lib to 7.3.8nb1 and
7.4.6nb2.
Link the postgres binary with the necessary flags to allow it to
dlopen() modules that use pthreads[*]. This should allow postgres to
open a plperl.so module built on a system with perl+threads. Bump
the PKGREVISION of postgresql*-server to 7.3.8nb2 and 7.4.6nb2.
[*] Note that this behavior can be tweaked globally by setting
DLOPEN_REQUIRE_PTHREADS to "yes" or "no" in /etc/mk.conf.
Move the pg_config binary from -client to -lib. This fixes PR pkg/28685 as well as the bulk build for py-postgresql. Note that the man page is still built and installed by -client. That's a trickier problem.
Remove pre-buildlink and post-buildlink as part of getting pkgsrc ready for pkgsrc-2004Q4. The "buildlink" phase was removed for the last branch, and this is the final cleanup. "post-buildlink" is now "post-wrapper".
Fix PLIST issue: unconditionally add ${WRKSRC}/src/backend to BUILD_DIRS.
It's only really needed on Darwin but building there on all platforms
allows us to keep the same PLIST for all of them: buildling the backend
results in two more include files to be installed.
Per discussion with recht@ our dedicated postgresql74-* MAINTAINER ;)
Fix the build on Darwin.
Update PostgreSQL 7.4 packages to 7.4.5. Changes are mostly reliability fixes.
Dump/restore is not necessary for 7.4.x users.
Changes in 7.4.5:
* Repair possible crash during concurrent btree index insertions
This patch fixes a rare case in which concurrent insertions into a
btree index could result in a server panic. No permanent damage
would result, but it's still worth a re-release. The bug does not
exist in pre-7.4 releases.
Changes in 7.4.4:
* Prevent possible loss of committed transactions during crash
Due to insufficient interlocking between transaction commit and
checkpointing, it was possible for transactions committed just
before the most recent checkpoint to be lost, in whole or in part,
following a database crash and restart. This is a serious bug that
has existed since PostgreSQL 7.1.
* Check HAVING restriction before evaluating result list of an
aggregate plan
* Avoid crash when session's current userID is deleted
* Fix hashed crosstab for zero-rows case (Joe)
* Force cache update after renaming a column in a foreign key
* Pretty-print UNION queries correctly
* Make psql handle \r\n newlines properly in COPY IN
* pg_dump handled ACLs with grant options incorrectly
* Fix thread support for OS X and Solaris
* Updated JDBC driver (build 215) with various fixes
* ECPG fixes
* Translation updates (various contributors)
Libtool fix for PR pkg/26633, and other issues. Update libtool to 1.5.10 in the process. (More information on tech-pkg.) Bump PKGREVISION and BUILDLINK_DEPENDS of all packages using libtool and installing .la files. Bump PKGREVISION (only) of all packages depending directly on the above via a buildlink3 include.
Bump PKGREVISION to 1 for the previous thread-safety change. noted by wiz
Do not build with --enable-thread-safety on NetBSD. Currently, it causes more harm than good.
change pkgname to postgresql74* (from postgresql*)
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)
Only enable-thread safety on systems which have native threads to avoid pulling in pth. Pointed out by seb@.
GNU tar 1.11.2 as seen in NetBSD 1.6.2 does not grok -T with -C like NetBSD pax-as-tar. So avoid using both...
Follow a suggestion by Josh Berkus (pgsql core team) and build with --enable-thread-safety. Bump PKGREVISIONs accordingly (meta-pkg, -client, -lib).
Initial import of PostgreSQL 7.4.2 Libraries and headers. 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 headers and libraries.
Initial revision