head 1.28; access; symbols pkgsrc-2013Q2:1.28.0.30 pkgsrc-2013Q2-base:1.28 pkgsrc-2012Q4:1.28.0.28 pkgsrc-2012Q4-base:1.28 pkgsrc-2011Q4:1.28.0.26 pkgsrc-2011Q4-base:1.28 pkgsrc-2011Q2:1.28.0.24 pkgsrc-2011Q2-base:1.28 pkgsrc-2009Q4:1.28.0.22 pkgsrc-2009Q4-base:1.28 pkgsrc-2008Q4:1.28.0.20 pkgsrc-2008Q4-base:1.28 pkgsrc-2008Q3:1.28.0.18 pkgsrc-2008Q3-base:1.28 cube-native-xorg:1.28.0.16 cube-native-xorg-base:1.28 pkgsrc-2008Q2:1.28.0.14 pkgsrc-2008Q2-base:1.28 pkgsrc-2008Q1:1.28.0.12 pkgsrc-2008Q1-base:1.28 pkgsrc-2007Q4:1.28.0.10 pkgsrc-2007Q4-base:1.28 pkgsrc-2007Q3:1.28.0.8 pkgsrc-2007Q3-base:1.28 pkgsrc-2007Q2:1.28.0.6 pkgsrc-2007Q2-base:1.28 pkgsrc-2007Q1:1.28.0.4 pkgsrc-2007Q1-base:1.28 pkgsrc-2006Q4:1.28.0.2 pkgsrc-2006Q4-base:1.28 pkgsrc-2006Q3:1.26.0.4 pkgsrc-2006Q3-base:1.26 pkgsrc-2006Q2:1.26.0.2 pkgsrc-2006Q2-base:1.26 pkgsrc-2006Q1:1.25.0.2 pkgsrc-2006Q1-base:1.25 pkgsrc-2005Q4:1.21.0.2 pkgsrc-2005Q4-base:1.21 pkgsrc-2005Q3:1.17.0.2 pkgsrc-2005Q3-base:1.17 pkgsrc-2005Q2:1.15.0.2 pkgsrc-2005Q2-base:1.15 pkgsrc-2005Q1:1.13.0.2 pkgsrc-2005Q1-base:1.13 pkgsrc-2004Q4:1.7.0.2 pkgsrc-2004Q4-base:1.7 pkgsrc-2004Q3:1.3.0.2 pkgsrc-2004Q3-base:1.3 pkgsrc-2004Q2:1.2.0.2 pkgsrc-2004Q2-base:1.2 pkgsrc-base:1.1.1.1 TNF:1.1.1; locks; strict; comment @# @; 1.28 date 2006.12.27.15.57.38; author joerg; state dead; branches; next 1.27; 1.27 date 2006.10.18.19.24.07; author adam; state Exp; branches; next 1.26; 1.26 date 2006.04.23.00.12.37; author jlam; state Exp; branches 1.26.4.1; next 1.25; 1.25 date 2006.03.14.01.14.27; author jlam; state Exp; branches; next 1.24; 1.24 date 2006.02.21.20.23.49; author joerg; state Exp; branches; next 1.23; 1.23 date 2006.02.05.23.08.35; author joerg; state Exp; branches; next 1.22; 1.22 date 2005.12.29.06.21.36; author jlam; state Exp; branches; next 1.21; 1.21 date 2005.12.05.23.55.05; author rillig; state Exp; branches; next 1.20; 1.20 date 2005.12.05.20.50.00; author rillig; state Exp; branches; next 1.19; 1.19 date 2005.12.02.21.01.34; author joerg; state Exp; branches; next 1.18; 1.18 date 2005.11.08.16.40.39; author joerg; state Exp; branches; next 1.17; 1.17 date 2005.08.23.11.48.47; author rillig; state Exp; branches; next 1.16; 1.16 date 2005.07.15.18.27.48; author jlam; state Exp; branches; next 1.15; 1.15 date 2005.05.31.11.24.32; author dillo; state Exp; branches; next 1.14; 1.14 date 2005.05.16.01.32.22; author jlam; state Exp; branches; next 1.13; 1.13 date 2005.02.07.11.35.41; author jlam; state Exp; branches; next 1.12; 1.12 date 2005.02.05.14.31.20; author jdolecek; state Exp; branches; next 1.11; 1.11 date 2005.02.02.08.23.14; author jdolecek; state Exp; branches; next 1.10; 1.10 date 2005.02.02.08.15.09; author jdolecek; state Exp; branches; next 1.9; 1.9 date 2005.01.14.05.15.39; author jlam; state Exp; branches; next 1.8; 1.8 date 2004.12.28.02.47.43; author reed; state Exp; branches; next 1.7; 1.7 date 2004.12.18.15.59.55; author jlam; state Exp; branches; next 1.6; 1.6 date 2004.11.28.19.19.51; author jlam; state Exp; branches; next 1.5; 1.5 date 2004.10.10.07.30.23; author jdolecek; state Exp; branches; next 1.4; 1.4 date 2004.10.03.00.13.23; author tv; state Exp; branches; next 1.3; 1.3 date 2004.07.24.22.44.12; author recht; state Exp; branches; next 1.2; 1.2 date 2004.05.13.22.09.28; author kristerw; state Exp; branches; next 1.1; 1.1 date 2004.04.19.00.04.23; author recht; state Exp; branches 1.1.1.1; next ; 1.26.4.1 date 2006.10.31.10.18.19; author ghen; state Exp; branches; next ; 1.1.1.1 date 2004.04.19.00.04.23; author recht; state Exp; branches; next ; desc @@ 1.28 log @As discussed on tech-pkg, remove PostgreSQL 7.4. @ text @# $NetBSD: Makefile,v 1.27 2006/10/18 19:24:07 adam Exp $ PKGNAME= postgresql74-server-${BASE_VERS} SVR4_PKGNAME= pstgs COMMENT= PostgreSQL database server programs DEPENDS+= postgresql74-client>=${BASE_VERS}:../../databases/postgresql74-client # mips has no TAS implementation NOT_FOR_PLATFORM= *-*-mips .include "../../databases/postgresql74/Makefile.common" MESSAGE_SRC= ${.CURDIR}/MESSAGE USE_TOOLS+= tar CONFIGURE_ARGS+= --with-openssl=${SSLBASE:Q} BUILD_DIRS= ${WRKSRC}/src/backend BUILD_DIRS+= ${WRKSRC}/src/backend/utils/mb/conversion_procs # PostgreSQL has loadable server-side language modules. # XXX this breaks PostgreSQL server - see PR pkg/28729 #.include "../../mk/dlopen.buildlink3.mk" PKG_OPTIONS_VAR= PKG_OPTIONS.postgresql74-server PKG_SUPPORTED_OPTIONS= pam .include "../../mk/bsd.options.mk" .if !empty(PKG_OPTIONS:Mpam) . include "../../mk/pam.buildlink3.mk" CONFIGURE_ARGS+= --with-pam .endif # PGUSER username of the database administrator # PGGROUP group of the database administrator # PGHOME home directory of the database administrator and location of # the databases # PGUSER?= pgsql PGGROUP?= pgsql PGHOME?= ${PREFIX}/${PGUSER} FILES_SUBST+= PGUSER=${PGUSER:Q} FILES_SUBST+= PGGROUP=${PGGROUP:Q} FILES_SUBST+= PGHOME=${PGHOME:Q} BUILD_DEFS+= PGUSER PGGROUP PGHOME PKG_GROUPS= ${PGGROUP} PKG_USERS= ${PGUSER}:${PGGROUP} PKG_GECOS.${PGUSER}= PostgreSQL database administrator PKG_HOME.${PGUSER}= ${PGHOME} PKG_SHELL.${PGUSER}= ${SH} RCD_SCRIPTS= pgsql post-wrapper: # # Avoid conflict between "${LOCALBASE}/include/openssl/des.h" and # "/usr/include/crypt.h" -- we want the definitions in the former. # .if (${OPSYS} == "SunOS") touch ${BUILDLINK_DIR}/include/crypt.h .endif pre-build: ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/backend && \ env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \ ../../src/include/parser/parse.h ../../src/include/utils/fmgroids.h ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/port && \ env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} pre-install: @@case "X${PGUSER}" in \ Xbin|Xetc|Xinclude|Xinfo|Xlib|Xlibdata|Xlibexec|Xman|Xsbin|Xshare) \ ${ECHO} "You have chosen PGUSER=${PGUSER} which will"; \ ${ECHO} "cause trouble, because the postgres home directory"; \ ${ECHO} "would be ${PGHOME}. Please"; \ ${ECHO} "set PGUSER to something more reasonable"; \ ${ECHO} "like pgsql."; \ ${ECHO} ""; \ ${FALSE}; \ ;; \ esac post-install: egrep -v "^#" ${FILESDIR}/man.server > ${WRKDIR}/man_tar cd ${PREFIX}/man && tar -zxm -T ${WRKDIR}/man_tar \ -f ${WRKSRC}/doc/man.tar.gz .include "../../databases/postgresql74-lib/buildlink3.mk" .include "../../mk/bsd.pkg.mk" @ 1.27 log @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 @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.26 2006/04/23 00:12:37 jlam Exp $ @ 1.26 log @Modify packages that set PKG_USERS and PKG_GROUPS to follow the new syntax as specified in pkgsrc/mk/install/bsd.pkginstall.mk:1.47. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.25 2006/03/14 01:14:27 jlam Exp $ d61 1 a61 1 ${TOUCH} ${BUILDLINK_DIR}/include/crypt.h d66 1 a66 1 ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \ d69 1 a69 1 ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} d85 2 a86 2 ${EGREP} -v "^#" ${FILESDIR}/man.server > ${WRKDIR}/man_tar cd ${PREFIX}/man && ${TAR} -zxm -T ${WRKDIR}/man_tar \ @ 1.26.4.1 log @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. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.27 2006/10/18 19:24:07 adam Exp $ d61 1 a61 1 touch ${BUILDLINK_DIR}/include/crypt.h d66 1 a66 1 env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \ d69 1 a69 1 env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} d85 2 a86 2 egrep -v "^#" ${FILESDIR}/man.server > ${WRKDIR}/man_tar cd ${PREFIX}/man && tar -zxm -T ${WRKDIR}/man_tar \ @ 1.25 log @Modify the pkginstall framework so that it manages all aspects of INSTALL/DEINSTALL script creation within pkgsrc. If an INSTALL or DEINSTALL script is found in the package directory, it is automatically used as a template for the pkginstall-generated scripts. If instead, they should be used simply as the full scripts, then the package Makefile should set INSTALL_SRC or DEINSTALL_SRC explicitly, e.g.: INSTALL_SRC= ${PKGDIR}/INSTALL DEINSTALL_SRC= # emtpy As part of the restructuring of the pkginstall framework internals, we now *always* generate temporary INSTALL or DEINSTALL scripts. By comparing these temporary scripts with minimal INSTALL/DEINSTALL scripts formed from only the base templates, we determine whether or not the INSTALL/DEINSTALL scripts are actually needed by the package (see the generate-install-scripts target in bsd.pkginstall.mk). In addition, more variables in the framework have been made private. The *_EXTRA_TMPL variables have been renamed to *_TEMPLATE, which are more sensible names given the very few exported variables in this framework. The only public variables relating to the templates are: INSTALL_SRC INSTALL_TEMPLATE DEINSTALL_SRC DEINSTALL_TEMPLATE HEADER_TEMPLATE The packages in pkgsrc have been modified to reflect the changes in the pkginstall framework. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.24 2006/02/21 20:23:49 joerg Exp $ a46 1 PKG_USERS= ${PGUSER}:${PGGROUP}::PostgreSQL\ database\ administrator:${PGHOME}:${SH} d48 4 @ 1.24 log @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) @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.23 2006/02/05 23:08:35 joerg Exp $ a13 1 DEINSTALL_EXTRA_TMPL+= ${.CURDIR}/DEINSTALL @ 1.23 log @Recursive revision bump / recommended bump for gettext ABI change. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.22 2005/12/29 06:21:36 jlam Exp $ a3 1 PKGREVISION= 1 @ 1.22 log @Remove USE_PKGINSTALL from pkgsrc now that mk/install/pkginstall.mk automatically detects whether we want the pkginstall machinery to be used by the package Makefile. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.21 2005/12/05 23:55:05 rillig Exp $ d4 1 @ 1.21 log @Ran "pkglint --autofix", which corrected some of the quoting issues in CONFIGURE_ARGS. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.20 2005/12/05 20:50:00 rillig Exp $ a13 1 USE_PKGINSTALL= yes @ 1.20 log @Fixed pkglint warnings. The warnings are mostly quoting issues, for example MAKE_ENV+=FOO=${BAR} is changed to MAKE_ENV+=FOO=${BAR:Q}. Some other changes are outlined in http://mail-index.netbsd.org/tech-pkg/2005/12/02/0034.html @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.19 2005/12/02 21:01:34 joerg Exp $ d19 1 a19 1 CONFIGURE_ARGS+= --with-openssl=${SSLBASE} @ 1.19 log @Merge DragonFly pre-configure merging back into Makefile.common's post-extract. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.18 2005/11/08 16:40:39 joerg Exp $ a3 1 PKGREVISION= # empty d44 4 a47 4 FILES_SUBST+= PGUSER=${PGUSER} FILES_SUBST+= PGGROUP=${PGGROUP} FILES_SUBST+= PGHOME=${PGHOME} BUILD_DEFS= PGUSER PGGROUP PGHOME @ 1.18 log @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. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.17 2005/08/23 11:48:47 rillig Exp $ a63 13 pre-configure: ${TOUCH} ${WRKSRC}/src/template/dragonfly ${CP} ${WRKSRC}/src/backend/port/dynloader/freebsd.c \ ${WRKSRC}/src/backend/port/dynloader/dragonfly.c ${CP} ${WRKSRC}/src/backend/port/dynloader/freebsd.h \ ${WRKSRC}/src/backend/port/dynloader/dragonfly.h ${CP} ${WRKSRC}/src/backend/port/dynloader/freebsd.h \ ${WRKSRC}/src/backend/port/dynloader/dragonfly.h ${CP} ${WRKSRC}/src/include/port/freebsd.h \ ${WRKSRC}/src/include/port/dragonfly.h ${CP} ${WRKSRC}/src/makefiles/Makefile.freebsd \ ${WRKSRC}/src/makefiles/Makefile.dragonfly @ 1.17 log @The real user name in PKG_USERS does not need to be escaped with double backslashes anymore. A single backslash is enough. Changed the definition in all affected packages. For those that are not caught, an additional check is placed into bsd.pkginstall.mk. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.16 2005/07/15 18:27:48 jlam Exp $ d64 13 @ 1.16 log @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. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.15 2005/05/31 11:24:32 dillo Exp $ d50 1 a50 1 PKG_USERS= ${PGUSER}:${PGGROUP}::PostgreSQL\\ database\\ administrator:${PGHOME}:${SH} @ 1.15 log @Rename option PAM to pam (so all options are lower case). Backwards compatibility provided via PKG_OPTIONS_LEGACY_OPTS. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.14 2005/05/16 01:32:22 jlam Exp $ d18 1 a18 1 PKGSRC_USE_TOOLS+= tar @ 1.14 log @Note that tar is required by this package. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.13 2005/02/07 11:35:41 jlam Exp $ d29 1 a29 1 PKG_SUPPORTED_OPTIONS= PAM d32 1 a32 1 .if !empty(PKG_OPTIONS:MPAM) @ 1.13 log @Instantly deprecate USE_PAM from pkgsrc as its value is being set from within NetBSD-current's bsd.own.mk, which conflicts with its usage in pkgsrc. The package that use USE_PAM have been converted to use the bsd.options.mk framework. This should fix PR pkg/29257. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.12 2005/02/05 14:31:20 jdolecek Exp $ d18 1 @ 1.12 log @Update postgresql74 to 7.4.7. This is security release only, fixes recently discovered LOAD vulnerability. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.11 2005/02/02 08:23:14 jdolecek Exp $ d27 5 a31 1 .if defined(USE_PAM) @ 1.11 log @bump PKGREVISION for last change (removal of dlopen.bl3.mk) @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.10 2005/02/02 08:15:09 jdolecek Exp $ d4 1 a4 1 PKGREVISION= 4 @ 1.10 log @disable dlopen.buildlink - it causes postgresql looping fixes PR pkg/28729 by Bob Kemp @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.9 2005/01/14 05:15:39 jlam Exp $ d4 1 a4 1 PKGREVISION= 3 @ 1.9 log @Create a pam.buildlink3.mk file that is used by PAM-using packages. It includes the correct buildlink3.mk file from either Linux-PAM (security/PAM) or OpenPAM (security/openpam) and eventually will support solaris-pam. pam.buildlink3.mk will: * set PAMBASE to the base directory of the PAM files; * set PAM_TYPE to the PAM implementation used. There are two variables that can be used to tweak the selection of the PAM implementation: PAM_DEFAULT is a user-settable variable whose value is the default PAM implementation to use. PAM_ACCEPTED is a package-settable list of PAM implementations that may be used by the package. Modify most packages that include PAM/buildlink3.mk to include pam.buildlink3.mk instead. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.8 2004/12/28 02:47:43 reed Exp $ d24 2 a25 1 .include "../../mk/dlopen.buildlink3.mk" @ 1.8 log @The default location of the pkgsrc-installed rc.d scripts is now under share/examples/rc.d. The variable name already was named RCD_SCRIPTS_EXAMPLEDIR. This is from ideas from Greg Woods and others. Also bumped PKGREVISION for all packages using RCD_SCRIPTS mechanism (as requested by wiz). @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.7 2004/12/18 15:59:55 jlam Exp $ d27 1 a27 1 . include "../../security/PAM/buildlink3.mk" @ 1.7 log @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. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.6 2004/11/28 19:19:51 jlam Exp $ d4 1 a4 1 PKGREVISION= 2 @ 1.6 log @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". @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.5 2004/10/10 07:30:23 jdolecek Exp $ d4 1 a4 1 PKGREVISION= 1 @ 1.5 log @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) @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.4 2004/10/03 00:13:23 tv Exp $ d4 1 a4 1 PKGREVISION= # empty d23 3 d49 1 a49 1 post-buildlink: @ 1.4 log @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. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.3 2004/07/24 22:44:12 recht Exp $ d4 1 a4 1 PKGREVISION= 1 @ 1.3 log @change pkgname to postgresql74* (from postgresql*) @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.2 2004/05/13 22:09:28 kristerw Exp $ d4 1 @ 1.2 log @The NetBSD 1.6 tar does not DTRT with the -C flag. cd into the destination instead, to work around this. @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.1.1.1 2004/04/19 00:04:23 recht Exp $ d3 1 a3 1 PKGNAME= postgresql-server-${BASE_VERS} d7 1 a7 1 DEPENDS+= postgresql-client>=${BASE_VERS}:../../databases/postgresql74-client @ 1.1 log @Initial revision @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.36 2003/11/14 01:46:39 explorer Exp $ d76 1 a76 1 ${TAR} -zxm -C ${PREFIX}/man -T ${WRKDIR}/man_tar \ @ 1.1.1.1 log @Initial import of PostgreSQL 7.4.2 Database server. 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 server programs. @ text @@