head 1.14; access; symbols pkgsrc-2013Q2:1.14.0.48 pkgsrc-2013Q2-base:1.14 pkgsrc-2012Q4:1.14.0.46 pkgsrc-2012Q4-base:1.14 pkgsrc-2011Q4:1.14.0.44 pkgsrc-2011Q4-base:1.14 pkgsrc-2011Q2:1.14.0.42 pkgsrc-2011Q2-base:1.14 pkgsrc-2009Q4:1.14.0.40 pkgsrc-2009Q4-base:1.14 pkgsrc-2008Q4:1.14.0.38 pkgsrc-2008Q4-base:1.14 pkgsrc-2008Q3:1.14.0.36 pkgsrc-2008Q3-base:1.14 cube-native-xorg:1.14.0.34 cube-native-xorg-base:1.14 pkgsrc-2008Q2:1.14.0.32 pkgsrc-2008Q2-base:1.14 pkgsrc-2008Q1:1.14.0.30 pkgsrc-2008Q1-base:1.14 pkgsrc-2007Q4:1.14.0.28 pkgsrc-2007Q4-base:1.14 pkgsrc-2007Q3:1.14.0.26 pkgsrc-2007Q3-base:1.14 pkgsrc-2007Q2:1.14.0.24 pkgsrc-2007Q2-base:1.14 pkgsrc-2007Q1:1.14.0.22 pkgsrc-2007Q1-base:1.14 pkgsrc-2006Q4:1.14.0.20 pkgsrc-2006Q4-base:1.14 pkgsrc-2006Q3:1.14.0.18 pkgsrc-2006Q3-base:1.14 pkgsrc-2006Q2:1.14.0.16 pkgsrc-2006Q2-base:1.14 pkgsrc-2006Q1:1.14.0.14 pkgsrc-2006Q1-base:1.14 pkgsrc-2005Q4:1.14.0.12 pkgsrc-2005Q4-base:1.14 pkgsrc-2005Q3:1.14.0.10 pkgsrc-2005Q3-base:1.14 pkgsrc-2005Q2:1.14.0.8 pkgsrc-2005Q2-base:1.14 pkgsrc-2005Q1:1.14.0.6 pkgsrc-2005Q1-base:1.14 pkgsrc-2004Q4:1.14.0.4 pkgsrc-2004Q4-base:1.14 pkgsrc-2004Q3:1.14.0.2 pkgsrc-2004Q3-base:1.14 pkgsrc-2004Q2:1.13.0.6 pkgsrc-2004Q2-base:1.13 pkgsrc-2004Q1:1.13.0.4 pkgsrc-2004Q1-base:1.13 pkgsrc-2003Q4:1.13.0.2 pkgsrc-2003Q4-base:1.13 netbsd-1-6-1:1.12.0.2 netbsd-1-6-1-base:1.12 netbsd-1-6:1.11.0.8 netbsd-1-6-RELEASE-base:1.11 pkgviews:1.11.0.4 pkgviews-base:1.11 buildlink2:1.11.0.2 buildlink2-base:1.11 netbsd-1-5-PATCH003:1.11 netbsd-1-5-PATCH001:1.9 netbsd-1-5-RELEASE:1.9 netbsd-1-4-PATCH003:1.9 netbsd-1-4-PATCH002:1.5 comdex-fall-1999:1.5 netbsd-1-4-PATCH001:1.4 netbsd-1-4-RELEASE:1.4 netbsd-1-3-PATCH002:1.2 FreeBSD-current-1998-02-16:1.1.1.1 FREEBSD:1.1.1; locks; strict; comment @# @; 1.14 date 2004.07.24.22.48.14; author recht; state dead; branches; next 1.13; 1.13 date 2003.04.03.18.06.13; author toshii; state Exp; branches; next 1.12; 1.12 date 2003.01.05.20.12.13; author jlam; state Exp; branches; next 1.11; 1.11 date 2002.04.04.07.48.25; author jlam; state Exp; branches; next 1.10; 1.10 date 2001.05.14.14.52.38; author jlam; state Exp; branches; next 1.9; 1.9 date 2000.07.14.04.44.13; author jlam; state Exp; branches; next 1.8; 1.8 date 2000.05.20.19.34.19; author jlam; state Exp; branches; next 1.7; 1.7 date 2000.05.20.19.32.33; author jlam; state dead; branches; next 1.6; 1.6 date 2000.03.18.17.43.17; author jlam; state Exp; branches; next 1.5; 1.5 date 99.09.19.04.24.54; author jlam; state Exp; branches; next 1.4; 1.4 date 99.01.04.13.05.01; author frueauf; state Exp; branches; next 1.3; 1.3 date 98.06.10.13.55.34; author agc; state dead; branches; next 1.2; 1.2 date 98.02.17.15.43.36; author agc; state Exp; branches; next 1.1; 1.1 date 98.02.17.15.29.56; author agc; state Exp; branches 1.1.1.1; next ; 1.1.1.1 date 98.02.17.15.29.56; author agc; state Exp; branches; next ; desc @@ 1.14 log @Delete old postgresql packages now that we have the postgresql73 ones. @ text @$NetBSD: patch-ad,v 1.13 2003/04/03 18:06:13 toshii Exp $ --- src/Makefile.global.in.orig Thu Sep 5 07:54:18 2002 +++ src/Makefile.global.in @@@@ -111,6 +111,13 @@@@ endif endif +htmldir := @@htmldir@@ +ifeq "$(findstring pgsql, $(htmldir))" "" +ifeq "$(findstring postgres, $(htmldir))" "" +override htmldir := $(docdir)/postgresql +endif +endif + javadir := $(DESTDIR)$(datadir)/java localedir := @@localedir@@ @@@@ -124,6 +131,7 @@@@ with_java = @@with_java@@ with_perl = @@with_perl@@ with_python = @@with_python@@ +with_python_compile = @@with_python_compile@@ with_tcl = @@with_tcl@@ with_tk = @@with_tk@@ enable_shared = @@enable_shared@@ @@@@ -285,13 +293,20 @@@@ libpq_builddir = $(top_builddir)/src/interfaces/libpq libpq = -L$(libpq_builddir) -lpq +libpgtcl_srcdir = $(top_srcdir)/src/interfaces/libpgtcl +libpgtcl_builddir = $(top_builddir)/src/interfaces/libpgtcl +libpgtcl = -L$(libpgtcl_builddir) -lpgtcl + submake-libpq: $(MAKE) -C $(libpq_builddir) all submake-libpgport: $(MAKE) -C $(top_builddir)/src/port all -.PHONY: submake-libpq submake-libpgport +submake-libpgtcl: + $(MAKE) -C $(libpgtcl_builddir) all + +.PHONY: submake-libpq submake-libpgport submake-libpgtcl ########################################################################## @ 1.13 log @Build py-postgresql from the postgresql 7.3.2 tarball. PKGREVISION++ Remove files and patches in the py-postgresql directory and add necessary ones in the postgresql directory. @ text @d1 1 a1 1 $NetBSD$ @ 1.12 log @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. @ text @d3 1 a3 1 --- src/Makefile.global.in.orig Wed Sep 4 18:54:18 2002 d5 1 a5 1 @@@@ -111,6 +111,13 @@@@ override docdir := $(docdir)/postgresql d19 9 a27 1 @@@@ -285,13 +292,20 @@@@ libpq_srcdir = $(top_srcdir)/src/interfa @ 1.11 log @Update postgresql and related packages to 7.2. Thanks to Michael Graff 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. @ text @d3 1 a3 1 --- src/Makefile.global.in.orig Thu Dec 20 16:23:05 2001 d5 1 a5 1 @@@@ -107,6 +107,13 @@@@ d12 1 a12 1 +override htmldir := $(htmldir)/postgresql d16 2 a17 1 odbcinst_ini_dir = @@odbcinst_ini_dir@@ d19 1 a19 11 javadir := $(DESTDIR)$(datadir)/java @@@@ -123,6 +130,7 @@@@ with_java = @@with_java@@ with_perl = @@with_perl@@ with_python = @@with_python@@ +with_python_compile = @@with_python_compile@@ with_tcl = @@with_tcl@@ with_tk = @@with_tk@@ enable_odbc = @@enable_odbc@@ @@@@ -279,6 +287,10 @@@@ libpq_srcdir = $(top_srcdir)/src/interfaces/libpq d22 1 a22 1 + d26 12 @ 1.10 log @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. @ text @d3 1 a3 1 --- src/Makefile.global.in.orig Fri Mar 16 16:50:39 2001 d5 15 a19 1 @@@@ -110,6 +110,7 @@@@ d27 1 a27 1 @@@@ -242,6 +243,10 @@@@ @ 1.9 log @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 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) @ text @d3 18 a20 3 --- interfaces/ecpg/lib/Makefile.in.orig Wed May 17 02:03:13 2000 +++ interfaces/ecpg/lib/Makefile.in Mon Jul 10 22:21:20 2000 @@@@ -12,7 +12,7 @@@@ a21 4 NAME= ecpg SO_MAJOR_VERSION= 3 -SO_MINOR_VERSION= 1.1 +SO_MINOR_VERSION= 1 d23 1 a23 2 SRCDIR= @@top_srcdir@@ include $(SRCDIR)/Makefile.global @ 1.8 log @Add these patches back @ text @d3 2 a4 2 --- interfaces/ecpg/lib/Makefile.in.orig Thu Mar 30 06:41:34 2000 +++ interfaces/ecpg/lib/Makefile.in Sat May 20 00:18:02 2000 d9 1 a9 1 -SO_MINOR_VERSION= 1.0 @ 1.7 log @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. @ text @d1 1 a1 1 $NetBSD: patch-ad,v 1.6 2000/03/18 17:43:17 jlam Exp $ d3 3 a5 4 --- bin/pg_dump/Makefile.in.orig Sun Jan 17 01:19:05 1999 +++ bin/pg_dump/Makefile.in Thu Mar 16 17:49:44 2000 @@@@ -29,7 +29,7 @@@@ all: submake pg_dump d7 4 a10 3 pg_dump: $(OBJS) $(LIBPQDIR)/libpq.a - $(CC) -o pg_dump -L$(LIBPQDIR) $(OBJS) -lpq $(LDFLAGS) + $(CC) -o pg_dump $(OBJS) $(LIBPQ) $(LDFLAGS) d12 2 a13 2 ../../utils/strdup.o: $(MAKE) -C ../../utils strdup.o @ 1.6 log @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. @ text @d1 1 a1 1 $NetBSD$ @ 1.5 log @Update postgresql to 6.5.1. Completely libtoolized and ldconfig statements removed, but this should still function correctly on a.out systems. This package was originally submitted by D'Arcy J.M. Cain, but with major overhauling by me. Closes PR#7865 and relevant part of PR#8299. Major changes from version 6.4.2: Multi-version concurrency control(MVCC) This removes our old table-level locking, and replaces it with a locking system that is superior to most commercial database systems. In a traditional system, each row that is modified is locked until committed, preventing reads by other users. MVCC uses the natural multi-version nature of PostgreSQL to allow readers to continue reading consistent data during writer activity. Writers continue to use the compact pg_log transaction system. This is all performed without having to allocate a lock for every row like traditional database systems. So, basically, we no longer are restricted by simple table-level locking; we have something better than row-level locking. Hot backups from pg_dump pg_dump takes advantage of the new MVCC features to give a consistant database dump/backup while the database stays online and available for queries. Numeric data type We now have a true numeric data type, with user-specified precision. Temporary tables Temporary tables are guaranteed to have unique names within a database session, and are destroyed on session exit. New SQL features We now have CASE, INTERSECT, and EXCEPT statement support. We have new LIMIT/OFFSET, SET TRANSACTION ISOLATION LEVEL, SELECT ... FOR UPDATE, and an improved LOCK TABLE command. Speedups We continue to speed up PostgreSQL, thanks to the variety of talents within our team. We have sped up memory allocation, optimization, table joins, and row transfer routines. Ports We continue to expand our port list, this time including WinNT/ix86 and NetBSD/arm32. Interfaces Most interfaces have new versions, and existing functionality has been improved. Documentation New and updated material is present throughout the documentation. New FAQs have been contributed for SGI and AIX platforms. The Tutorial has introductory information on SQL from Stefan Simkovics. For the User's Guide, there are reference pages covering the postmaster and more utility programs, and a new appendix contains details on date/time behavior. The Administrator's Guide has a new chapter on troubleshooting from Tom Lane. And the Programmer's Guide has a description of query processing, also from Stefan, and details on obtaining the Postgres source tree via anonymous CVS and CVSup. @ text @d3 4 a6 3 --- ./bin/pg_encoding/Makefile.orig Sat Jun 5 06:27:31 1999 +++ ./bin/pg_encoding/Makefile Sat Sep 18 03:16:50 1999 @@@@ -19,8 +19,8 @@@@ d8 3 a10 1 all: pg_encoding d12 2 a13 7 -pg_encoding: $(OBJS) $(LIBPQDIR)/libpq.a - $(CC) -o pg_encoding $(OBJS) -L$(LIBPQDIR) -lpq $(LDFLAGS) +pg_encoding: $(OBJS) + $(CC) -o pg_encoding $(OBJS) $(LIBPQ) $(LDFLAGS) install: pg_encoding $(INSTALL) $(INSTL_EXE_OPTS) pg_encoding$(X) $(BINDIR)/pg_encoding$(X) @ 1.4 log @Update postgresql to 6.4.2. Among bugfixes and new features, this also adds patches for m68k support, provided in pr 6664 by MOCHIDA Shuji. @ text @d3 3 a5 3 --- configure-orig Sun Dec 13 21:08:20 1998 +++ configure Tue Dec 29 01:34:06 1998 @@@@ -5315,8 +5315,8 @@@@ d7 9 a15 21 if test -z "$TCL_DIRS" then - # Extract the first word of "tclsh", so it can be a program name with args. -set dummy tclsh; ac_word=$2 + # Extract the first word of "tclsh8.0", so it can be a program name with args. +set dummy tclsh8.0; ac_word=$2 echo $ac_n "checking for $ac_word""... $ac_c" 1>&6 echo "configure:5322: checking for $ac_word" >&5 if eval "test \"`echo '$''{'ac_cv_path_TCLSH'+set}'`\" = set"; then @@@@ -5424,9 +5424,9 @@@@ # library_dirs are set in the check for TCL for dir in $library_dirs do - if test -d "$dir" -a -r "$dir/tkConfig.sh" + if test -d "$dir" -a -r "$dir/../tk8.0/tkConfig.sh" then - TK_CONFIG_SH=$dir/tkConfig.sh + TK_CONFIG_SH=$dir/../tk8.0/tkConfig.sh break fi done @ 1.3 log @Upgrade to the latest and greatest version (6.3.2) of PostgreSQL. They told me to say that. Use addnerd to create the user. @ text @d1 27 a27 29 --- template/freebsd.orig Sat Jun 14 20:12:51 1997 +++ template/freebsd Sat Jun 14 20:13:06 1997 @@@@ -1,9 +1,9 @@@@ AROPT:cq SHARED_LIB:-fpic -DPIC -CFLAGS:-O2 -m486 -pipe +CFLAGS:-pipe -O2 SRCH_INC:/usr/local/include SRCH_LIB:/usr/local/lib -USE_LOCALE:no +USE_LOCALE:yes DLSUFFIX:.so YFLAGS:-d YACC:bison -y --- template/netbsd 1998/02/16 15:09:26 1.1 +++ template/netbsd 1998/02/16 15:09:57 @@@@ -1,9 +1,9 @@@@ AROPT:cq SHARED_LIB:-fpic -DPIC CFLAGS:-O2 -pipe -SRCH_INC:/usr/local/include -SRCH_LIB:/usr/local/lib -USE_LOCALE:no +SRCH_INC:${PREFIX}/include +SRCH_LIB:${PREFIX}/lib +USE_LOCALE:yes DLSUFFIX:.so YFLAGS:-d YACC: @ 1.2 log @Changes to the basic NetBSD template. Look for headers in ${PREFIX}/include, and libraries in ${PREFIX}/lib, rather than having them hardcoded. @ text @@ 1.1 log @Initial revision @ text @d15 15 @ 1.1.1.1 log @Initial import of Postgresql 6.2.1, an Object Relational Database Management System, into the NetBSD packages collection, from the FreeBSD port. @ text @@