Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Delete old postgresql packages now that we have the postgresql73 ones.
Upgrade to 7.3.6. Mostly bug fixes. The full list of changes can be found at: 7.3.5: http://www.postgresql.org/news/164.html 7.3.6: http://www.postgresql.org/news/172.html As with all minor release upgrades a dump/restore is not required.
Relinquish maintainership of packages to tech-pkg@NetBSD.org.
replace deprecated USE_GMAKE with USE_GNU_TOOLS+=make.
Remove USE_BUILDLINK2 from Makefile.common and distribute the setting to all of the package Makefiles that include Makefile.common.
Upgrade to 7.3.4. The on-disk format is the same, so a dump/restore is not required. Changes include: Repair breakage in timestamp-to-date conversion for dates before 2000 Prevent rare possibility of server startup failure (Tom) Fix bugs in interval-to-time conversion (Tom) Add constraint names in a few places in pg_dump (Rod) Improve performance of functions with many parameters (Tom) Fix to_ascii() buffer overruns (Tom) Prevent restore of database comments from throwing an error (Tom) Work around buggy strxfrm() present in some Solaris releases (Tom) Properly escape jdbc setObject() strings to improve security (Barry) In particular, the server startup failure mentioned above occurs when the transaction log ends on a page boundary.
s/netbsd.org/NetBSD.org/
Add a comment to not forget jdbc-postgresql
Update to 7.3.3. About 70 bugfixes; see the HISTORY file for details.
Since postgresql explicitly checks for and fails if -ffast-math is set in CFLAGS, strip it out. No package bump as no change in generated package.
Update MASTER_SITES, from Ben Collver in PR 21640.
Update postgresql-* to 7.3.2. Contains numerous bug fixes, including remote
holes.
Restore creation of OID column in CREATE TABLE AS / SELECT INTO
Fix pg_dump core dump when dumping views having comments
Dump DEFERRABLE/INITIALLY DEFERRED constraints properly
Fix UPDATE when child table's column numbering differs from parent
Increase default value of max_fsm_relations
Fix problem when fetching backwards in a cursor for a single-row query
Make backward fetch work properly with cursor on SELECT DISTINCT query
Fix problems with loading pg_dump files containing contrib/lo usage
Fix problem with all-numeric user names
Fix possible memory leak and core dump during disconnect in libpgtcl
Make plpython's spi_execute command handle nulls properly (Andrew Bosma)
Adjust plpython error reporting so that its regression test passes again
Work with bison 1.875
Handle mixed-case names properly in plpgsql's %type (Neil)
Fix core dump in pltcl when executing a query rewritten by a rule
Repair array subscript overruns (per report from Yichen Xie)
Reduce MAX_TIME_PRECISION from 13 to 10 in floating-point case
Correctly case-fold variable names in per-database and per-user settings
Fix coredump in plpgsql's RETURN NEXT when SELECT into record returns
no rows
Fix outdated use of pg_type.typprtlen in python client interface
Correctly handle fractional seconds in timestamps in JDBC driver
Improve performance of getImportedKeys() in JDBC
Make shared-library symlinks work standardly on HPUX (Giles)
Repair inconsistent rounding behavior for timestamp, time, interval
SSL negotiation fixes (Nathan Mueller)
Make libpq's ~/.pgpass feature work when connecting with PQconnectDB
Update my2pg, ora2pg
Translation updates
Add casts between types lo and oid in contrib/lo
fastpath code now checks for privilege to call function
Updated databases/postgresql to 7.3.1.
==================================================================
| NOTE: A dump-and-restore is required to update your databases |
| if you wish to update postgresql-server. If your |
| application examines the system catalogs, additional |
| changes will be required due to the introduction of |
| schemas in 7.3; for more information, see: |
| |
| http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3 |
==================================================================
Major changes from version 7.2.3 include:
Schemas
Schemas allow users to create objects in separate namespaces,
so two people or applications can have tables with the same
name. There is also a public schema for shared tables.
Table/index creation can be restricted by removing permissions
on the public schema.
Drop Column
PostgreSQL now supports the ALTER TABLE ... DROP COLUMN
functionality.
Table Functions
Functions returning multiple rows and/or multiple columns are
now much easier to use than before. You can call such a "table
function" in the SELECT FROM clause, treating its output like a
table. Also, PL/pgSQL functions can now return sets.
Prepared Queries
PostgreSQL now supports prepared queries, for improved
performance.
Dependency Tracking
PostgreSQL now records object dependencies, which allows
improvements in many areas. "DROP" statements now take either
CASCADE or RESTRICT to control whether dependent objects are
also dropped.
Privileges
Functions and procedural languages now have privileges, and
functions can be defined to run with the privileges of their
creator.
Internationalization
Both multibyte and locale support are now always enabled.
Logging
A variety of logging options have been enhanced.
Interfaces
A large number of interfaces have been moved to
http://gborg.postgresql.org where they can be developed and
released independently.
Functions/Identifiers
By default, functions can now take up to 32 parameters, and
identifiers can be up to 63 bytes long. Also, OPAQUE is now
deprecated: there are specific "pseudo-datatypes" to represent
each of the former meanings of OPAQUE in function argument and
result types.
Update databases/postgresql to version 7.2.3. This has a variety of fixes from 7.2.2, including fixes to prevent possible data loss. A dump/restore is *not* required for those running 7.2.X. Changes from version 7.2.2 include: Prevent possible compressed transaction log loss (Tom) Prevent non-superuser from increasing most recent vacuum info (Tom) Handle pre-1970 date values in newer versions of glibc (Tom) Fix possible hang during server shutdown Prevent spinlock hangs on SMP PPC machines (Tomoyuki Niijima) Fix pg_dump to properly dump FULL JOIN USING (Tom)
add comment that this is not included by jdbc-postgresql
Update to 7.2.2 for security reasons. Only a security fix since 7.2.1 And create a way to get rid of that stupid message from audit-packages!
Fix problem with MASTER_SITES reported by Dan McMahill in private email. The make variable expansion differs between 1.5.x make and a -current make, so simplify it by flattening it out.
Update databases/postgresql and related sub-packages to 7.2.1. *** Please note that a dump/restore is NOT required for those *** *** running PostgreSQL 7.2. *** Important changes from version 7.2 include: Ensure that sequence counters do not go backwards after a crash (Tom) Allow psql \connect to handle mixed case database and user names (Tom) Return proper OID on command completion even with ON INSERT rules (Tom) Allow COPY FROM to use 8-bit DELIMITERS (Tatsuo) Improve handling of multiple UNIONs with different lengths (Tom) Fix for array subscripts handling (Tom) Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)
Update postgresql and related packages to 7.2. Thanks to Michael Graff
<explorer@flame.org> for most of the work on this update.
Pkgsrc changes from the previous version include removing Makefile.ssl and
some patches that have been integrated into this release of PostgreSQL. We
leave open the question of when to byte-compile the Python modules for the
PyGreSQL interface and just do it as before, although we should consider
doing the compilation as a post-install step to ensure that the timestamps
are correct. We also reorder some lines in the Makefile to include
Makefile.common below certain definitions (GNU_CONFIGURE, USE_BUILDLINK_ONLY)
as they may possibly trigger different portions of Makefile.common.
*** Please note that a dump/restore is required to migrate an existing ***
*** PostgreSQL installation to 7.2. ***
Major changes from version 7.1.3 are geared toward improving use in
high-volume applications and include:
VACUUM
Vacuuming no longer locks tables, thus allowing normal user access
during the vacuum. A new "VACUUM FULL" command does old-style
vacuum by locking the table and shrinking the on-disk copy of the
table.
Transactions
There is no longer a problem with installations that exceed four
billion transactions.
OID's
OID's are now optional. Users can now create tables without OID's
for cases where OID usage is excessive.
Optimizer
The system now computes histogram column statistics during
"ANALYZE", allowing much better optimizer choices.
Security
A new MD5 encryption option allows more secure storage and
transfer of passwords. A new Unix-domain socket authentication
option is available on Linux and BSD systems. PAM authentication
is also available.
Statistics
Administrators can use the new table access statistics module to
get fine-grained information about table and index usage.
Add directory level "source" to MASTER_SITES. Only the newest version (now 7.2, but I'm not in a position to upgrade the whole shebang yet) is accessible directly form the top distro level.
Use PKGREVISION to manage the package-specific version number when it differs from the distfile version number. G/C some the unused variables in postgresql/Makefile.common related to the old way of handling version numbers.
Fix the MASTER_SITES. Some ftp paths changed.
Update postgresql and packages built from postgresql sources to 7.1.3. Relevant changes from version 7.1.2 include: Remove unused WAL segements of large transactions Multiaction rule fix Pl/pgSQL memory allocation fix VACUUM buffer fix pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types Fix subselects with DISTINCT ON or LIMIT Disable COPY TO/FROM a view
LIBS is automatically added to CONFIGURE_ENV by bsd.pkg.mk if GNU_CONFIGURE is defined, so simply set LIBS to the appropriate value.
CPPFLAGS is now passed to MAKE_ENV and CONFIGURE_ENV by bsd.pkg.mk, so adapt by moving CPPFLAGS settings to top-level, and removing explicit inclusion of CPPFLAGS into MAKE_ENV and CONFIGURE_ENV.
The buildlink include and lib directories are added to CFLAGS, CPPFLAGS, CXXFLAGS, and LDFLAGS by the buildlink.mk files so remove the extra definitions to add them from the package Makefiles. As advised by the bsd.buildlink.mk file, also ensure that the buildlink.mk files are included prior to defining any package-specific CFLAGS/LDFLAGS to ensure that the buildlink directories are at the head of the compiler search paths.
Update postgresql to 7.1.2. Also update postgresql packages built from postgresql sources: postgresql-client, postgresql-docs, postgresql-lib, postgresql-server, postgresql-plperl, postgresql-pltcl, odbc-postgresql, py-postgresql, tcl-postgresql, tk-postgresql to 7.1.2 or to depend on postgresql-libs-7.1.2. Changes from version 7.1.1: Fix PL/PgSQL SELECTs when returning no rows Fix for psql backslash core dump Referential integrity permission fix Optimizer fixes pg_dump cleanups
Add definitions for BUILDLINK_INCDIR and BUILDLINK_LIBDIR used by the post-extract target.
Standardize name of file to include for build-links to be "buildlink.mk". Use BUILDLINK_INCDIR, BUILDLINK_LIBDIR for locations of linked headers and libraries. Create a variable BUILDLINK_TARGETS whose value is the list of build-link targets to execute.
Adapt postgresql-client to use devel/readline/Makefile.readline instead of the one in databases/postgresql. Remove the Makefile.readline in databases/postgresql as it's no longer used by any packages.
Fix dependencies and post-extract target. "Make build" in databases/postgresql should now correctly trigger the full build and installation of PostgreSQL.
Document the package naming scheme for PostgreSQL packages.
Update postgresql to 7.1.1 Pkgsrc changes include splitting into: postgresql-lib postgresql-client postgresql-server postgresql-doc with postgresql as a meta-package. Major changes from version 7.1.1 include: Write-ahead Log (WAL) - To maintain database consistency in case of an operating system crash, previous releases of PostgreSQL have forced all data modifications to disk before each transaction commit. With WAL, only one log file must be flushed to disk, greatly improving performance. If you have been using -F in previous releases to disable disk flushes, you may want to consider discontinuing its use. TOAST - Previous releases had a compiled-in row length limit, typically 8 - 32 kB. This limit made storage of long text fields difficult. With TOAST, long rows of any length can be stored with good performance. Outer Joins - We now support outer joins. The UNION/NOT IN workaround for outer joins is no longer required. We use the SQL92 outer join syntax. Function Manager - The previous C function manager did not handle NULLs properly, nor did it support 64-bit CPU's (Alpha). The new function manager does. You can continue using your old custom functions, but you may want to rewrite them in the future to use the new function manager call interface. Complex Queries - A large number of complex queries that were unsupported in previous releases now work. Many combinations of views, aggregates, UNION, LIMIT, cursors, subqueries, and inherited tables now work properly. Inherited tables are now accessed by default. Subqueries in FROM are now supported. Migration to 7.1.1 A dump/restore using pg_dump is required for those wishing to migrate data from any previous release.
Share a common distinfo file with the postgresql package.
Note inclusion by odbc-postgresql
Change BUILD_DEPENDS semantics: first component is now a package name+version/pattern, no more executable/patchname/whatnot. While there, introduce BUILD_USES_MSGFMT as shorthand to pull in devel/gettext unless /usr/bin/msgfmt exists (i.e. on post-1.5 -current). Patch by Alistair Crooks <agc@netbsd.org>
s/autoreconf/${LOCALBASE}/bin/autoreconf. This was apparently missed in
the previous sweep for such changes (perhaps other Makefile.common files
also?).
Cosmetic adjustments.
Note the packages that include this file so we note when other packages are update when this one is updated.
Update to 7.0.3. Jdbc fixes (Peter) Large object fix (Tom) Fix lean in COPY WITH OIDS leak (Tom) Fix backwards-index-scan (Tom) Fix SELECT ... FOR UPDATE so it checks for duplicate keys (Hiroshi) Add --enable-syslog to configure (Marc) Fix abort transaction at backend exit in rare cases (Tom) Fix for psql \l+ when multi-byte enabled (Tatsuo) Allow PL/pgSQL to accept non ascii identifiers (Tatsuo) Make vacuum always flush buffers (Tom) Fix to allow cancel while waiting for a lock (Hiroshi) Fix for memory aloocation problem in user authentication code (Tom) Remove bogus use of int4out() (Tom) Fixes for multiple subqueries in COALESCE or BETWEEN (Tom) Fix for failure of triggers on heap open in certain cases (Jeroen van Vianen) Fix for erroneous selectivity of not-equals (Tom) Fix for erroneous use of strcmp() (Tom) Fix for bug where storage manager accesses items beyond end of file (Tom) Fix to include kernel errno message in all smgr elog messages (Tom) Fix for '.' not in PATH at build time (SL Baur) Fix for out-of-file-descriptors error (Tom) Fix to make pg_dump dump 'iscachable' flag for functions (Tom) Fix for subselect in targetlist of Append node (Tom) Fix for mergejoin plans (Tom) Fix TRUNCATE failure on relations with indexes (Tom) Avoid database-wide restart on write error (Hiroshi) Fix nodeMaterial to honor chgParam by recomputing its output (Tom) Fix VACUUM problem with moving chain of update tuples when source and destination of a tuple lie on the same page (Tom) Fix user.c CommandCounterIncrement (Tom) Fix for AM/PM boundary problem in to_char() (Karel Zak) Fix TIME aggregate handling (Tom) Fix to_char() to avoid coredump on NULL input (Tom) Buffer fix (Tom) Fix for inserting/copying longer multibyte strings into char() data types (Tatsuo) Fix for crash of backend, on abort (Tom)
Update postgresql to 7.0.2. Relevant changes from 7.0: * Enhance rc.d/pgsql.sh script to accept start/stop/restart. * Add fixes for alpha from Kevin P. Neal <kpn@neutralgood.org> in PR#10543. XXX Includes a patch which removes inlining of the alpha's TAS function. XXX This is apparently some code-gen bug in GCC for alpha. * Fix many CLUSTER failures (Tom) * Allow ALTER TABLE RENAME works on indexes (Tom) * Fix plpgsql to handle datetime->timestamp and timespan->interval (Bruce) * New configure --with-setproctitle switch to use setproctitle() (Marc, Bruce) * Fix the off by one errors in ResultSet from 6.5.3, and more. * jdbc ResultSet fixes (Joseph Shraibman) * optimizer tunings (Tom) * Fix create user for pgaccess * Fix for UNLISTEN failure * Reduce COPY IN lock level (Tom) * Change libpqeasy to use PQconnectdb() style parameters (Bruce) * Fix pg_dump to handle OID indexes (Tom) * Fix small memory leak (Tom) * Solaris fix for createdb/dropdb (Tatsuo) * Fix for non-blocking connections (Alfred Perlstein) * Fix improper recovery after RENAME TABLE failures (Tom) * Copy pg_ident.conf.sample into /lib directory in install (Bruce) * Add SJIS UDC (NEC selection IBM kanji) support (Eiji Tokuya) * Fix too long syslog message (Tatsuo) * Fix problem with quoted indexes that are too long (Tom) * JDBC ResultSet.getTimestamp() fix (Gregory Krasnow & Floyd Marinescu) * ecpg changes (Michael)
Fix MASTER_SITES Add some additional mirrors
Update postgresql to 7.0. Also closes PR#8616. Changes from 6.5.3:
A HUGE number of bug/performance fixes and minor enhancements.
Foreign Keys
Foreign keys are now implemented, with the exception of PARTIAL
MATCH foreign keys. Many users have been asking for this
feature, and we are pleased to offer it.
Optimizer Overhaul
Continuing on work started a year ago, the optimizer has been
overhauled, allowing improved query execution and better
performance with less memory usage.
Updated psql
psql, our interactive terminal monitor, has been updated with a
variety of new features. See the psql manual page for details.
Upcoming Features
In 7.1 or 7.2, we plan to have outer joins, storage for very
long rows, and a write-ahead logging system.
A dump/restore using pg_dump is required for those wishing to migrate
data from any previous release. For those upgrading from 6.5.*, you
can use pg_upgrade to upgrade to this release.
Change structure of postgresql package. Shared library build is now
unlibtoolized. Things now install into ${PREFIX} instead of
${PREFIX}/${PGSQL_USER} to match hier(7) expectations. The Tcl and Tk
interfaces are now split out into separate packages.
This closes the following PRs: 7384, 8747, 8789, 9272, 9461.