summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2012-10-07databases/postgresql(-client): Revert most of last commitmarino4-105/+1
After discussing gcc47 build problems with postgresql developers, it became apparent that the error was unique to DragonFly. It turns out that DragonFly was using an older offsetof macro instead of the builtin version provided by GCC. Fixing the offsetof macro on DragonFly allowed the pre-patched psgsql 91 to build without issue. While the previous patches certainly don't hurt anything, they are being removed to ease future maintenance. The warning suppression fix is still valid, so the change to the pgsql client makefile is being left in place.
2012-10-07Update Jdb to p5-Fsdb 2.26. Jdb was renamed to Fsdb with version 2.12.bad8-92/+53
FSDB is package of commands for manipulating flat-ASCII databases from shell scripts. FSDB is useful to process medium amounts of data (with very little data you'd do it by hand, with megabytes you might want a real database).
2012-10-07databases/postgresql91(-client): Fix build for gcc46 and gcc47marino5-2/+109
Postgresql91 uses non-constant array sizes in record definitions which gcc enforces starting with 4.6. These index sizes are defined as macros using functions such as offsetof. These patches introduce enums where the macros become constant expressions which gcc 4.6+ will accept. GCC 4.7 also introduces the unused-but-set-variable warning which is popping up all over the place in pgsql91, so silence these warnings - they are harmless and get optimized out anyway. No revbump because functionality won't change on binaries generated with gcc4.5 and below.
2012-10-06Changes 3.7.14.1:adam4-14/+14
* Fix a bug that causes a segfault on a LEFT JOIN that includes an OR in the ON clause. * Work around a bug in the optimizer in the VisualStudio-2012 compiler that causes invalid code to be generated when compiling SQLite on ARM. * Fix the TCL interface so that the "nullvalue" setting is honored for TCL implementations of SQL functions.
2012-10-05The PostgreSQL Global Development Group has released an update to all ↵adam3-7/+8
current versions of the PostgreSQL database system, including 9.2.1, 9.1.6, 9.0.10, 8.4.14 and 8.3.21. This update fixes critical issues for major versions 9.1 and 9.2, and users running those versions should apply it as soon as possible. Users of versions 8.3, 8.4 and 9.0 should plan to update at the next scheduled downtime. The update fixes two potential data corruption issues present in the PostgreSQL 9.1 and 9.2 for any server which has crashed, been shutdown with "immediate", or was failed over to a standby. First, the PostgreSQL development team has discovered a chance of corruption of BTREE and GIN indexes for databases. Second, there is a significant chance of corruption of the visibility map. This update fixes both issues. We strongly advise users of 9.1 and 9.2 to run VACUUM and/or index rebuilds after applying the update. Please see the 2012-09-24 Update wiki page for detailed instructions. This update release also contains fixes for many minor issues discovered and patched by the PostgreSQL community in the last month, including many fixes for the newly released version 9.2. These include: fix sorting issue with IN lists and indexes fix planner failure when combining GROUP BY with window functions improve selectivity of text searches using prefixes prevent rescanning of WITH clauses from giving wrong answers fix PL/Perl crashing issue reduce bloat for multi-column GiST indexes time zone data changes for Fiji disallow Extensions from circular schema assignment prevent crashes when default_transaction_isolation is set to "serializable" several minor fixes to pg_upgrade
2012-10-05The PostgreSQL Global Development Group has released an update to all ↵adam15-33/+36
current versions of the PostgreSQL database system, including 9.2.1, 9.1.6, 9.0.10, 8.4.14 and 8.3.21. This update fixes critical issues for major versions 9.1 and 9.2, and users running those versions should apply it as soon as possible. Users of versions 8.3, 8.4 and 9.0 should plan to update at the next scheduled downtime. The update fixes two potential data corruption issues present in the PostgreSQL 9.1 and 9.2 for any server which has crashed, been shutdown with "immediate", or was failed over to a standby. First, the PostgreSQL development team has discovered a chance of corruption of BTREE and GIN indexes for databases. Second, there is a significant chance of corruption of the visibility map. This update fixes both issues. We strongly advise users of 9.1 and 9.2 to run VACUUM and/or index rebuilds after applying the update. Please see the 2012-09-24 Update wiki page for detailed instructions. This update release also contains fixes for many minor issues discovered and patched by the PostgreSQL community in the last month, including many fixes for the newly released version 9.2. These include: fix sorting issue with IN lists and indexes fix planner failure when combining GROUP BY with window functions improve selectivity of text searches using prefixes prevent rescanning of WITH clauses from giving wrong answers fix PL/Perl crashing issue reduce bloat for multi-column GiST indexes time zone data changes for Fiji disallow Extensions from circular schema assignment prevent crashes when default_transaction_isolation is set to "serializable" several minor fixes to pg_upgrade
2012-10-05Added databases/postgresql92 version 9.2.1adam1-1/+16
2012-10-05The PostgreSQL Global Development Group announces PostgreSQL 9.2, the latest ↵adam72-0/+4273
release of the leader in open source databases. Since the beta release was announced in May, developers and vendors have praised it as a leap forward in performance, scalability and flexibility. Users are expected to switch to this version in record numbers. PostgreSQL 9.2 will ship with native JSON support, covering indexes, replication and performance improvements, and many more features. We are eagerly awaiting this release and will make it available in Early Access as soon as it’s released by the PostgreSQL community," said Ines Sombra, Lead Data Engineer, Engine Yard.
2012-10-04Remove unnecessary python restriction (to all supported versions).wiz1-3/+1
2012-10-03Update for python25 removal.wiz2-9/+3
2012-10-03Remove gramps and gramps2 since they only worked with python25.wiz20-2619/+1
2012-10-03Bump all packages that use perl, or depend on a p5-* package, orwiz126-210/+252
are called p5-*. I hope that's all of them.
2012-10-03Add BUILDLINK_LIBDIRS to mysql55-* too, to help out packages likefhajny2-2/+4
net/powerdns-mysql.
2012-10-02Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.asau324-930/+324
2012-10-02Mass recursive bump after the dependence fix of the "cairo" packagetron15-30/+30
requested by Thomas Klausner.
2012-10-01Changes 5.5.28:adam12-46/+48
The internal interface of the Thread Pool plugin has changed. Old versions of the plugin will work with current versions of the server, but versions of the server older than 5.5.28 will not work with current versions of the plugin. Bugs Fixed InnoDB: Certain information_schema tables originally introduced in MySQL 5.6 are now also available in MySQL 5.5 and MySQL 5.1: INNODB_BUFFER_PAGE, INNODB_BUFFER_PAGE_LRU, and INNODB_BUFFER_POOL_STATS. InnoDB: When a SELECT ... FOR UPDATE, UPDATE, or other SQL statement scanned rows in an InnoDB table using a < or <= operator in a WHERE clause, the next row after the affected range could also be locked. This issue could cause a lock wait timeout for a row that was not expected to be locked. The issue occurred under various isolation levels, such as READ COMMITTED and REPEATABLE READ. Partitioning: For tables using PARTITION BY HASH or PARTITION BY KEY, when the partition pruning mechanism encountered a multi-range list or inequality using a column from the partitioning key, it continued with the next partitioning column and tried to use it for pruning, even if the previous column could not be used. This caused partitions which possibly matched one or more of the previous partitioning columns to be pruned away, leaving partitions that matched only the last column of the partitioning key. This issue was triggered when both of the following conditions were met: The columns making up the table's partitioning key were used in the same order as in the partitioning key definition by a SELECT statement's WHERE clause as in the column definitions; The WHERE condition used with the last column of the partitioning key was satisfied only by a single value, while the condition testing some previous column from the partitioning key was satisfied by a range of values. An example of a statement creating a partitioned table and a query against this for which the issue described above occurred is shown here: CREATE TABLE t1 ( c1 INT, c2 INT, PRIMARY KEY(c2, c1) ) PARTITION BY KEY() # Use primary key as partitioning key PARTITIONS 2; SELECT * FROM t1 WHERE c2 = 2 AND c1 <> 2; This issue is resolved by ensuring that partition pruning skips any remaining partitioning key columns once a partition key column that cannot be used in pruning is encountered. Partitioning: The buffer for the row currently read from each partition used for sorted reads was allocated on open and freed only when the partitioning handler was closed or destroyed. For SELECT statements on tables with many partitions and large rows, this could cause the server to use excessive amounts of memory. This issue has been addressed by allocating buffers for reads from partitioned tables only when they are needed and freeing them immediately once they are no longer needed. As part of this fix, memory is now allocated for reading from rows only in partitions that have not been pruned (see Section 18.4, “Partition Pruning”). Replication: On 64-bit Windows platforms, values greater than 4G for the max_binlog_cache_size and max_binlog_stmt_cache_size system variables were truncated to 4G. This caused LOAD DATA INFILE to fail when trying to load a file larger than 4G in size, even when max_binlog_cache_size was set to a value greater than this. Replication: In master-master replication with --log-slave-updates enabled, setting a user variable and then performing inserts using this variable caused the Exec_master_log_position column in the output of SHOW SLAVE STATUS not to be updated. The RPM spec file now also runs the test suite on the new binaries, before packaging them. The libmysqlclient_r client library exported symbols from yaSSL that conflict with OpenSSL. If a program linked against that library and libcurl, it could crash with a segmentation fault. The argument for LIMIT must be an integer, but if the argument was given by a placeholder in a prepared statement, the server did not reject noninteger values such as '5'. The Thread Pool plugin did not respect the wait_timeout timeout for client sessions. CHECK TABLE and REPAIR TABLE could crash if a key definition differed in the .frm and .MYI files of a MyISAM table. Now the server produces an error. A query for a FEDERATED table could return incorrect results when the underlying table had a compound index on two columns and the query included an AND condition on the columns. mysqlhotcopy failed for databases containing views. The argument to the --ssl-key option was not verified to exist and be a valid key. The resulting connection used SSL, but the key was not used. Adding a LIMIT clause to a query containing GROUP BY and ORDER BY could cause the optimizer to choose an incorrect index for processing the query, and return more rows than required. mysqlbinlog did not accept input on the standard input when the standard input was a pipe.
2012-09-28- fix openldap-smbk5pwd so that it links with -ldes on NetBSDmanu4-7/+10
(otherwise Undefined PLT symbol "des_set_odd_parity") - make sure OpenLDAP links with pkgsrc's libfetch as base libfetch may be linked with a different OpenSSL than OpenLDAP.
2012-09-28Fix build with tcl 8.5.dholland2-1/+58
2012-09-17Corrected Makefile to build only HTML documentation.jaapb4-47/+2
Removed superfluous patches.
2012-09-17Add missing pkg-config tool.wiz1-2/+2
2012-09-17Update databases/couchdb to 1.2.0.fhajny6-47/+63
Changes in 1.2.0 * Updated bundled erlang_oauth library to the latest version. * cURL is no longer required to build CouchDB as it is only required by the command line JS test runner. * Added a native JSON parser. * Optional file compression (database and view index files). This feature is enabled by default. * Several performance improvements, especially regarding database writes and view indexing. * Added a 'data_size' property to database and view group information URIs. * Added support for automatic compaction. This feature is disabled by default, but it can be enabled via the .ini configuration. * A new replicator implementation that offers more performance and configuration options. * Added optional field 'since_seq' to replication objects/documents. * Simpler replication cancelation. * The _active_tasks API now exposes more granular fields for each task type. * Futon's 'Status' screen (active tasks) now displays two new task status fields: 'Started on' and 'Updated on'. * Added built-in changes feed filter '_view'. * Fixed old index file descriptor leaks after a view cleanup. * Performance improvements for the built-in changes feed filters '_doc_ids' and '_design'. * Fixes to the '_changes' feed heartbeat option when combined with a filter. It affected continuous pull replications with a filter. * Fix use of OAuth with VHosts and URL rewriting. * OAuth secrets can now be stored in the users system database. * Documents in the _users database can no longer be read by everyone. * Confidential information in the _replication database can no longer be read by everyone. * Password hashes are now calculated by CouchDB instead of the client. * Allow persistent authentication cookies. * The requested_path property of query server request objects now has the path requested by clients before VHosts and rewriting. * Fixed incorrect reduce query results when using pagination parameters. * Made icu_driver work with Erlang R15B and later. * Improvements to the build system and etap test suite. * Avoid invalidating view indexes when running out of file descriptors. * Log correct stacktrace in all cases. * Improvements to log messages for file-related errors.
2012-09-16Updated version to 1.1.1. Changes:jaapb4-17/+41
* Sat May 19 2012 (1.1.1) * Support build with ocaml/msvc and ocaml/mingw (Dmitry Grebeniuk) * Update build tools (Dmitry Grebeniuk) * OCaml 3.12 compatibility * Mysql.Prepared: documentation comments * Mysql.Prepared.result_metadata (Hezekiah M. Carty) * Mysql.quick_connect: optional unix socket path * Mysql.quick_connect: optional connection options * Sat Dec 26 2009 (1.1.0) * Project moved to http://ocaml-mysql.forge.ocamlcore.org * Fix crash bugs (mainly in GC & threads interaction) * Trigger GC less often (Mysql.connect and Mysql.execute) * Mysql.real_escape (Debian patch) * Mysql.set_charset * Preliminary support for prepared statements (Mysql.Prepared) Changes to the package: changed maintainer from pkgsrc-users to myself; incorporated upstream move to other address; added license; added native code build.
2012-09-16Updated databases/ocaml-sqlite3 to version 2.0.2. Summary of changes:jaapb8-102/+53
2012-07-20: Downgraded findlib version requirement to support the Debian testing branch. 2012-07-16: Replaced String.trim function in myocamlbuild.ml to allow compiling with OCaml 3.12.1. 2012-07-15: New major release version 2.0.0: * Upgraded to OCaml 4.00 * Switched to Oasis for packaging * Switched to OCamlBuild for the build process * Rewrote README in Markdown * Added stricter compilation flags 2012-05-19: Fixed cpp warnings and removed superfluous check for dynamic linking library. The latter improves portability to FreeBSD. 2011-03-10: Added sqlite3_open_v2 functionality. There are also some changes to the package itself: the upstream distribution site changed; the maintainer e-mail address as well, and the package now uses PLIST_VARS.
2012-09-16Update ruby-dm-types to 1.2.2.taca3-16/+14
Changes are unavailable but it looks like some dependency relaxed.
2012-09-16Update ruby-dm-serializer to 1.2.2.taca3-11/+12
Changes are unavailable but it looks like some dependency relaxed.
2012-09-15Recursive bump from mysql51-client library changed to use openssl.obache18-28/+36
2012-09-15Update mysql51 to 5.1.65.obache5-22/+22
While here, let to use OpenSSL instead of internal yaSSL with ssl option, may related to PR 46912. Changes in MySQL 5.1.65 (2012-08-09) Functionality Added or Changed * Important Change: The YEAR(2) data type is now deprecated because it is problematic. Support for YEAR(2) will be removed in a future release of MySQL. For more information, see Section 11.3.4, "YEAR(2) Limitations and Migrating to YEAR(4)". Bugs Fixed * The server did not build with gcc 4.7. (Bug #14238406) Changes in MySQL 5.1.64 (Not released) Functionality Added or Changed * Important Change: Replication: The SHOW BINARY LOGS statement (and its equivalent SHOW MASTER LOGS) may now be executed by a user with the REPLICATION CLIENT privilege. (Formerly, the SUPER privilege was necessary to use either form of this statement.)
2012-09-15It is impossible to buildlink mysql-server-5.0 together with mysql-client-5.1.obache1-2/+2
2012-09-15recursive bump from libffi shlib major bumpobache23-45/+46
(additionaly, reset PKGREVISION of qt4-* sub packages from base qt4 update)
2012-09-15revert accidental incomplete update with revbump after updating graphics/cairo.obache10-41/+48
then, just bump PKGREVISION to 11.
2012-09-13Update to 3.4.1:wiz4-54/+183
2012-08-23 Version 3.4.1 -- The "A tiger? In Africa?!" bug fix release. Mention in the release that upgrading is advised for two critical issues: -> error in export to xml of family order in 3.4.0, now fixed -> crash in windows after some use due to too much terminal output in 3.4.0, now fixed * Some platform-specific fixes (Windows, OSX) * Bug fixes * Translation updates * Changelog: http://www.gramps-project.org/bugs/changelog_page.php?version_id=31 2012-05-21 Version 3.4.0 -- The "always look on the bright side of life" feature release. * Lots of changes and bug fixes to every part of Gramps, including XML import/export, image handling, gedom handling, Gramplets, date handling, citations, reports, more! * Some platform-specific fixes (Windows, OSX, Linux) * What's new (and what to do before you upgrade): http://goo.gl/K3RDV * Roadmap: http://goo.gl/GJhjH * Many translation updates
2012-09-11Updating package for CPAN module ORLite::Migrate insno2-6/+6
databases/p5-ORLite-Migrate from 1.09 to 1.10. upstream changes: 1.10 Thu 2 Feb 2012 - Providing a timeline value implies create if undefined
2012-09-11Updating package for CPAN module ORLite in databases/p5-ORLite from 1.51nb1sno2-10/+8
to 1.97. pkgsrc changes: - fix dependencies upstream changes: 1.97 Mon 21 May 2012 - Use reproducible longdouble in tests (HMBRAND) 1.96 Mon 27 Feb 2012 - Fixed a crash in the legacy delete emulation where the condition clause provided was a constant or read-only. 1.95 Mon 27 Feb 2012 - Fixed a fatal rowid big when generating in array mode 1.94 Mon 27 Feb 2012 - Fixed a fatal rowid bug when a table had a single non-INTEGER primary key. - Fixed bug in affinity detection code to now set REAL and NUMERIC affinity correctly. 1.93 Mon 27 Feb 2012 - The previous release 1.92 was done with a missing commit, this release restores that missing code. 1.92 Mon 27 Feb 2012 - Add the ->delete_where method for bulk deletion - Always do the initial metadata scan using ReadOnly => 1. - When generating readonly, DBI connections use ReadOnly => 1 too. - Quote identifiers more correctly via $dbh->quote_identifier. - Temporarily restory the static delete call to prevent breaking Padre and other applications still using the old version of delete. 1.91 Thu 23 Feb 2012 - Calculate column affinity types in the metadata preparation phase - Throw an exception when tables contain BLOB types and the database is unicode, as the blob data will be corrupted. - Improved testing for blobs and unicode, and TODO a known problem 1.90 Tue 21 Feb 2012 - Removed x_rowid parameter and make the rowid logic compulsory. - Removed x_update parameter and make update method compulsory at the table level but do not generate on the root level. - As a result, ORLite now supports creating and updating objects even when they come from tables without primary keys. - Pending release as 2.00 once clarifying documentation is written. 1.54 Tue 21 Feb 2012 - Added experimental x_rowid parameter to maintain SQLite rowids in the objects 1.53 Tue 21 Feb 2012 - Add a ->id convenience method alias when table 'foo' has a single numeric primary key 'foo_id' so you can use $foo->id 1.52 Sat 21 Jan 2012 - Added initial unicode => 1 support (MEMOWE) - Bumped Params::Util dependency to 1.0 for *LIKE fixes (ADAMK)
2012-09-10Updating package for CPAN module DBIx::Class::Schema::Loader insno2-6/+6
databases/p5-DBIx-Class-Schema-Loader from 0.07031 to 0.07033. upstream changes: 0.07033 2012-09-09 16:11:47 - more thoroughly document the new behavior for relationship attributes under "relationship_attrs" in ::Base POD - add a loud WARNING to Makefile.PL about the new behavior for relationship attributes 0.07032 2012-09-09 13:17:20 - SQLite: detect is_deferrable for inline FKs - support coderefs for relationship_attrs
2012-09-10Updating package for CPAN module DBIx::Class in databases/p5-DBIx-Classsno2-15/+18
from 0.08196 to 0.08200. pkgsrc changes: - update and adjust dependencies upstream changes: 0.08200 2012-08-24 (UTC) * Fixes - Change one of the new tests for the previous release to not require SQL::Translator 0.08199 2012-08-22 (UTC) same as devrel 0.08198_01 2012-07-25 (UTC) * Fixes - Roll back incomplete (and broken) internal changes - restore prefetch functionality 0.08198 2012-07-11 03:43 (UTC) * Fixes - Fix a number of Win32 Test issues - Fix silent Oracle connection failures 0.08197 2012-07-10 10:32 (UTC) * New Features / Changes - Issue a warning when DateTime objects are passed to ->search - Fast populate() in void context is now even more efficient by going directly through execute_for_fetch bypassing execute_array - Fix update()/delete() on complex resultsets to no longer fall back to silly row-by-row deletion, construct a massive OR statement instead - Allow complex update/delete operations on sources without a primary key, as long as they have at least one non-nullable unique constraint - dbicadmin now better supports catalyst-style config files, by unrolling 'config_info' hashkeys - Multiple Improvements MSSQL over DBD::ADO - Transaction support - Support for VARCHAR(MAX)/VARBINARY(MAX)/NVARCHAR(MAX) datatypes - Nomalization of retrieved GUID values * Fixes - Fix complex has_many prefetch with resultsets not selecting identity columns from the root result source - Fix SkipFirst and FirstSkip limit dialects (Informix and Firebird) - Fix "Skimming limit" dialects (Top, FetchFirst) to properly check the order_by criteria for stability - Fix "Skimming limit" dialects (Top, FetchFirst) to propagate non-selected order criteria when part of a larger subquery - Fix RowNumberOver and all "skimming limits" to correctly assemble bind values when supplied for both select and order_by - Fix all subquery-based dialects to not lose a subquery fragment when we both select and order by the result of the same subquery - Fix the Sybase hubrid limit dialect (RowCountOrGenericSubQ) losing Group/Having/Order clauses when called without an offset (RT#73244) - No longer generate incorrect SQL on ->as_query called on resultsets with software_limit enabled - A number of corner case fixes of void context populate() with \[] - Fix corner case of forked children disconnecting the parents DBI handle - Improve identity/autoinc retrieval code in MSSQL and Sybase - should reduce weird side-effects especially with populate() - Explicitly disable DBD::ODBC batch operations (as of DBD::ODBC 1.35) for the following drivers too buggy to handle the optimized path: - FreeTDS ODBC driver (when used with MSSQL) - The Firebird ODBC driver - The MSAccess ODBC driver - Explicitly disable DBD::ODBC dynamic_cursors when using freetds 0.83 or later - they made enough ODBC incompatible changes making it impossible to support sanely - Explicitly disable SCOPE_IDENTITY queries and statement caching for MSSQL on DBD::Sybase compiled against freetds 0.83 or later - way too buggy - Disable statement caching when using Sybase ASE and DBD::Sybase compiled against freetds 0.83 or later - Fix leakage of $schema on in-memory new_related() calls - Fix more cases of $schema leakage in SQLT::Parser::DBIC - Fix leakage of $storage in ::Storage::DBI::Oracle - Fix pessimization of Oracle RowNum limit dialect query when no offset has been specified - Remove useless vestigial pessimization in Ordered.pm for cases when the position column is part of a unique constraint - Fix dbicadmin to no longer ignore the documented 'config' option - The schema-resultsource entanglement is now much more robust under threads - Fix ::Schema::ddl_filename() failing miserably on paths containing certain numeric sequences - t/53lean_startup.t adjusted for new 5.15.x base.pm behavior * Misc - Centralized leak-checks for all instances of DBICTest::Schema from within any test - Now passes all tests with Test::Builder 1.005 - Codebase is now trailing-whitespace-free - Cleanup of complex resultset update/delete oprations - storage specific code moved back to ResultSet and replaced by checks of storage capabilities - Fixed carp_once only emitting one single warning per package regardless of warning content - Test suite now can be safely executed in parallel (prove -jN or HARNESS_OPTIONS=jN)
2012-09-10Updating package for CPAN module SQL::Abstract in databases/p5-SQL-Abstractsno2-9/+8
from 1.72nb1 to 1.73. pkgsrc changes: - update dependencies upstream changes: revision 1.73 2012-07-10 ---------------------------- - Fix parsing of ORDER BY foo + ? - Stop filling in placeholders in `format-sql` since it does not support passing values for them anyway - Fix parsing of NOT EXISTS - Fix over-eager parenthesis unrolling - Fix deep recursion warnings while parsing obnoxiously long sql statements - Fix incorrect comparison of malformed lists - Fix incorrect reporting of mismatch-members in SQLA::Test - Migrate the -ident operator from DBIC into SQLA - Migrate the -value operator from DBIC into SQLA
2012-09-07Revbump after updating graphics/cairoadam24-76/+69
2012-09-07Updating package for CPAN module DBD::CSV in databases/p5-DBD-CSV fromsno2-7/+7
0.35 to 0.36. pkgsrc changes: - bump required version of textproc/p5-Text-CSV_XS Upstream changes: 0.36 - 2012-08-22, H.Merijn Brand * Add line/record number and position in error messages
2012-09-07Updating package for CPAN module DBIx::Class::Schema::Loader insno2-16/+19
databases/p5-DBIx-Class-Schema-Loader from 0.07012 to 0.07031. pkgsrc changes: - adjusting dependencies according to distribution's meta information Upstream changes since 0.07012: 0.07031 2012-09-06 15:07:08 - fix 02pod.t failure due to lack of =encoding utf8 statement (patch by Marcel Gruenauer) (RT#79481) 0.07030 2012-09-06 03:27:09 - allow user to set qualify_objects=0 in multischema configurations (andrewalker) 0.07029 2012-09-05 16:41:56 - Oracle: introspect ON DELETE and DEFERRABLE FK clauses - Oracle WARNING: on_delete is now 'NO ACTION' by default, not 'CASCADE'. on_update is now 'NO ACTION' by default (Oracle does not have update rules, this was done to preserve the behavior of the schema when cross-deploying to SQLite.) is_deferrable is now 0 by default, not 1. - DB2: introspect ON DELETE/UPDATE FK clauses - DB2 WARNING: the default for on_delete/on_update is now 'NO ACTION' not 'CASCADE', the default for is_deferrable is still 1 because DB2 does not have deferrable constraints. - SQLite: introspect ON DELETE/UPDATE and DEFERRABLE FK clauses - SQLite WARNING: the default for on_delete/on_update is now 'NO ACTION' not 'CASCADE', and the default for is_deferrable is now 0 not 1. 0.07028 2012-08-30 05:32:42 - MSSQL: introspect ON DELETE/UPDATE clauses for foreign keys - MSSQL WARNING: the default for on_delete/on_update is now 'NO ACTION' not 'CASCADE'. 0.07027 2012-08-26 22:39:45 - PostgreSQL: introspect ON DELETE/UPDATE clauses for foreign keys and the DEFERRABLE clause. - PostgreSQL WARNING: the default for on_delete/on_update attributes for belongs_to relationships is now 'NO ACTION' not 'CASCADE! The default for is_deferrable is now 0 not 1. 0.07026 2012-08-26 01:01:26 - MySQL: introspect ON DELETE/UPDATE clauses for foreign keys. - MySQL WARNING: the default on_delete/on_update attributes for belongs_to relationships is now RESTRICT, *NOT* CASCADE! This is overridable via the relationship_attrs option. 0.07025 2012-06-08 22:48:05 - support SQL Server 2000 again (broken in 0.07011) - some slight optimization for SQL Server driver 0.07024 2012-05-08 15:35:16 - work around broken keyseq in DBD::Pg foreign_key_info (RT#77062) 0.07023 2012-05-05 11:44:15 - properly order FK columns when using base ::DBI loader (SineSwiper) - bump Class::Inspector dep to 1.27 due to test failures with earlier versions on perl >= 5.15.7 (RT#74236) 0.07022 2012-04-08 12:11:00 - do separate queries for default_value on Sybase ASE as some servers can't join to that table (pcmantz) (RT#74170) - set correct size for nchar/nvarchar columns for Sybase ASE, depending on @@ncharsize 0.07021 2012-04-04 23:47:34 - use ::Schema::connect instead of ::Schema::connection in make_schema_at (RT#74175) - register sources on the schema class, never the instance, regardless of how the connection is made for dynamic schemas 0.07020 2012-03-31 21:34:06 - fix some mro issues under perl 5.8 0.07019 2012-03-28 17:23:09 - fix some errors due to case issues (RT#75805) 0.07018 2012-03-27 05:55:10 - skip dbicdump tests on Win32 due to test fails (RT#75732) - fix undefined warnings for DBDs without schemas - work around ORA-24345 from $dbh->column_info - fix spelling mistake in Base POD (RT#74796) 0.07017 2012-02-07 07:23:48 - *EXPERIMENTAL* support for dumping PostgreSQL schemas inside of a transaction - use DBI table_info/column_info REMARKS field if/where available for table/column comments (SineSwiper) - better compatibility with more DBDs (SineSwiper) 0.07015 2011-12-09 10:36:17 - generate many_to_many bridges for targets of link tables 0.07014 2011-11-18 17:06:34 - fix a bug in the automatic multischema clashing moniker disambiguation code that overwrote $loader->moniker_parts 0.07013 2011-11-17 23:12:47 - automatically prefix database/schema to clashing monikers for the same table name in multischema configurations
2012-09-06Changes 3.7.14:adam7-23/+24
* Drop built-in support for OS/2. If you need to upgrade an OS/2 application to use this or a later version of SQLite, then add an application-defined VFS using the sqlite3_vfs_register() interface. The code removed in this release can serve as a baseline for the application-defined VFS. * Ensure that floating point values are preserved exactly when reconstructing a database from the output of the ".dump" command of the command-line shell. * Added the sqlite3_close_v2() interface. * Updated the command-line shell so that it can be built using SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT. * Improvements to the windows makefiles and build processes. * Enhancements to PRAGMA integrity_check and PRAGMA quick_check so that they can optionally check just a single attached database instead of all attached databases. * Enhancements to WAL mode processing that ensure that at least one valid read-mark is available at all times, so that read-only processes can always read the database. * Performance enhancements in the sorter used by ORDER BY and CREATE INDEX. * Added the SQLITE_DISABLE_FTS4_DEFERRED compile-time option. * Better handling of aggregate queries where the aggregate functions are contained within subqueries. * Enhance the query planner so that it will try to use a covering index on queries that make use of or optimization.
2012-09-03Update ruby-sequel to 3.39.0.taca3-7/+12
=== 3.39.0 (2012-09-01) * Fix defaults_setter to set false default values (jeremyevans) * Fix serial sequence query in Database#primary_key_sequence on PostgreSQL (jeremyevans) (#538) * Add Database#copy_into when using postgres adapter with pg driver, for very fast inserts into tables (jeremyevans) * Combine multiple alter_table operations into a single query where possible on MySQL and PostgreSQL (jeremyevans) * Handle sets of alter_table operations on MySQL and MSSQL where later operations depend on earlier ones (jeremyevans) * Add constraint_validations plugin for automatic validations of constaints defined by extension (jeremyevans) * Add constraint_validations extension for defining database constraints similar to validations (jeremyevans) * Add Database#supports_regexp? for checking for regular expression support (jeremyevans) * Add Sequel.trim for cross platform trim function (jeremyevans) * Add Sequel.char_length for cross platform char_length function (jeremyevans) * Fixing caching of MySQL server version (hannesg) (#536) * Allow overriding the convert_tinyint_to_bool setting on a per-Dataset basis in the mysql and mysql2 adapters (jeremyevans) * Make ValidationFailed and HookFailed exceptions have model method that returns the related model (jeremyevans) * Automatically wrap array arguments to most PGArrayOp methods in PGArrays (jeremyevans) * Add set_column_not_null to alter table generator for marking a column as not null (jeremyevans) * Default second argument of set_column_allow_null to true in alter table generator (jeremyevans) * Allow Dataset#count to take an argument or virtual row block (jeremyevans) * Attempt to recognize CURRENT_{DATE,TIMESTAMP} defaults and return them as Sequel::CURRENT_{DATE,TIMESTAMP} (jeremyevans) * Make dataset.insert(model) assume a single column if model uses the pg_row plugin (jeremyevans) * No longer handle model instances in plain (non-model) datasets when inserting (jeremyevans) * Use subselects for model classes as tables in join methods in model datasets if the model's dataset isn't a simple select (jeremyevans) * No longer handle model classes as tables in join/graph methods in plain (non-model) datasets (jeremyevans) * Make Time->DateTime and DateTime->Time typecasts retain fractional seconds on ruby 1.8 (jeremyevans) (#531) * Add bin/sequel -c support, for running code string instead of using an IRB prompt (jeremyevans) * Allow subclasses plugin to take a block, which is called with each subclasses created (jeremyevans) * Add :where option to validates_unique, for custom uniqueness filters (jeremyevans) * Add :connection_handling=>:disconnect option for threaded connection pools (jeremyevans) * Add Postgres::PGRowOp#* for referencing the members of the composite type as separate columns (jeremyevans) * Make identity_map plugin work with models lacking a primary key (jeremyevans) * Recognize MySQL set type and default value (jeremyevans) (#529)
2012-09-03Update ruby-pg to 0.14.1.taca2-7/+6
== v0.14.1 [2012-09-02] Michael Granger <ged@FaerieMUD.org> Important bugfix: - Fix stack overflow bug in PG::Result#values and #column_values (#135). Thanks to everyone who reported the bug, and Lars Kanis especially for figuring out the problem. PostgreSQL 9.2 beta fixes: - Recognize PGRES_SINGLE_TUPLE as OK when checking PGresult (Jeremy Evans) Documentation fixes: - Add note about the usage scope of the result object received by the #set_notice_receiver block. (Lars Kanis) - Add PGRES_COPY_BOTH to documentation of PG::Result#result_status. (Lars Kanis) - Add some documentation to PG::Result#fnumber (fix for #139)
2012-09-03Update ruby-cassandra to 0.15.0.taca3-12/+22
v0.15.0 - Fixes for ruby 1.8 (issue #158, courtesy @jarib) - get_indexed_slices returns an OrderedHash (issue #110) v0.14.0 - Numerous performance improvements (courtesy @nearbuy) - Fixed many 0.6 bugs - Added batch counter update support to Cassandra::Mock - Add support DynamicComposite columns (issue #154, courtesy @nearbuy) - API cleanup in get_indexed_slices (issue #155, courtesy @mcmire)
2012-09-03Update ruby-activeldap to 3.2.2.taca3-12/+27
Now this package supports Ruby on Rails 3.2. 3.2.2: 2012-09-01 * Supported entry creation by direct ActiveLdap::Base use. [Reported by Craig White] * Started to use Travis CI. 3.2.1: 2012-08-31 * Fixed a bug that ActiveLdap::Base#delete doesn't work. [Reported by Craig White] 3.2.0: 2012-08-29 * [GitHub:#39] Supported Rails 3.2.8. [Reported by Ben Langfeld] * [GitHub:#13] Don't use deprecated Gem.available?. [Patch by sailesh] * [GitHub:#19] Supported new entry by @ha_many :wrap@. [Patch by Alex Tomlins] * Supported @:only@ option in XML output. * [GitHub:#14] Supported nil as single value. [Reported by n3llyb0y] * [GitHub:#20] Supported ActiveModel::MassAssignmentSecurity. [Reported by mihu] * [GitHub:#24] Supported Ruby 1.9 style Hash syntax in generator. [Patch by ursm] * [GitHub:#25][GitHub:#39] Supported ActiveModel::Dirty. [Patch by mihu][Reported by Ben Langfeld] * [GitHub:#26] Improved speed for dirty. [Patch by mihu] * [GitHub:#28] Improved speed for initialization. [Patch by mihu] * [GitHub:#29] Added .gemspec. [Suggested by mklappstuhl] * [GitHub:#34] Removed an unused method. [Patch by mihu] * [GitHub:#37] Improved will_paginate support. [Patch by Craig White] * [GitHub:#40] Added missing test files to .gemspec. [Reported by Vt Ondruch] * [GitHub:#41] Improved speed for find. [Patch by unixmechanic] * Changed i18n backend to gettext from fast_gettext again. * [GitHub:#42] Fixed a bug that optional second is required for GeneralizedTime. [Reported by masche842]
2012-09-03Changing all PERL5_MODULE_TYPE from Module::Install to M::I::Bundled,sno11-26/+33
Module::Install is for Authors only. Bumping revision
2012-09-01databases/ocaml-sqlite3: Fix build for DragonFlymarino2-5/+6
Redefining __unused will break the build, so don't do it.
2012-08-31Update to 1.03wen2-9/+7
Upstream changes: 1.03 Sun Mar 6 07:32:21 CET 2011 Fixing output of tests when DBI is not available. 1.02 Thu Mar 3 20:40:54 CET 2011 Added the URL to the AVAILABLE FROM sections. 1.01 Wed Feb 9 21:22:07 CET 2011 Updated the Changes file. 1.00 Wed Feb 9 21:19:35 CET 2011 Changed the location of the distribution to http://www.adelton.com/perl/DBD-XBase/ Changed author's email address. Require perl 5.10 and use O_BINARY from Fcntl. Updated the clean target to make distclean clean. Updated URL of Erik's documentation.
2012-08-29Update checksum of patch-libraries_vendor_config.php for previous commit.dholland1-2/+2
2012-08-29Update ruby-sequel to 3.38.0.taca3-8/+18
=== 3.38.0 (2012-08-01) * Sequel now recognizes the double(x, y) and double(x, y) unsigned MySQL types (Slike9, jeremyevans) (#528) * The swift subadapters now require swift-db-* instead of swift itself (deepfryed, jeremyevans) (#526) * Add :textsize option to tinytds adapter to override the default TEXTSIZE (jeremyevans, wardrop) (#525) * Support an output identifier method in the swift adapter (jeremyevans) * Add Model#to_hash as an alias to Model#values (jeremyevans) * When loading multiple pg_* extensions via Database#extension, only reset the conversion procs once (jeremyevans) * Don't allow model typecasting from string to postgres array, hstore, or composite types (jeremyevans) * Add pg_typecast_on_load plugin for converting advanced PostgreSQL types on load the {jdbc,do,swift}/postgres adapters (jeremyevans) * Make all adapters that connect to PostgreSQL store type conversion procs (jeremyevans) * Add type oid to column schema on PostgreSQL (jeremyevans) * Add pg_row plugin, for using Sequel::Model classes to represent PostgreSQL row-valued/composite types (jeremyevans) * Add pg_row_ops extension for DSL support for PostgreSQL row-valued/composite types (jeremyevans) * Add pg_row extension for dealing with PostgreSQL row-valued/composite types (jeremyevans) * Allow custom registered array types in the pg_array extension to be Database instance specific (jeremyevans) * Remove Sequel::SQL::IdentifierMethods (jeremyevans) * Don't have the schema_dumper extension produce code that relies on the core_extensions (jeremyevans) * Fix dropping of columns with constraints on Microsoft SQL Server (mluu, jeremyevans) (#515, #518) * Don't have pg_* extensions add methods to core classes unless the core_extensions extension is loaded (jeremyevans) * Use real boolean literals on derby 10.7+ (jeremyevans, matthauck) (#514) * Work around JRuby 1.6 ruby 1.9 mode bug in Time#nsec for Time prepared statement arguments on jdbc (jeremyevans) * Handle blob prepared statement arguments on jdbc/db2 and jdbc/oracle (jeremyevans) * Handle blob values in the swift adapter (jeremyevans) * Handle better nil prepared statement arguments on jdbc (jeremyevans) (#513) * Make SQL::Blob objects handle as, cast, and lit methods even if the core extensions are not loaded (jeremyevans) * Make #* with no arguments produce a ColumnAll for Identifier and QualifiedIdentifier (jeremyevans) * Sequel.expr(:symbol) now returns Identifier, QualifiedIdentifier, or AliasedExpression instead of Wrapper (jeremyevans) * Treat clob columns as string instead of blob on Derby (jeremyevans) (#509)
2012-08-29databases/postgresql84-tcl: Fix PLIST, 8.4.13 adds Russianmarino2-2/+4