summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2011-01-20Dont assume libc has a strlcpy() if the heimdal libraries happen to havemarkd2-3/+16
one and expose it.
2011-01-20Changes 2.3.2:adam3-7/+70
* Fixed segfault with middleware not passing DateStyle to the client Changes 2.3.1: * Fixed build problem on CentOS 5.5 x86_64 Changes 2.3.0: psycopg 2.3 aims to expose some new features introduced in PostgreSQL 9.0. * Main new features: - `dict` to `hstore` adapter and `hstore` to `dict` typecaster, using both 9.0 and pre-9.0 syntax. - Two-phase commit protocol support as per DBAPI specification. - Support for payload in notifications received from the backed. - `namedtuple`-returning cursor. - Query execution cancel.
2011-01-18added libraries required to build on Solarisschwarz1-1/+3
2011-01-15Update ruby-odbc package to 0.99994.taca3-10/+10
Sat Jan 15 2011 version 0.99994 released * fixed column key caching, thanks Sean Noonan for bug report Fri Dec 24 2010 version 0.99993 released * fixed error reporting in Database.transaction method, thanks Shane Emmons for bug report and testing
2011-01-13png shlib name changed for png>=1.5.0, so bump PKGREVISIONs.wiz1-2/+2
2011-01-13png shlib name changed for png>=1.5.0, so bump PKGREVISIONs.wiz19-36/+38
2011-01-10For PostgreSQL before 9.0, pg_ctl doesn't know 'init'; revert to initdb.adam2-4/+8
2011-01-05Update to 1.4.5kefren3-14/+13
Bugfixes: * rrdcached: print \n at the end of log messages when running rrdcached in the foreground -- Bernard Li * rrdcached: Let the -s, -m and -P options affect the default socket as well -- Sebastian Harl * rrdgraph: font related memory leaks fixed #208 -- tobi * rrdgraph-libdbi: print error message instead of dumping core on sql problem -- Pavel Nikiforov * rrdgraph-libdbi: properly allocated response buffer -- Pavel Nikiforov * rrdtool: in remote mode, make argument count for remote commmands strict -- Dave Peticolas * rrdgraph: fix problems with second %s in right-axis format -- tobi * and many more: for full changelog http://oss.oetiker.ch/rrdtool/pub/CHANGES Enhancements: * rrdcached: add hosts_access support added -- Shaun Reitan * rrdfetch/graph: introduce "epoch" as a new base time reference, meaning timestamp 0: you can now write epoch+11111111s or epoch+19711205s -- Peter Stamfest
2010-12-30treat DragonFly shlib handling same as NetBSD.obache2-1/+17
2010-12-25Changes 09.00.0200:adam8-306/+59
* Fix a bug about sizeof() at idx_fake_oid of info. * Return 0 for the column size when the size of numeric items are unknown. Also improve the calculation of scale of numeric items when it is not explicitly specified. * Change to use 'if' instead of an inappropriate 'else if' at cursor of convert. * Remember to set permanent flag to holdable cursors on commit with no precedent rollback (to savepoint) operations. This fixes a crash bug in case of cursor operations across transaction. * Fix a bug about the handling of the SQL_RETRIEVE_DATA option. * Fix cursor bug introduced by the previous change. * Move the setting of folder name of libpq or gssapi related dlls from .wxs file to .bat file. * Fix a bug which returns incorrect values for SQL_DATETIME_SUB.
2010-12-24Restore PG_SUBPREFIX.asau2-1263/+1264
2010-12-24Restore PG_SUBPREFIX.asau4-35/+44
2010-12-24Regenerate after PG_SUBPREFIX restoration.asau1-671/+671
2010-12-24Make PG_SUBPREFIX work: override RCD_SCRIPTS_EXAMPLEDIR to follow the setting.asau1-1/+7
2010-12-24Allow PG_SUBPREFIX configuration.asau1-2/+2
2010-12-24Restore PG_SUBPREFIX logic.asau4-677/+706
2010-12-24Allow using this file from other categories.asau1-4/+4
2010-12-23Mechanically replace references to graphics/jpeg with the suitabledsainty1-2/+2
alternative from mk/jpeg.buildlink3.mk This allows selection of an alternative jpeg library (namely the x86 MMX, SSE, SSE2 accelerated libjpeg-turbo) via JPEG_DEFAULT=libjpeg-turbo, and follows the current standard model for alternatives (fam, motif, fuse etc). The mechanical edits were applied via the following script: #!/bin/sh for d in */*; do [ -d "$d" ] || continue for i in "$d/"Makefile* "$d/"*.mk; do case "$i" in *.orig|*"*"*) continue;; esac out="$d/x" sed -e 's;graphics/jpeg/buildlink3\.mk;mk/jpeg.buildlink3.mk;g' \ -e 's;BUILDLINK_PREFIX\.jpeg;JPEGBASE;g' \ < "$i" > "$out" if cmp -s "$i" "$out"; then rm -f "$out" else echo "Edited $i" mv -f "$i" "$i.orig" && mv "$out" "$i" fi done done
2010-12-22Add and enable pear-MDB2_Driver_mysqli.taca1-1/+2
2010-12-22Importing pear-MDB2_Driver_mysqli version 1.5.0b3.taca4-0/+39
mysqli MDB2 driver.
2010-12-22Oops, really update to MDB2_Driver_mysql-1.5.0b3.taca3-11/+11
1.5.0b3 2010-08-29 12:29 UTC Changelog: - fixed bug #15650: mysqli function used in setCharset() - fixed bug #16003: incorrect check for error after mysql_store_result - fixed bug #16147: first prepared statement is emulated when using factory with mysql - fixed bug #16669: hostspec is ignored when protocol is unix - fixed bug #17037: 'on update' not mentioned in tableInfo() - fixed bug #17065: There is no NEW row in on DELETE trigger (fix error in FK constraint triggers) - fixed bug #17650: lastInsertId can not handle bigint, forces cast to integer [alexpw] - return ON UPDATE|DELETE action in getTableConstraintDefinition() note: - the multi_query test failes because this is not supported by ext/mysql open todo items: - use a trigger to emulate setting default now()
2010-12-22Update pear-MDB2_Driver_sqlite package to 1.5.0b3.taca3-21/+7
1.5.0b3 2010-08-29 12:31 UTC Changelog: - fixed bug #16275: split() is deprecated in PHP 5.3 note: open todo items: - fix pattern escaping using GLOB instead of LIKE or create and register own implementation of LIKE
2010-12-22Update pear-MDB2_Driver_pgsql package to 1.5.0b3.taca3-11/+11
1.5.0b3 2010-08-29 12:31 UTC Changelog: - fixed bug #16281: getTableFieldDefinition() does not recognize NULL defaults with datatype [Holger Schletz] - fixed bug #16384: alterTable() does not remove NOT NULL constraints [Holger Schletz] - fixed bug #16405: Compatibility issues with escaped strings [hschletz] open todo items: - enable pg_execute() once issues with bytea column are resolved - use pg_result_error_field() to handle localized error messages (Request #7059) - add option to use unnamed prepared statements (see http://www.postgresql.org/docs/current/static/protocol-flow.html "Extended Query")
2010-12-22Update pear-MDB2_Driver_mysql package to 1.5.0b2.taca2-5/+5
1.5.0b3 2010-08-29 12:29 UTC Changelog: - fixed bug #15650: mysqli function used in setCharset() - fixed bug #16003: incorrect check for error after mysql_store_result - fixed bug #16147: first prepared statement is emulated when using factory with mysql - fixed bug #16669: hostspec is ignored when protocol is unix - fixed bug #17037: 'on update' not mentioned in tableInfo() - fixed bug #17065: There is no NEW row in on DELETE trigger (fix error in FK constraint triggers) - fixed bug #17650: lastInsertId can not handle bigint, forces cast to integer [alexpw] - return ON UPDATE|DELETE action in getTableConstraintDefinition() note: - the multi_query test failes because this is not supported by ext/mysql open todo items: - use a trigger to emulate setting default now()
2010-12-22Update pear-MDB2 package to 2.5.0b3.taca2-6/+6
2.5.0b3 2010-08-29 12:27 UTC Changelog: - fixed bug #15912: MDB2::loadClass can return MDB2_OK without loading class - fixed bug #16020: unable to set params via dsn string in parseDSN() - fixed bug #16508: reusing var name + return by ref [rix0r] - fixed bug #16727: quote(url, 'clob')) fetches URL even if lob_allow_url_include option is false - fixed unreported bug in parseDSN() and oracle's Easy Connect syntax - fixed bug #16973 and #17039: Wrong _skipDelimitedStrings behavior with escaped quotes - fixed bug #16994: incompatible declaration of setTransactionIsolation() in some drivers - dropped PHP 4 support - PHP 5.3 compatibility fixes - performance tweaks (reduced number of internal function calls) - added new sqlsrv driver (native SQL Server driver) [Chris Pucci, Mike Ketcham] - added new ODBC experimental driver [pschellhaas] - Switched test suite to PHPUnit 3.5 open todo items: - handle autoincrement fields in alterTable() - add length handling to LOB reverse engineering - add EXPLAIN abstraction - add cursor support along the lines of PDO (Request #3660 etc.) - add PDO based drivers, especially a driver to support SQLite 3 (Request #6907) - add support to export/import in CSV format - add more functions to the Function module (MD5(), IFNULL(), etc.) - add support for database/table/row LOCKs - add support for CHECK (ENUM as possible mysql fallback) constraints - generate STATUS file from test suite results and allow users to submit test results - add support for full text index creation and querying - add tests to check if the RDBMS specific handling with portability options disabled behaves as expected - handle implicit commits (like for DDL) in any affected driver (mysql, sqlite..) - add a getTableFieldsDefinitions() method to be used in tableInfo() - drop ILIKE from matchPattern() and instead add a second parameter to handle case sensitivity with arbitrary operators - handle LOBs in buffered result sets (Request #8793)
2010-12-19Changes 8.3.13:adam20-2706/+2608
* Force the default wal_sync_method to be fdatasync on Linux * Fix assorted bugs in WAL replay logic for GIN indexes * Fix recovery from base backup when the starting checkpoint WAL record is not in the same WAL segment as its redo point * Fix persistent slowdown of autovacuum workers when multiple workers remain active for a long time * Add support for detecting register-stack overrun on IA64 * Add a check for stack overflow in copyObject() * Fix detection of page splits in temporary GiST indexes * Avoid memory leakage while "ANALYZE"'ing complex index expressions * Ensure an index that uses a whole-row Var still depends on its table * Do not "inline" a SQL function with multiple OUT parameters * Behave correctly if ORDER BY, LIMIT, FOR UPDATE, or WITH is attached to the VALUES part of INSERT ... VALUES * Fix constant-folding of COALESCE() expressions * Fix postmaster crash when connection acceptance (accept() or one of the calls made immediately after it) fails, and the postmaster was compiled with GSSAPI support * Fix missed unlink of temporary files when log_temp_files is active * Add print functionality for InhRelation nodes * Fix incorrect calculation of distance from a point to a horizontal line segment * Fix PL/pgSQL's handling of "simple" expressions to not fail in recursion or error-recovery cases * Fix PL/Python's handling of set-returning functions * Fix bug in "contrib/cube"'s GiST picksplit algorithm * Don't emit "identifier will be truncated" notices in "contrib/dblink" except when creating new connections * Fix potential coredump on missing public key in "contrib/pgcrypto" * Fix memory leak in "contrib/xml2"'s XPath query functions * Update time zone data files to tzdata release 2010o for DST law changes in Fiji and Samoa; also historical corrections for Hong Kong.
2010-12-19Changes 8.4.6:adam24-2767/+2684
* Force the default wal_sync_method to be fdatasync on Linux * Fix assorted bugs in WAL replay logic for GIN indexes * Fix recovery from base backup when the starting checkpoint WAL record is not in the same WAL segment as its redo point * Fix persistent slowdown of autovacuum workers when multiple workers remain active for a long time * Add support for detecting register-stack overrun on IA64 * Add a check for stack overflow in copyObject() * Fix detection of page splits in temporary GiST indexes * Fix error checking during early connection processing * Improve efficiency of window functions * Avoid memory leakage while "ANALYZE"'ing complex index expressions * Ensure an index that uses a whole-row Var still depends on its table * Do not "inline" a SQL function with multiple OUT parameters * Behave correctly if ORDER BY, LIMIT, FOR UPDATE, or WITH is attached to the VALUES part of INSERT ... VALUES * Fix constant-folding of COALESCE() expressions * Fix postmaster crash when connection acceptance (accept() or one of the calls made immediately after it) fails, and the postmaster was compiled with GSSAPI support * Fix missed unlink of temporary files when log_temp_files is active * Add print functionality for InhRelation nodes * Fix incorrect calculation of distance from a point to a horizontal line segment * Fix incorrect calculation of transaction status in ecpg * Fix PL/pgSQL's handling of "simple" expressions to not fail in recursion or error-recovery cases * Fix PL/Python's handling of set-returning functions * Fix bug in "contrib/cube"'s GiST picksplit algorithm * Don't emit "identifier will be truncated" notices in "contrib/dblink" except when creating new connections * Fix potential coredump on missing public key in "contrib/pgcrypto" * Fix memory leak in "contrib/xml2"'s XPath query functions * Update time zone data files to tzdata release 2010o for DST law changes in Fiji and Samoa; also historical corrections for Hong Kong.
2010-12-19Changes 9.0.2:adam34-2947/+2875
* Force the default wal_sync_method to be fdatasync on Linux * Fix "too many KnownAssignedXids" error during Hot Standby replay * Fix race condition in lock acquisition during Hot Standby * Avoid unnecessary conflicts during Hot Standby * Fix assorted bugs in WAL replay logic for GIN indexes * Fix recovery from base backup when the starting checkpoint WAL record is not in the same WAL segment as its redo point * Fix corner-case bug when streaming replication is enabled immediately after creating the master database cluster * Fix persistent slowdown of autovacuum workers when multiple workers remain active for a long time * Fix long-term memory leak in autovacuum launcher * Avoid failure when trying to report an impending transaction wraparound condition from outside a transaction * Add support for detecting register-stack overrun on IA64 * Add a check for stack overflow in copyObject() * Fix detection of page splits in temporary GiST indexes * Fix error checking during early connection processing * Improve efficiency of window functions * Avoid memory leakage while "ANALYZE"'ing complex index expressions * Ensure an index that uses a whole-row Var still depends on its table * Add missing support in "DROP OWNED BY" for removing foreign data wrapper/server privileges belonging to a user * Do not "inline" a SQL function with multiple OUT parameters * Fix crash when inline-ing a set-returning function whose argument list contains a reference to an inline-able user function * Behave correctly if ORDER BY, LIMIT, FOR UPDATE, or WITH is attached to the VALUES part of INSERT ... VALUES * Make the OFF keyword unreserved This prevents problems with using off as a variable name in PL/pgSQL. That worked before 9.0, but was now broken because PL/pgSQL now treats all core reserved words as reserved. * Fix constant-folding of COALESCE() expressions
2010-12-17dynamic linking won't work on Darwin when slapd gets strippedadam1-1/+6
2010-12-17Fix building openldap-smbk5pwd on machines other than NetBSD, and without ↵adam6-23/+50
kerberos if Heimdal not found (only Samba support).
2010-12-17Fix pkglint warningsadam2-4/+3
2010-12-17Bump PKGREVISION from icu shlib major bump.obache1-1/+2
2010-12-17Add two new options for sqlite3, rtree (for multi-dimensional search ↵agc2-1/+17
optimization), and fts (full-text searching). Both options are off by default.
2010-12-16Add include of "../../libltdl/buildlink3.mk".taca1-1/+2
Fix build problem.
2010-12-16Update mysql51-{client,server} package to 5.1.54.taca6-28/+31
Functionality added or changed: * Support for the IBMDB2I storage engine has been removed. (Bug#58079) * The pstack library was nonfunctional and has been removed, along with the --with-pstack option for configure. The --enable-pstack option for mysqld is deprecated and will be removed in MySQL 5.5. (Bug#57210) Bugs fixed: * Performance: InnoDB Storage Engine: Improved concurrency when several ANALYZE TABLE or SHOW TABLE STATUS statements are run simultaneously for InnoDB tables. (Bug#53046) * InnoDB Storage Engine: For an InnoDB table created with ROW_FORMAT=COMPRESSED or ROW_FORMAT=DYNAMIC, a query using the READ UNCOMMITTED isolation level could cause the server to stop with an assertion error, if BLOB or other large columns that use off-page storage were being inserted at the same time. (Bug#57799) * Partitioning: An INSERT ... ON DUPLICATE KEY UPDATE column = 0 statement on an AUTO_INCREMENT column caused the debug server to crash. (Bug#57890) * Several compilation problems were fixed. (Bug#57992, Bug#57993, Bug#57994, Bug#57995, Bug#57996, Bug#57997, Bug#58057) * Passing a string that was not null-terminated to UpdateXML() or ExtractValue() caused the server to fail with an assertion. (Bug#57279) * Queries executed using the Index Merge access method and a temporary file could return incorrect results. (Bug#56862) * The find_files() function used by SHOW statements performed redundant and unnecessary memory allocation. (Bug#51208)
2010-12-14Changes 2.0.6:adam2-6/+7
-Fix: Removing extranous '//' from the perl script. -Fix: slon can segfault while shutting down. -Fix: typenameTypeId() changes signatures in 9.1 -Fix: if slon gets confused waiting for its child it will exit. -Fix: distclean deletes the slony_logshipper flex/bison generated files.
2010-12-13Reset PKGREVISION by update of base PHP version.taca3-6/+3
2010-12-11+ postgresql90-datatypesasau1-1/+2
2010-12-11Import PostgreSQL 9.0 data types support modules as ↵asau3-0/+101
databases/postgresql90-datatypes This package provides the following PostgreSQL modules: - citext - hstore - intarray - isn - ltree - lo - uuid-ossp - unaccent The "citext" module provides a case-insensitive character string type, citext. Essentially, it internally calls lower when comparing values. Otherwise, it behaves almost exactly like text. The "hstore" module implements the "hstore" data type for storing sets of key/value pairs within a single PostgreSQL value. This can be useful in various scenarios, such as rows with many attributes that are rarely examined, or semi-structured data. Keys and values are simply text strings. The "intarray" module provides a number of useful functions and operators for manipulating one-dimensional arrays of integers. There is also support for indexed searches using some of the operators. The "isn" module provides data types for the following international product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), and ISSN (serials). Numbers are validated on input, and correctly hyphenated on output. The "ltree" module implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure. Extensive facilities for searching through label trees are provided. The "lo" module provides support for managing Large Objects (also called LOs or BLOBs). This includes a data type "lo" and a trigger "lo_manage." The "uuid-ossp" module provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms. There are also functions to produce certain special UUID constants. "unaccent" is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output is always passed to the next dictionary (if any), unlike the normal behavior of dictionaries. This allows accent-insensitive processing for full text search.
2010-12-11Unbreak installation of dynamic modules. Bump revision.asau2-6/+7
2010-12-11Build and install support module. Bump revision.asau2-2/+5
2010-12-11Allow more dynamic modules.asau1-10/+2
2010-12-11Support "xml" option (default off) as requested in PR pkg/44217asau1-2/+10
2010-12-10+ postgresql90-monitoringasau1-1/+2
2010-12-10Import PostgreSQL 9.0 monitoring modules as databases/postgresql90-monitoringasau3-0/+52
This package provides the following PostgreSQL modules: - auto_explain - pg_buffercache - pg_stat_statements - pgstattuple The "auto_explain" module provides a means for logging execution plans of slow statements automatically, without having to run EXPLAIN(7) by hand. This is especially helpful for tracking down un-optimized queries in large applications. The "pg_buffercache" module provides a means for examining what's happening in the shared buffer cache in real time. The "pg_stat_statements" module provides a means for tracking execution statistics of all SQL statements executed by a server. The "pgstattuple" module provides various functions to obtain tuple-level statistics.
2010-12-10+ postgresql90-upgradeasau1-1/+2
2010-12-10Import PostgreSQL 9.0 binary upgrade tool as databases/postgresql90-upgradeasau3-0/+35
pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be migrated to a later PostgreSQL major version without the data dump/reload typically required for major version upgrades, e.g. from 8.4.7 to the current major release of PostgreSQL. It is not required for minor version upgrades, e.g. from 9.0.1 to 9.0.4.
2010-12-10Build fix: OpenSolaris needs explicit "-lintl" in LIBS.asau1-1/+3
2010-12-10Update to 0.90:wiz3-14/+14
shared-mime-info 0.90 (2010-12-1) * Mime-type Changes: - Make application/epub+zip sub-class-of application/zip - Make sure RAM files are not all treated as text - Make CMakefiles a sub-class of text/plain - Add new mime-type for Panasonic RW2 images - Add XSL magic - Add root-XML for XSL - Add *.gem as a glob for tar archives - Add test case for text/directory files - Add go source code - Add pdf.xz mime-type - Add text/x-ooc source code - Add Cobol source code * Other: - Don't error out on the x-scheme-handler/* mime-types - Fix crasher when mime-magic is empty
2010-12-10+ postgresql90-replicationtoolsasau1-1/+2