summaryrefslogtreecommitdiff
path: root/databases/postgresql
AgeCommit message (Collapse)AuthorFilesLines
2000-07-15Install the Server Programming Interface header files.jlam4-18/+122
Closes PR#10480.
2000-07-14Forgot these patchesjlam3-0/+100
2000-07-14Update postgresql to 7.0.2. Relevant changes from 7.0:jlam11-67/+78
* 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)
2000-06-20Don't install the extra shared library links on a.out platforms.jlam2-1/+22
2000-05-29Remove dependency on "bison". Closes PR pkg/10224, by SUNAGAWA Keiki.fredb1-2/+1
2000-05-24Fix MASTER_SITESrh1-4/+8
Add some additional mirrors
2000-05-20Add these patches backjlam6-0/+99
2000-05-20Update postgresql to 7.0. Also closes PR#8616. Changes from 6.5.3:jlam30-1287/+964
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.
2000-04-09Put headers into /include/pgsql.jlam3-40/+45
2000-03-18Missed this patchjlam1-0/+41
2000-03-18Change structure of postgresql package. Shared library build is nowjlam35-841/+782
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.
2000-03-05Regen.kleink1-1/+2
2000-03-05Always test for -D__architecture__ rather than -Darchitecture; newer toolchainskleink1-0/+24
(i.e. ELF on former a.out ports) are namespace-clean wrt. this, and the latter predefine implies the former.
2000-02-20Hmmm. I thought I'd committed this a long time ago...jwise3-8/+20
Split PGSQL_USE_TCL into PGSQL_USE_TCL and PGSQL_USE_TK so that postgres can be built with tcl support on a machine without tk (such as a machine without X installed...)
2000-02-04Correct SHLIB_LINK redefinition and update patch checksums (patch-ak wasjlam2-5/+5
out of synch)
2000-01-18Patch to make the interfaces/jdbc directory usable, even though this packagejwise2-2/+15
doesn't use it. Later tonight or tomorrow morning, I will commit a jdbc-postgresql package which will share DISTFILE and patch goo with this package. All this may eventually be replaced if the client stuff is factored out of the postgresql package, but that's not me.
2000-01-15Update dependency on ncurses to >=4.2jlam1-2/+2
2000-01-05Strip trailing '.', and/or leading '(a|an) 'abs1-1/+1
1999-12-28replaced some commands by their ${COMMAND} counterpartswiz1-2/+2
1999-12-02upgraded PostgreSQL to 6.5.3 and updated the dependent Makefilesdarcy2-6/+7
1999-09-21Add slash to index URL.soren1-2/+2
1999-09-20Update PostgreSQL to 6.5.2. The pgaccess binary is no longer availablejlam12-175/+87
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 <yucao@falcon.kla-tencor.com> 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)
1999-09-20Change the semantics of PGSQL_USE_TCL to be YES/NO, defaulting to YES sincejlam1-13/+20
the old 6.4.2 package included the Tcl/Tk stuff. "Backwards compatible upgrade."
1999-09-19Apply fix suggested in PR#7445 to check for existence of group beforejlam1-12/+13
adding PostgreSQL user to the group. Closes PR#7445.
1999-09-19Update postgresql to 6.5.1. Completely libtoolized and ldconfig statementsjlam25-739/+1649
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.
1999-09-06Add dependency on ncurses, and create ${PREFIX}/${PGUSER} beforehubertf1-2/+4
"make install". Makes this package compile on 1.4.1.
1999-09-06regen after last commithubertf1-2/+2
1999-09-06Use "PLIST_SUBST=PGUSER=${PGUSER}".sakamoto3-236/+235
Add NetBSD Id to patch-ae. s|/usr/sbin/chown|${CHOWN}| s|/bin/chmod|${CHMOD}|
1999-08-24Make sure that "bison" binary from package sources is used.tron1-2/+2
1999-08-18Record build options in the BuildInfo file via BUILD_DEFS. These can beagc1-2/+4
displayed using the -B option to pkg_info(1).
1999-07-13Must list tcl and tk includes in --with-includes. Noticed bybad1-4/+3
Bjoern Labitzke. Also, libs and includes are found in LOCALBASE.
1999-07-11Split out second part of patch-af and make it apply and work correctly.bad3-20/+23
Fixes PR pkg/7959.
1999-07-09Add package patch-sum filesagc1-0/+8
1999-06-06${...:M...} is not fully glob() compliant. Don't use {,} constructs.tv1-2/+2
1999-06-04NOT_FOR_PLATFORM= *-*-{alpha,mips} doesn't work.drochner1-2/+2
Worse - it matches (almost?) everything.
1999-05-24Change {ONLY,NOT}_FOR_{ARCH,OPSYS} format to {ONLY,NOT}_FOR_PLATFORMtv1-29/+29
pattern match format. Minor pkglint along the way.
1999-05-18Provide test-and-set primitive on arm32.bad1-0/+46
From Andrew McMurry <a.mcmurry1@physics.oxford.ac.uk>.
1999-04-13Remove NOPORTDOCS definition - it was useless anyway, as any attempt toagc1-3/+1
build a binary package with this definition would fail as the PLIST is not correct. If a package's documentation is overwhelming, it should arguably be handled in a separate pre-requisite documentation package.
1999-04-01Upgrade to tcl version 8.0.5. This seems to be primarily a bug-fixagc1-3/+3
release.
1999-03-28Make it possible to build a binary package by moving the "accounthubertf2-7/+49
management" into a REQ script.
1999-03-05Remove bogus path prefixes from filenames.mellon1-9/+9
1999-03-05Patch to fix some arm32 configure problems.mellon1-0/+61
1999-02-19Chane versioned DEPENDS on bison to BUILD_DEPENDS. This should have beenfrueauf1-4/+3
done with the bison update.
1999-02-06Don't build the directory, as addnerd does this for us and will failhwr1-3/+2
if it already exists. Should fix pkg/6949 by Nigel Reed <nigel@nelgin.nu>. Also don't assume ${prefix}/sbin is in the search path and call addnerd with complete path.
1999-01-17Whoops, I wanted to adjust the comment.frueauf1-2/+2
1999-01-17Add mips to NOT_FOR_ARCHS list. There is no TAS implementation.frueauf1-2/+3
Someone with mips assemply knowledge needed :)
1999-01-09Get rid of obsolete chown(8) operand usage.kleink1-2/+2
1999-01-08Add some cosmetics pointed out in pr 6758 by Greg A. Woods:frueauf2-25/+14
- add INSTALL_TARGET=install install-man and remove the patch that did modify the GNUMakefile, for better maintainance. - add - in front of @${MKDIR} to silently fail if the dir already exists - move ld.so.conf warning near the end, so it can be better spotted.
1999-01-04Forgot to commit this: s/pgsql/!!PGUSER!!/ cause we don't hardcodefrueauf1-6/+6
that into our package. This will get substituted at build time.
1999-01-04Update postgresql to 6.4.2. Among bugfixes and new features, this alsofrueauf8-245/+487
adds patches for m68k support, provided in pr 6664 by MOCHIDA Shuji.
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-07 13:11:54 +0000