head 1.11; access; symbols pkgsrc-2013Q2:1.11.0.48 pkgsrc-2013Q2-base:1.11 pkgsrc-2012Q4:1.11.0.46 pkgsrc-2012Q4-base:1.11 pkgsrc-2011Q4:1.11.0.44 pkgsrc-2011Q4-base:1.11 pkgsrc-2011Q2:1.11.0.42 pkgsrc-2011Q2-base:1.11 pkgsrc-2009Q4:1.11.0.40 pkgsrc-2009Q4-base:1.11 pkgsrc-2008Q4:1.11.0.38 pkgsrc-2008Q4-base:1.11 pkgsrc-2008Q3:1.11.0.36 pkgsrc-2008Q3-base:1.11 cube-native-xorg:1.11.0.34 cube-native-xorg-base:1.11 pkgsrc-2008Q2:1.11.0.32 pkgsrc-2008Q2-base:1.11 pkgsrc-2008Q1:1.11.0.30 pkgsrc-2008Q1-base:1.11 pkgsrc-2007Q4:1.11.0.28 pkgsrc-2007Q4-base:1.11 pkgsrc-2007Q3:1.11.0.26 pkgsrc-2007Q3-base:1.11 pkgsrc-2007Q2:1.11.0.24 pkgsrc-2007Q2-base:1.11 pkgsrc-2007Q1:1.11.0.22 pkgsrc-2007Q1-base:1.11 pkgsrc-2006Q4:1.11.0.20 pkgsrc-2006Q4-base:1.11 pkgsrc-2006Q3:1.11.0.18 pkgsrc-2006Q3-base:1.11 pkgsrc-2006Q2:1.11.0.16 pkgsrc-2006Q2-base:1.11 pkgsrc-2006Q1:1.11.0.14 pkgsrc-2006Q1-base:1.11 pkgsrc-2005Q4:1.11.0.12 pkgsrc-2005Q4-base:1.11 pkgsrc-2005Q3:1.11.0.10 pkgsrc-2005Q3-base:1.11 pkgsrc-2005Q2:1.11.0.8 pkgsrc-2005Q2-base:1.11 pkgsrc-2005Q1:1.11.0.6 pkgsrc-2005Q1-base:1.11 pkgsrc-2004Q4:1.11.0.4 pkgsrc-2004Q4-base:1.11 pkgsrc-2004Q3:1.11.0.2 pkgsrc-2004Q3-base:1.11 pkgsrc-2004Q2:1.10.0.6 pkgsrc-2004Q2-base:1.10 pkgsrc-2004Q1:1.10.0.4 pkgsrc-2004Q1-base:1.10 pkgsrc-2003Q4:1.10.0.2 pkgsrc-2003Q4-base:1.10 netbsd-1-6:1.8.0.8 netbsd-1-6-RELEASE-base:1.8 pkgviews:1.8.0.4 pkgviews-base:1.8 buildlink2:1.8.0.2 buildlink2-base:1.8 netbsd-1-5-PATCH003:1.8 netbsd-1-5-PATCH001:1.7 netbsd-1-5-RELEASE:1.7 netbsd-1-4-PATCH003:1.7 netbsd-1-3-PATCH002:1.1.1.1 FreeBSD-current-1998-02-16:1.1.1.1 FREEBSD:1.1.1; locks; strict; comment @# @; 1.11 date 2004.07.24.22.48.14; author recht; state dead; branches; next 1.10; 1.10 date 2003.04.03.18.06.14; author toshii; state Exp; branches; next 1.9; 1.9 date 2003.01.05.20.12.17; author jlam; state dead; branches; next 1.8; 1.8 date 2001.05.14.14.52.38; author jlam; state Exp; branches; next 1.7; 1.7 date 2000.07.14.04.44.53; author jlam; state Exp; branches; next 1.6; 1.6 date 2000.05.20.19.32.43; author jlam; state dead; branches; next 1.5; 1.5 date 2000.03.18.17.43.55; author jlam; state Exp; branches; next 1.4; 1.4 date 99.09.20.23.38.49; author jlam; state dead; branches; next 1.3; 1.3 date 99.09.19.04.24.55; author jlam; state Exp; branches; next 1.2; 1.2 date 98.06.10.13.55.35; author agc; state dead; 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.11 log @Delete old postgresql packages now that we have the postgresql73 ones. @ text @$NetBSD: patch-ai,v 1.10 2003/04/03 18:06:14 toshii Exp $ --- src/interfaces/python/Setup.in.raw.orig Sun Mar 25 14:44:04 2001 +++ src/interfaces/python/Setup.in.raw @@@@ -1,3 +1,3 @@@@ *shared* -_pg pgmodule.c -I@@libpq_srcdir@@ @@INCLUDES@@ -L@@libpq_builddir@@ -lpq @@EXTRA_LIBS@@ +_pg pgmodule.c -I@@libpq_srcdir@@ @@INCLUDES@@ @@libpq@@ @@EXTRA_LIBS@@ @ 1.10 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: patch-ad,v 1.1 2003/01/05 19:26:21 jlam Exp $ @ 1.9 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 @d1 1 a1 1 $NetBSD: patch-ai,v 1.8 2001/05/14 14:52:38 jlam Exp $ d3 1 a3 1 --- src/interfaces/python/Setup.in.raw.orig Sun Apr 1 15:17:33 2001 @ 1.8 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 @d1 1 a1 1 $NetBSD$ @ 1.7 log @Forgot these patches @ text @d3 4 a6 8 --- include/port/netbsd.h.orig Wed Apr 12 13:16:48 2000 +++ include/port/netbsd.h Wed Jul 12 02:31:08 2000 @@@@ -3,43 +3,48 @@@@ #if defined(__i386__) #define NEED_I386_TAS_ASM #define HAS_TEST_AND_SET +typedef unsigned char slock_t; #endif d8 2 a9 47 #if defined(__sparc__) #define NEED_SPARC_TAS_ASM #define HAS_TEST_AND_SET +typedef unsigned char slock_t; #endif #if defined(__vax__) #define NEED_VAX_TAS_ASM #define HAS_TEST_AND_SET +typedef unsigned char slock_t; #endif #if defined(__ns32k__) #define NEED_NS32K_TAS_ASM #define HAS_TEST_AND_SET +typedef unsigned char slock_t; #endif #if defined(__m68k__) #define HAS_TEST_AND_SET +typedef unsigned char slock_t; #endif #if defined(__arm__) #define HAS_TEST_AND_SET +typedef unsigned char slock_t; #endif #if defined(__mips__) /* # undef HAS_TEST_AND_SET */ +typedef unsigned char slock_t; #endif -#if defined(__powerpc__) +#if defined(__alpha__) #define HAS_TEST_AND_SET +typedef unsigned long slock_t; #endif #if defined(__powerpc__) +#define HAS_TEST_AND_SET typedef unsigned int slock_t; - -#else -typedef unsigned char slock_t; - #endif @ 1.6 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-ai,v 1.5 2000/03/18 17:43:55 jlam Exp $ d3 7 a9 3 --- bin/psql/psql.c.orig Fri Jun 4 17:21:13 1999 +++ bin/psql/psql.c Thu Mar 16 17:49:44 2000 @@@@ -45,28 +45,23 @@@@ d12 31 a42 28 #ifdef HAVE_LIBREADLINE -#ifdef HAVE_READLINE_H -#include -#define USE_READLINE 1 -#if defined(HAVE_HISTORY_H) -#include -#define USE_HISTORY 1 -#endif -#else #if defined(HAVE_READLINE_READLINE_H) #include #define USE_READLINE 1 +#elif defined(HAVE_READLINE_H) +#include +#define USE_READLINE 1 +#endif +#endif +#if defined(HAVE_HISTORY) #if defined(HAVE_READLINE_HISTORY_H) #include #define USE_HISTORY 1 -#endif -#endif -#endif -#if defined(HAVE_HISTORY) && !defined(USE_HISTORY) +#elif defined(HAVE_HISTORY_H) +#include #define USE_HISTORY 1 d44 5 d50 4 d55 4 a58 3 #ifdef WIN32 #define popen(x,y) _popen(x,y) @ 1.5 log @Missed this patch @ text @d1 1 a1 1 $NetBSD$ @ 1.4 log @Update PostgreSQL to 6.5.2. The pgaccess binary is no longer available from the main PostgreSQL distribution, and must be installed separately (databases/pgaccess). Relevant changes from 6.5.1: subselect+CASE fixes(Tom) Add SHLIB_LINK setting for solaris_i386 and solaris_sparc ports(Daren Sefcik) Fixes for CASE in WHERE join clauses(Tom) Fix BTScan abort(Tom) Repair the check for redundant UNIQUE and PRIMARY KEY indices(Thomas) Improve it so that it checks for multi-column constraints(Tom) Fix for Win32 making problem with MB enabled(Hiroki Kataoka) Allow BSD yacc and bison to compile pl code(Bruce) Fix SET NAMES int8 fixes(Thomas) Fix vacuum's memory consumption(Hiroshi,Tatsuo) Reduce the total memory consumption of vacuum(Tom) Fix for timestamp(datetime) Rule deparsing bugfixes(Tom) Fix quoting problems in mkMakefile.tcldefs.sh.in and mkMakefile.tkdefs.sh.in(Tom) This is to re-use space on index pages freed by vacuum(Vadim) document -x for pg_dump(Bruce) Fix for unary operators in rule deparser(Tom) Comment out FileUnlink of excess segments during mdtruncate()(Tom) Irix linking fix from Yu Cao Repair logic error in LIKE: should not return LIKE_ABORT when reach end of pattern before end of text(Tom) Repair incorrect cleanup of heap memory allocation during transaction abort(Tom) @ text @d1 1 a1 1 $NetBSD: patch-ai,v 1.3 1999/09/19 04:24:55 jlam Exp $ d3 4 a6 18 --- ./configure.orig Sat May 29 20:06:44 1999 +++ ./configure Sat Sep 18 03:21:47 1999 @@@@ -628,11 +628,7 @@@@ bsdi*) os=bsdi need_tas=no ;; freebsd1*|freebsd2*) os=freebsd need_tas=no ;; freebsd*) os=freebsd need_tas=no elf=yes ;; - netbsd*) - os=bsd need_tas=no - case "$host_cpu" in - powerpc) elf=yes ;; - esac ;; + netbsd*) os=bsd need_tas=no elf=maybe ;; # mix of a.out & ELF platforms openbsd*) os=bsd need_tas=no ;; dgux*) os=dgux need_tas=no ;; aix*) os=aix need_tas=no ;; @@@@ -663,13 +659,6 @@@@ exit;; esac d8 30 a37 6 -if test "X$elf" = "Xyes" -then - ELF_SYS=true -else - ELF_SYS= -fi a38 26 if test "X$need_tas" = "Xyes" then @@@@ -1418,6 +1407,23 @@@@ LDFLAGS="$LDFLAGS $PGSQL_LDFLAGS" echo "- setting LDFLAGS=$LDFLAGS" + +# Check for ELF after finding compiler. +case "X$elf" in +Xmaybe) + if ${CC} -E - -dM raddr.sin_addr, database, &host_ok, &userauth, pw_file_name, true); @@@@ -90,7 +90,14 @@@@ if (test_pw[strlen(test_pw) - 1] == '\n') test_pw[strlen(test_pw) - 1] = '\0'; a54 9 - strNcpy(salt, test_pw, 2); + if (strncmp(test_pw, "$1$", 3)) { + /* DES */ + strNcpy(salt, test_pw, 2); + } + else { + /* MD5 */ + strncpy(salt, test_pw, 9); + } a55 2 if (strcmp(user, test_user) == 0) { @ 1.1 log @Initial revision @ text @@ 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 @@