summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2002-04-04Update postgresql and related packages to 7.2. Thanks to Michael Graffjlam30-955/+804
<explorer@flame.org> 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.
2002-04-04Fix bug in in "/etc/rc.d/pgsql stop": we need to use "fast" mode ratherjlam1-76/+74
than "smart" mode so that the the database will always cleanly shutdown. Previously, postgres would wait for clients to disconnect before stopping the database process, which sometimes resulted in unclean shutdowns. Problem noted by Curt Sampson <cjs@cynic.net> in private email. I also convert this to use /etc/rc.subr if it is present.
2002-04-03Add distinfo file required for standalone packages.jlam1-0/+9
2002-04-03Make odbc-postgresql build stand-alone instead of requiring Makefile.commonjlam6-8/+298
from databases/postgresql. Also honor PKG_SYSCONFDIR.
2002-04-03Substitute ${TRUE} for "true".jlam1-3/+3
2002-03-30Make conf-ld to make it build on Darwin. pkg/15467yyamano1-1/+2
2002-03-30Add & enable db4.uebayasi1-1/+2
2002-03-30Initial import of Sleepycat db4 provided by Alex Newman <dolemite@wuli.nu>uebayasi6-0/+1246
in pkg/16075. From DESCR: Berkeley DB is an embeddable database system that supports keyed access to data. The software is distributed in source code form, and developers can compile and link the source code into a single library for inclusion directly in their applications.
2002-03-25Adjust syscalls-powerpc-netbsd.S so it will build correctly again.briggs2-1/+128
Problem reported on port-macppc by Ryan La Riviere <larz@cbis.ece.drexel.edu>.
2002-03-21Bump dependency on ruby-base and ${PKGREVISION} as a result of thefredb1-1/+4
fix to ${MACHINE_GNU_PLATFORM} causing ${RUBY_SITEARCHLIBDIR} to be moved on certain ports.
2002-03-20Updated p5-DBD-mysql to 1.2219martti3-18/+19
Changes since 2.2216 are missing, here is the changes from 1.2215 to 1.2216 : * Portability changes for mSQL 3 and MySQL 4. * Added transaction support for MySQL. (Bob Lyons <lyons@nextrials.com>) * dbd/dbdimp.c: Fixed MAXLENGTH warning; used to hint for a not existing mysql_maxlength, which should read mysql_max_length. (Paul DuBois <paul@snake.net>) * Fixed installation problem when a directory was specified, but did not exist. (Will Partain <partain@dcs.gla.ac.uk>) * Fixed that mysql_errno wasn't used properly. (Chris Adams <cmadams@hiwaay.net>) * Fixed test suite problem, when user name and password have been interpolated. (Bruno Hivert (LMC) <lmcbrhi@lmc.ericsson.se>) * mysql_insertid and mysql_affectedrows are no longer treated as integers, but longs. Thanks to Michael G Schwern <schwern@pobox.com>.
2002-03-18Updated mysql-server to 3.23.49martti4-18/+18
* Don't give warning for statement that is only a comment; This is needed for mysqldump --disable-keys to work. * Fixed unlikely caching bug when doing a join without keys. In this case the last used field for a table always returned NULL. * Added options to make LOAD DATA LOCAL INFILE more secure. * Added --xml option to mysqldump for producing XML output. * Changed to use autoconf 2.52 (from autoconf 2.13) * Fixed bug in complicated join with const tables. * Added internal safety checks for InnoDB. * Some InnoDB variables was always shown in SHOW VARIABLES as OFF on high-byte-first systems (like sparc). * Fixed problem with one thread using an InnoDB table and another thread doing an ALTER TABLE on the same table. Before that, mysqld could crash with an assertion failure in row0row.c, line 474. * Tuned the InnoDB SQL optimizer to favor more often index searches over table scans. SELECT queries will now also generally run faster on all platforms. * If MySQL binlogging is used, InnoDB now prints after crash recovery the latest MySQL binlog name and the offset InnoDB was able to recover to. This is useful, for example, when resynchronizing a master and a slave database in replication. * Added better error messages to help in installation problems of InnoDB tables. * One can now recover also MySQL temporary tables which have become orphaned inside the InnoDB tablespace. * InnoDB now prevents a FOREIGN KEY declaration where the signedness is not the same in the referencing and referenced integer columns. * Calling SHOW CREATE TABLE or SHOW TABLE STATUS could cause memory corruption and make mysqld to crash. Especially at risk was mysqldump, because it calls frequently SHOW CREATE TABLE. * If inserts to several tables containing an auto-inc column were wrapped inside one LOCK TABLES, InnoDB asserted in lock0lock.c. * In 3.23.47 we allowed several NULLS in a UNIQUE secondary index for an InnoDB table. But CHECK TABLE was not relaxed: it reports the table as corrupt. CHECK TABLE no longer complains in this situation. * SHOW GRANTS now shows REFERENCES instead of REFERENCE.
2002-03-18Updated mysql-client to 3.23.49martti4-12/+12
* Don't give warning for statement that is only a comment; This is needed for mysqldump --disable-keys to work. * Fixed unlikely caching bug when doing a join without keys. In this case the last used field for a table always returned NULL. * Added options to make LOAD DATA LOCAL INFILE more secure. * Added --xml option to mysqldump for producing XML output. * Changed to use autoconf 2.52 (from autoconf 2.13) * Fixed bug in complicated join with const tables. * Added internal safety checks for InnoDB. * Some InnoDB variables was always shown in SHOW VARIABLES as OFF on high-byte-first systems (like sparc). * Fixed problem with one thread using an InnoDB table and another thread doing an ALTER TABLE on the same table. Before that, mysqld could crash with an assertion failure in row0row.c, line 474. * Tuned the InnoDB SQL optimizer to favor more often index searches over table scans. SELECT queries will now also generally run faster on all platforms. * If MySQL binlogging is used, InnoDB now prints after crash recovery the latest MySQL binlog name and the offset InnoDB was able to recover to. This is useful, for example, when resynchronizing a master and a slave database in replication. * Added better error messages to help in installation problems of InnoDB tables. * One can now recover also MySQL temporary tables which have become orphaned inside the InnoDB tablespace. * InnoDB now prevents a FOREIGN KEY declaration where the signedness is not the same in the referencing and referenced integer columns. * Calling SHOW CREATE TABLE or SHOW TABLE STATUS could cause memory corruption and make mysqld to crash. Especially at risk was mysqldump, because it calls frequently SHOW CREATE TABLE. * If inserts to several tables containing an auto-inc column were wrapped inside one LOCK TABLES, InnoDB asserted in lock0lock.c. * In 3.23.47 we allowed several NULLS in a UNIQUE secondary index for an InnoDB table. But CHECK TABLE was not relaxed: it reports the table as corrupt. CHECK TABLE no longer complains in this situation. * SHOW GRANTS now shows REFERENCES instead of REFERENCE.
2002-03-14Update to 0.53, based on pkg/15066.wiz4-12/+19
Changes since 0.51: - tdspool now working for big endian systems - Added some descriptive text to the PWD file - EINTR handling during login (Kostya Ivanov) - Added support for TLI style interfaces files (thanks Michael for explaining) - Added 'text size' config option which changes textsize on connect - Added preliminary TDS 8.0 support (no new datatypes supported though) - Added 'emulate little endian' config flag - Some TDS5 placeholder stuff. Not ready for primetime yet. - Added support for new configuration format (freetds.conf) - unixODBC now working - Added support for nullable bits (BITN) - checked in work on tds connection pooling server - added preliminary userguide (James Lowden and me) - a lot of work on ODBC driver, now works with PHP - added config options for iodbc/unixodbc (unixODBC doesn't actually work yet) - image -> char now works (verified with ctlib only) - varbinary -> char now works with destlen of -1 - New config routines - numeric problem with 7.0 fixed - digit cutoff on numerics/floats fixed As well as some bug fixes.
2002-03-14Update p5-DBD-postgresql to 1.11mjl2-6/+6
* Pg.pm (quote): Applied patch to simplfiy and speed up quoting.
2002-03-13Give all packages which depend on "png" a version bump, and updatefredb6-9/+15
all dependencies on packages depending on "png" which contain shared libraries, all for the (imminent) update to the "png" package. [List courtesy of John Darrow, courtesy of "bulk-build".]
2002-03-12Add directory level "source" to MASTER_SITES. Only the newest versiontv1-9/+9
(now 7.2, but I'm not in a position to upgrade the whole shebang yet) is accessible directly form the top distro level.
2002-03-12Install executable and man page in package's Makefile directly.wiz1-1/+5
Work-around for pkg/15385.
2002-03-07Remove odd -L${WRKSRC}/libraries junk from openldap libtool archives.jlam1-1/+3
Fixes part of pkg/15794 by Bernd Ernesti <bernd@arresum.inka.de>. This wasn't actually a buildlink problem, but buildlink is flexible enough to provide a solution.
2002-03-07If USE_SASL == YES, then the openldap libraries are linked againstjlam1-1/+5
libsasl.so, so include cyrus-sasl/buildlink.mk to pull in the SASL libraries into ${BUILDLINK_DIR}.
2002-02-28Sort.wiz1-2/+2
2002-02-28Update distribution file checksum for PHP version 4.1.2.tron7-21/+21
2002-02-28Update databases/php4-pgsql to 4.1.2. The only change from version 4.1.1 isjlam1-3/+4
that this is built from the php-4.1.2 sources.
2002-02-28Update databases/php4-odbc to 4.1.2. The only change from version 4.1.1 isjlam1-3/+4
that this is built from the php-4.1.2 sources.
2002-02-28Update databases/php4-mysql to 4.1.2. The only change from version 4.1.1 isjlam1-3/+3
that this is built from the php-4.1.2 sources.
2002-02-28Update databases/php4-ldap to 4.1.2. The only change from version 4.1.1 isjlam1-3/+4
that this is built from the php-4.1.2 sources.
2002-02-28Update databases/php4-filepro to 4.1.2. The only change from version 4.1.1 isjlam1-3/+4
that this is built from the php-4.1.2 sources.
2002-02-28Update databases/php4-dbase to 4.1.2. The only change from version 4.1.1 isjlam1-3/+4
that this is built from the php-4.1.2 sources.
2002-02-28Update databases/php4-dba to 4.1.2. The only change from version 4.1.1 isjlam1-3/+4
that this is built from the php-4.1.2 sources.
2002-02-18Introduce new framework for handling info files generation and installation.seb6-20/+25
Summary of changes: - removal of USE_GTEXINFO - addition of mk/texinfo.mk - inclusion of this file in package Makefiles requiring it - `install-info' substituted by `${INSTALL_INFO}' in PLISTs - tuning of mk/bsd.pkg.mk: removal of USE_GTEXINFO INSTALL_INFO added to PLIST_SUBST `${INSTALL_INFO}' replace `install-info' in target rules print-PLIST target now generate `${INSTALL_INFO}' instead of `install-info' - a couple of new patch files added for a handful of packages - setting of the TEXINFO_OVERRIDE "switch" in packages Makefiles requiring it - devel/cssc marked requiring texinfo 4.0 - a couple of packages Makefiles were tuned with respect of INFO_FILES and makeinfo command usage See -newly added by this commit- section 10.24 of Packages.txt for further information.
2002-02-15mkdir -> ${MKDIR}skrll7-23/+23
rmdir -> ${RMDIR} rm -> ${RM} (${RM} added to PLIST_SUBST) chmod -> ${CHMOD} chown -> ${CHOWN}
2002-02-14Update p5-SQL-Statement to 1.002mjl3-5/+21
Added backwards compatiblity: both SQL::Statement and SQL::Parser now work in perl version 5.004 and above. Changed defaults for DBD::CSV so it now accepts new SQL without adding extra flags to scripts Added support for SQL comments Fixed bugs in qualified column names (e.g. tableA.*), and in joins using ON or WHERE Fixed bug in UPDATE that caused the new value to be a hash rather than a scalar. New features: Explicit and implicit joins Table name aliases Set functions String functions String concatenation Numeric expressions IN predicate BETWEEN predicate Alphabetic comparison in WHERE clauses Ordering of text that looks like a number Verbose error messages for both Parsing and Execution errors Pure perl, new maintainer.
2002-02-14Update p5-DBD-CSV to 0.2001mjl2-5/+5
adjusted docs to show Jeff as the new maintainer. added docs for extended SQL features (joins, etc.) available with SQL::Statement 1.0 and above. adjusted tests blobs.t, chopblanks.t, and ak-dbd.t to work with all versions of SQL::Statement.
2002-02-14Update p5-DBI to 1.21mjl2-6/+6
Fixed DBD::Proxy support for AutoCommit Fixed DBI::ProxyServer bind_param(_inout) handling Fixed DBI::ProxyServer fetch loop Fixed install_driver do-the-right-thing with $@ on error. It, and connect(), will leave $@ empty on success and holding the error message on error. Fixed fetchrow_hashref to assign columns to the hash left-to-right so later fields with the same name overwrite earlier ones as per DBI < 1.15 Changed tables() to use quote_indentifier() if the driver returns a true value for $dbh->get_info(29) # SQL_IDENTIFIER_QUOTE_CHAR Changed ping() so it no longer triggers RaiseError/PrintError. Changed connect() to not call $class->install_driver unless needed. Changed DESTROY to catch fatal exceptions and append to $@. Added ISO SQL/CLI & ODBCv3 data type definitions Removed the definition of SQL_BIGINT data type constant as the value is inconsistent between standards (ODBC=-5, SQL/CLI=25). Added $dbh->column_info(...) Added $dbh->foreign_key_info(...) Added $dbh->quote_identifier(...) Added $h->{HandleError} = sub { ... } addition and/or alternative to RaiseError/PrintError. Added Fowler/Noll/Vo hash type as an option to DBI::hash(). Added DBI::Changes so now you can "perldoc DBI::Changes", yeah! Added selectrow_arrayref & selectrow_hashref docs
2002-02-13Updated openldap to 2.0.23martti3-9/+9
* Fixed slapd moddn acl bug (ITS#1562) (ITS#1582) * Fixed slapd acl regex (to dn="") portability bug (ITS#1579) * Disabled -lldap atexit() handler (ITS#1577) * Updated config.guess/sub scripts (ITS#1567) * Fixed a number of typos (ITS#1578)
2002-02-12Add `-p0' in PATCH_DIST_ARGS to helps Solaris' /usr/bin/gpatch, this doesseb1-3/+3
not seem to harm NetBSD's /usr/bin/patch. Use LIBTOOL_OVERRIDE instead of LTCONFIG_OVERRIDE to fix shared libraries numbering under Solaris.
2002-02-05Solaris' test binary (test/[) doesn't grok "-e". Replace with "-f".jlam1-3/+3
Noted by Stoned Elipot <seb@netbsd.org> in private email.
2002-02-02Update openldap to 2.0.22. Notable changes since version 2.0.21(nb1):kleink2-6/+5
Fixed slapd passwd modify referral bug Fixed back-ldbm index threading bug Fixed back-ldbm ordering presence index bug Fixed back-ldap modify bug (ITS#1547) Fixed -lldap TLS errno bug Fixed ud v2 kind bug Updated slapd slurpd friendly code Build environment Fixed Mach cthreads detection (ITS#1554) Updated Berkeley DB 4 detection
2002-02-01Make this work if openldap doesn't use pthreads.jlam3-18/+17
2002-02-01Add SASL-based user authentication based on if USE_SASL=YES.jlam1-1/+7
2002-01-31Major upgrade of Sqlite from version 2.1.7 to version 2.2.5reinoud2-5/+5
Lots of bug fixes in SQL parsing and supports more weildy SQL code like using the right of an AS in athe column list of a SELECT as part of an expression in the WHERE, ORDER BY, GROUP BY and/of HAVING clauses. For a full report see the changelog on http://www.hwaci.com/sw/sqlite/changes.html
2002-01-31Update databases/openldap to 2.0.21nb1. Changes from version 2.0.21 arejlam4-7/+17
building this package _without_ threads support if the threads are non- native. While the package does build correctly using GNU pth, and the clients run correctly, the slapd server isn't able to pass "make test". When built without threads support, only the replication test fails, I think because slurpd isn't built.
2002-01-30Mapping the files into the web space doesn't work so don't recomment it.tron1-2/+2
2002-01-30Standardize format.wiz1-1/+3
2002-01-30Add a rc.d-style control script for slapd.jlam3-2/+43
2002-01-30Add a message which explains how to use the package properly to avoidtron1-0/+6
things like the one described in PR pkg/15379.
2002-01-29update to 0.9.1, in response to PR pkg/15054 by jgoerzen@complete.orgdrochner4-35/+125
2002-01-28use distutils to build the extension module, to make it work withdrochner4-16/+39
newer Python versions too, XXX we have to override the do-patch rule to avoid patch errors (we use EXTRACT_ELEMENTS, so we don't generally have all the original files)
2002-01-28Note addition of p5-AddressBook.jlam1-1/+2
2002-01-28Initial import of databases/p5-AddressBook:jlam5-0/+96
Perl-AddressBook is a collection of perl library modules which provide a unified interface for accessing addressbook entries stored in various types of databases, e.g. LDAP, LDIF, PalmDB, DBI, text, HTML.
generated by cgit v1.2.3 (git 2.39.1) at 2024-11-27 23:44:26 +0000