The NetBSD Project

CVS log for pkgsrc/databases/postgresql/pkg/Attic/PLIST

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql / pkg

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.20
Thu Nov 1 00:12:34 2001 UTC (25 years ago) by zuntum
Branches: MAIN
CVS tags: pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2012Q4-base, pkgsrc-2012Q4, pkgsrc-2011Q4-base, pkgsrc-2011Q4, pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2009Q4-base, pkgsrc-2009Q4, pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, pkgsrc-2008Q1-base, pkgsrc-2008Q1, pkgsrc-2007Q4-base, pkgsrc-2007Q4, pkgsrc-2007Q3-base, pkgsrc-2007Q3, pkgsrc-2007Q2-base, pkgsrc-2007Q2, pkgsrc-2007Q1-base, pkgsrc-2007Q1, pkgsrc-2006Q4-base, pkgsrc-2006Q4, pkgsrc-2006Q3-base, pkgsrc-2006Q3, pkgsrc-2006Q2-base, pkgsrc-2006Q2, pkgsrc-2006Q1-base, pkgsrc-2006Q1, pkgsrc-2005Q4-base, pkgsrc-2005Q4, pkgsrc-2005Q3-base, pkgsrc-2005Q3, pkgsrc-2005Q2-base, pkgsrc-2005Q2, pkgsrc-2005Q1-base, pkgsrc-2005Q1, pkgsrc-2004Q4-base, pkgsrc-2004Q4, pkgsrc-2004Q3-base, pkgsrc-2004Q3, pkgsrc-2004Q2-base, pkgsrc-2004Q2, pkgsrc-2004Q1-base, pkgsrc-2004Q1, pkgsrc-2003Q4-base, pkgsrc-2003Q4, cube-native-xorg-base, cube-native-xorg, buildlink2-base, HEAD
FILE REMOVED
Changes since revision 1.19: +1 -1 lines
Move pkg/ files into package's toplevel directory

Revision 1.19: download - view: text, markup, annotated - select for diffs
Mon May 14 14:52:39 2001 UTC (25 years, 6 months ago) by jlam
Branches: MAIN
Diff to: previous 1.18: preferred, colored
Changes since revision 1.18: +2 -1038 lines
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.

Revision 1.18: download - view: text, markup, annotated - select for diffs
Sun Mar 25 11:29:38 2001 UTC (25 years, 7 months ago) by wennmach
Branches: MAIN
CVS tags: netbsd-1-5-PATCH001
Diff to: previous 1.17: preferred, colored
Changes since revision 1.17: +2 -3 lines
Make pgsql's home directory configurable. This is useful e. g. in cases
where ${PREFIX} is mounted read-only etc. Checked with Johnny C. Lam,
who suggested two additional changes.

Revision 1.17: download - view: text, markup, annotated - select for diffs
Thu Jan 4 15:10:24 2001 UTC (25 years, 10 months ago) by agc
Branches: MAIN
Diff to: previous 1.16: preferred, colored
Changes since revision 1.16: +9 -1 lines

The way that shared objects were handled in the PLISTs and bsd.pkg.mk was
out of date - it was based on a.out OBJECT_FMT, and added entries in the
generated PLISTs to reflect the symlinks that ELF packages uses. It also
tried to be clever, and removed and recreated any symbolic links that were
created, which has resulted in some fun, especially with packages which
use dlopen(3) to load modules. Some recent changes to our ld.so to bring
it more into line with other Operating Systems also exposed some cracks.

+ Modify bsd.pkg.mk and its shared object handling, so that PLISTs now contain
the ELF symlinks.
+ Don't mess about with file system entries when handling shared objects in
bsd.pkg.mk, since it's likely that libtool and the BSD *.mk processing will
have got it right, and have a much better idea than we do.
+ Modify PLISTs to contain "ELF symlinks"
+ On a.out platforms, delete any "ELF symlinks" from the generated PLISTs
+ On ELF platforms, no extra processing needs to be done in bsd.pkg.mk
+ Modify print-PLIST target in bsd.pkg.mk to add dummy symlink entries on
a.out platforms
+ Update the documentation in Packages.txt

With many thanks to Thomas Klausner for keeping me honest with this.

Revision 1.16: download - view: text, markup, annotated - select for diffs
Thu Sep 21 14:34:56 2000 UTC (26 years, 2 months ago) by jlam
Branches: MAIN
CVS tags: netbsd-1-5-RELEASE, netbsd-1-4-PATCH003
Diff to: previous 1.15: preferred, colored
Changes since revision 1.15: +2 -2 lines
Install rc.d control script as "pgsql" instead of "pgsql.sh" to comply with
how NetBSD's rc.d system interprets script names.  Also add appropriate
REQUIRE and PROVIDE sections to allow direct use in NetBSD's rc.d system.

Revision 1.15: download - view: text, markup, annotated - select for diffs
Sat Jul 15 01:23:57 2000 UTC (26 years, 4 months ago) by jlam
Branches: MAIN
Diff to: previous 1.14: preferred, colored
Changes since revision 1.14: +1 -17 lines
Install the Server Programming Interface header files.
Closes PR#10480.

Revision 1.14: download - view: text, markup, annotated - select for diffs
Fri Jul 14 04:44:13 2000 UTC (26 years, 4 months ago) by jlam
Branches: MAIN
Diff to: previous 1.13: preferred, colored
Changes since revision 1.13: +2 -5 lines
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)

Revision 1.13: download - view: text, markup, annotated - select for diffs
Sat May 20 19:33:00 2000 UTC (26 years, 6 months ago) by jlam
Branches: MAIN
Diff to: previous 1.12: preferred, colored
Changes since revision 1.12: +907 -797 lines
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.

Revision 1.12: download - view: text, markup, annotated - select for diffs
Sun Apr 9 03:53:17 2000 UTC (26 years, 7 months ago) by jlam
Branches: MAIN
Diff to: previous 1.11: preferred, colored
Changes since revision 1.11: +38 -36 lines
Put headers into /include/pgsql.

Revision 1.11: download - view: text, markup, annotated - select for diffs
Sat Mar 18 17:43:18 2000 UTC (26 years, 8 months ago) by jlam
Branches: MAIN
Diff to: previous 1.10: preferred, colored
Changes since revision 1.10: +938 -414 lines
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.

Revision 1.10
Sun Sep 19 04:24:55 1999 UTC (27 years, 2 months ago) by jlam
Branches: MAIN
FILE REMOVED
Changes since revision 1.9: +1 -1 lines
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.

Revision 1.9: download - view: text, markup, annotated - select for diffs
Mon Sep 6 07:01:44 1999 UTC (27 years, 2 months ago) by sakamoto
Branches: MAIN
Diff to: previous 1.8: preferred, colored
Changes since revision 1.8: +227 -227 lines
Use "PLIST_SUBST=PGUSER=${PGUSER}".
Add NetBSD Id to patch-ae.
s|/usr/sbin/chown|${CHOWN}|
s|/bin/chmod|${CHMOD}|

Revision 1.8: download - view: text, markup, annotated - select for diffs
Mon Jan 4 13:05:02 1999 UTC (27 years, 10 months ago) by frueauf
Branches: MAIN
CVS tags: netbsd-1-4-RELEASE, netbsd-1-4-PATCH001
Diff to: previous 1.7: preferred, colored
Changes since revision 1.7: +340 -226 lines
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.

Revision 1.7: download - view: text, markup, annotated - select for diffs
Wed Jul 15 12:40:14 1998 UTC (28 years, 4 months ago) by agc
Branches: MAIN
CVS tags: netbsd-1-3-PATCH003
Diff to: previous 1.6: preferred, colored
Changes since revision 1.6: +1 -2 lines
Use automatic shared object handling

Revision 1.6: download - view: text, markup, annotated - select for diffs
Mon Jun 22 14:00:16 1998 UTC (28 years, 5 months ago) by frueauf
Branches: MAIN
Diff to: previous 1.5: preferred, colored
Changes since revision 1.5: +210 -210 lines
The postgresql subdir is user definable, reflect that here.

Revision 1.5: download - view: text, markup, annotated - select for diffs
Wed Jun 10 13:55:35 1998 UTC (28 years, 5 months ago) by agc
Branches: MAIN
Diff to: previous 1.4: preferred, colored
Changes since revision 1.4: +122 -52 lines
Upgrade to the latest and greatest version (6.3.2) of PostgreSQL.
They told me to say that.

Use addnerd to create the user.

Revision 1.4: download - view: text, markup, annotated - select for diffs
Sat May 9 18:32:57 1998 UTC (28 years, 6 months ago) by hubertf
Branches: MAIN
CVS tags: netbsd-1-3-PATCH002
Diff to: previous 1.3: preferred, colored
Changes since revision 1.3: +5 -5 lines
%D is needed on @unexec

Revision 1.3: download - view: text, markup, annotated - select for diffs
Wed Feb 18 17:51:01 1998 UTC (28 years, 9 months ago) by agc
Branches: MAIN
Diff to: previous 1.2: preferred, colored
Changes since revision 1.2: +3 -1 lines
Add pgaccess.

Revision 1.2: download - view: text, markup, annotated - select for diffs
Tue Feb 17 15:46:10 1998 UTC (28 years, 9 months ago) by agc
Branches: MAIN
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +9 -8 lines
Add NetBSD RCS Id.
Correct names of two FAQ files.
Only delete the tcl/tk-related files if they were installed.

Revision 1.1.1.1 (vendor branch): download - view: text, markup, annotated - select for diffs
Tue Feb 17 15:29:55 1998 UTC (28 years, 9 months ago) by agc
Branches: FREEBSD
CVS tags: FreeBSD-current-1998-02-16
Diff to: previous 1.1: preferred, colored
Changes since revision 1.1: +0 -0 lines
Initial import of Postgresql 6.2.1, an Object Relational Database
Management System, into the NetBSD packages collection, from the
FreeBSD port.

Revision 1.1: download - view: text, markup, annotated - select for diffs
Tue Feb 17 15:29:55 1998 UTC (28 years, 9 months ago) by agc
Branches: MAIN
Initial revision

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>