summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2008-03-06Support user-destdir installation.jlam1-1/+2
2008-03-06+ Remove explicit naming of "-lncurses -ltermcap" as the way to getjlam3-20/+39
the termcap libraries. Including termcap.buildlink3.mk (indirectly through including readline/buildlink3.mk) will do the right thing. + Remove readline dependency from Makefile.common and add it into mysql5-client/Makefile. Only the -client package needs and uses readline. The -server package only "needs" it to placate the configure script, but none of its installed binaries are linked against it. + Add full DESTDIR support to the -client and -server packages. Bump the PKGREVISION of mysql5-client to 3. The PKGREVISION of mysql5-server remains unchanged since there are no user-visible changes to the binary package.
2008-03-06+ Honor PKGINFODIR in mysql4-client.jlam3-24/+41
+ Remove explicit naming of "-lncurses -ltermcap" as the way to get the termcap libraries. Including termcap.buildlink3.mk (indirectly through including readline/buildlink3.mk) will do the right thing. + Remove readline dependency from Makefile.common and add it into mysql4-client/Makefile. Only the -client package needs and uses readline. The -server package only "needs" it to placate the configure script, but none of its installed binaries are linked against it. + Add full DESTDIR support to the -client and -server packages. Bump the PKGREVISION of mysql4-client to 3. The PKGREVISION of mysql4-server remains unchanged since there are no user-visible changes to the binary package.
2008-03-06Recursive PKGREVISION bump for gnutls-2.2.2 update with shlib major bump.wiz3-5/+6
2008-03-04Rendezvous has been renamed to Bonjouradam1-3/+3
2008-03-04Added postgresql83adam1-1/+8
2008-03-04Errare humanum estadam1-1477/+0
2008-03-04PostgreSQL 8.3adam48-0/+5416
With significant new functionality and performance enhancements, this release represents a major leap forward for PostgreSQL. This was made possible by a growing community that has dramatically accelerated the pace of development. This release adds the following major features: * Full text search is integrated into the core database system * Support for the SQL/XML standard, including new operators and an XML data type * Enumerated data types (ENUM) * Arrays of composite types * Universally Unique Identifier (UUID) data type * Add control over whether NULLs sort first or last * Updatable cursors * Server configuration parameters can now be set on a per-function basis * User-defined types can now have type modifiers * Automatically re-plan cached queries when table definitions change or statistics are updated * Numerous improvements in logging and statistics collection * Support Security Service Provider Interface (SSPI) for authentication on Windows * Support multiple concurrent autovacuum processes, and other autovacuum improvements * Allow the whole PostgreSQL distribution to be compiled with Microsoft Visual C++
2008-03-04Resign from maintaining a lot of packages, so everyone is free to updaterillig1-2/+2
them at will.
2008-03-04Update to 3.5.6:wiz3-8/+10
2008 Feb 6 (3.5.6) * Fix a bug ( ticket #2913) that prevented virtual tables from working in a LEFT JOIN. The problem was introduced into shortly before the 3.5.5 release. * Bring the OS/2 porting layer up-to-date. * Add the new sqlite3_result_error_code() API and use it in the implementation of ATTACH so that proper error codes are returned when an ATTACH fails. 2008 Jan 31 (3.5.5) * Convert the underlying virtual machine to be a register-based machine rather than a stack-based machine. The only user-visible change is in the output of EXPLAIN. * Add the build-in RTRIM collating sequence. 2007 Dec 14 (3.5.4) * Fix a critical bug in UPDATE or DELETE that occurs when an OR REPLACE clause or a trigger causes rows in the same table to be deleted as side effects. (See ticket #2832.) The most likely result of this bug is a segmentation fault, though database corruption is a possibility. * Bring the processing of ORDER BY into compliance with the SQL standard for case where a result alias and a table column name are in conflict. Correct behavior is to prefer the result alias. Older versions of SQLite incorrectly picked the table column. (See ticket #2822.) * The VACUUM command preserves the setting of the legacy_file_format pragma. ( Ticket #2804.) * Productize and officially support the group_concat() SQL function. * Better optimization of some IN operator expressions. * Add the ability to change the auto_vacuum status of a database by setting the auto_vaccum pragma and VACUUMing the database. * Prefix search in FTS3 is much more efficient. * Relax the SQL statement length restriction in the CLI so that the ".dump" output of databases with very large BLOBs and strings can be played back to recreate the database. * Other small bug fixes and optimizations. 2007 Nov 27 (3.5.3) * Move website and documentation files out of the source tree into a separate CM system. * Fix a long-standing bug in INSERT INTO ... SELECT ... statements where the SELECT is compound. * Fix a long-standing bug in RAISE(IGNORE) as used in BEFORE triggers. * Fixed the operator precedence for the ~ operator. * On win32, do not return an error when attempting to delete a file that does not exist. * Allow collating sequence names to be quoted. * Modify the TCL interface to use sqlite3_prepare_v2(). * Fix multiple bugs that can occur following a malloc() failure. * sqlite3_step() returns SQLITE_MISUSE instead of crashing when called with a NULL parameter. * FTS3 now uses the SQLite memory allocator exclusively. The FTS3 amalgamation can now be appended to the SQLite amalgamation to generate a super-amalgamation containing both. * The DISTINCT keyword now will sometimes use an INDEX if an appropriate index is available and the optimizer thinks its use might be advantageous.
2008-03-03Update to 0.36. Changes: be more careful in test code not to usegdt2-6/+6
features that are not always available.
2008-03-03Update "phpmyadmin" package to version 2.11.5.tron2-7/+6
The new version fixes several bugs including the cross site scripting vulnerability reported in PMASA-2007-8 and the SQL inject vulnerability report in PMASA-2008-1.
2008-03-03Mechanical changes to add DESTDIR support to packages that installjlam19-156/+227
their files via a custom do-install target.
2008-03-03Need special care for mimedb.obache1-2/+5
Fixed installation problem in PR 38138. Bump PKGREVISION. Now DESTDIR ready.
2008-03-01Fix PLIST. The package also installs an older version of the PostgreSQLtnn1-1/+3
driver, but without .la file.
2008-02-28Replaced the deprecated INSTALLATION_DIRS_FROM_PLIST with AUTO_MKDIRS,rillig2-4/+4
to shut up the pkglint warnings.
2008-02-24Update OpenLDAP packages to 2.4.8 (bugfixes).ghen9-30/+29
OpenLDAP 2.4.8 Release (2008/02/19) Fixed ldapmodify verbose logging (ITS#5247) Fixed ldapdelete with sizelimit (ITS#5294) Fixed ldapdelete with subentries control (ITS#5293) Fixed ldapsearch exit code init (ITS#5317) Fixed libldap extended decoding (ITS#5304) Fixed libldap filter abort (ITS#5300) Fixed libldap ldap_parse_sasl_bind_result (ITS#5263) Fixed libldap result codes for open (ITS#5338) Fixed libldap search timeout crash (ITS#5291) Fixed libldap paged results crash (ITS#5315) Fixed libldap cipher suite with GnuTLS (ITS#5341) Fixed slapd support for 2.1 CSN (ITS#5348) Fixed slapd include handling (ITS#5276) Fixed slapd modrdn check for valid new DN (ITS#5344) Fixed slapd multi-step SASL binds (ITS#5298) Fixed slapd non-atomic signal variables (ITS#5248) Fixed slapd overlay ordering when moving to slapd.d (ITS#5284) Fixed slapd NULL printf (ITS#5264) Fixed slapd NULL set values (ITS#5286) Fixed slapd segv with SASL/OTP (ITS#5259) Fixed slapd timestamp race condition (ITS#5370) Fixed slapd cn=config crash on delete (ITS#5343) Fixed slapd cn=config global acls (ITS#5352) Fixed slapd truncated cookie (ITS#5362) Fixed slapd sasl with CLEARTEXT (ITS#5368) Fixed slapd str2entry with no attrs (ITS#5308) Fixed slapd TLSVerifyClient default (ITS#5360) Fixed slapd HAVE_TLS dependency (ITS#5379) Fixed slapd delta-syncrepl refresh mode (ITS#5376) Fixed slapd ACL sets URI attrs (ITS#5384) Fixed slapd invalid entryUUID filter (ITS#5386) Fixed slapd-bdb idlcache on adds (ITS#5086) Fixed slapd-bdb crash with modrdn (ITS#5358) Fixed slapd-bdb segv with bdb4.6 (ITS#5322) Fixed slapd-bdb modrdn to same dn (ITS#5319) Fixed slapd-bdb MMR (ITS#5332) Added slapd-bdb/slapd-hdb DB encryption (ITS#5359) Fixed slapd-ldif delete (ITS#5265) Fixed slapd-meta link to slapd-ldap (ITS#5355) Fixed slapd-meta setting of sm_nvalues (ITS#5375) Fixed slapd-monitor crash (ITS#5311) Fixed slapd-relay compare (ITS#4937) Added slapd-sock (ITS#4094) Fixed slapo-accesslog cleanup on successful response (ITS#5374) Added slapo-autogroup contrib module (ITS#5145) Added slapo-constraint cross-attribute constraints (ITS#4987) Fixed slapo-memberof objectClass inheritance (ITS#5299) Added slapo-memberof global overlay support (ITS#5301) Fixed slapo-memberof leak (ITS#5302) Fixed slapo-ppolicy only password check with policy (ITS#5285) Fixed slapo-ppolicy del/replace password without new one (ITS#5373) Fixed slapo-syncprov hang on checkpoint (ITS#5261) Added slapo-translucent local searching (ITS#5283) Removed lint Build Environment Fixed libldap_r threaded library linking (ITS#4982) Fixed libldap use of %n (ITS#5324) Fixed test047 to skip if rwm is not available (ITS#5292) Documentation DB_CONFIG.example URL wrong in comments (ITS#5288) Add cn=config example for auditlog (ITS#5245) ldapmodify(1) clarification for RFC2849 (ITS#5312)
2008-02-21+ Name the programs installed by the db(2) package db2_*.jlam8-1496/+1521
+ Put documentation under ${PREFIX}/share/doc instead of ${PREFIX}/share/doc/html. Packages that install documentation under the "html" directory are supposed to move them to the "doc" directory when they're updated, but these packages are basically EOL'ed so just move them now. + Add full DESTDIR support. Bump the PKGREVISION of databases/db to 3 and databases/db3 to 4.
2008-02-18Update p5-BerkeleyDB to 0.33.obache2-6/+7
Patch provided by Mark E. Perkins in PR 38050. While here, marked as DESTDIR ready. 0.33 17th January 2008 * Added failchk, set_isalive, lock_stat_print & mutex_stat_print. Patch provided by Thomas Busch. 0.32 10th July 2007 * Updates to support Berkeley DB 4.6 * Remove all global static data from BerkeleyDB.xs.
2008-02-16DB-1.85 compatability was enabled long long ago.obache1-1/+7
At least, all db4>=4.6.21 have it. Add same trick as db2/db3. Fixed link problem that expect db-1.85 compat library is -ldb, like a PR 37647.
2008-02-16Switch MASTER_SITES to official site on oracle.com.obache1-2/+2
2008-02-16Update to 0.35.gdt2-6/+6
- 0.35 | 2008-02-13 - Bugfix: composition INTERSECT in `parse+make-SELECT-tree' This proc, in module (database postgres-qcons), used to erroneously accept #:intersection and emit "INTERSECTION". Now, it accepts #:intersect and emits "INTERSECT". - New (database postgres) procs - pg-escape-string-conn - pg-escape-bytea-conn - pg-unescape-bytea - Tested against PostgreSQL 7.4.19
2008-02-14Changes 0.7.2:adam8-134/+10
- When administrate users on mysql servers >= 4.0 the max_updates/queries/ connections settings will reflected. - fixes for building with gcc 4 - fixes for mysql lib > 4.1 - Integrated a compact layout where the non-modal windows are part of main window - Setting up a new more compact table browser widget
2008-02-09Changes 3.52.6:adam4-22/+20
* Added support for GTK+ 2.x * Fixed long mutex lock on connect * Fixed problems with SQLBrowseConnect * Fixed missing functions in export list * Fixed core dump when checking for driver odbc version * Fixed allocation error in SQLDescribeCol * Fixed rpm specification for RedHat * Fixed porting problems on FreeBSD, OpenBSD and OSF * Use SQLFetchScroll in iodbctest
2008-02-09Changes 2.2.12:adam5-31/+29
* Add missing SQLSetStmtOptionA and SQLSetStmtOptionW * The config string being passed into ConfigDsn was wrong, removed semicolon, and added terminating double null * Add help help to isql * Couple of changes to make the build on OSX work better * Alter odbctest FullConnect to use SQLDriverConnect * Replace a missed flag for true 64 bit operation * Add ODBC3<->ODBC2 type mapping in SQLSetParam * Add missing SQLSetStmtOptionW.c * Tidy up the search for GUI lib code in SQLManageDatasource * Backport a couple of changes from the Debian build into the cursor lib * Add extra config settings to the MaxDB/SapDB setup lib * Fix possible exit from SQLConnect without having closed in the driver * Fix configure problem on Tru64 * Fix a build issue on Sinix * Allow calling metadata functions via the cursor lib * Alter args to SQLParamOptions * Fix bug preventing attribute length from being returned from SQLDrivers * Fix broken iusql * more...
2008-02-09Update ruby-activerecord to 2.0.2.minskim5-32/+59
There have been too many changes. Please see CHANGELOG for the complete list: http://dev.rubyonrails.org/browser/tags/rel_2-0-2/activerecord/CHANGELOG
2008-02-08Add DESTDIR support.obache1-5/+7
2008-02-08This package is DESTDIR ready.obache4-4/+12
2008-02-07This package is DESTDIR ready.obache1-1/+3
2008-02-07No need to replace ruby with ${RUBY}.obache2-62/+3
lang/ruby/buildlink3.mk take care it.
2008-02-04Add an option for LDAP authentication as explained onghen2-3/+11
http://www.postgresql.org/docs/8.3/static/auth-methods.html#AUTH-LDAP
2008-02-01update to 2.2.10drochner3-9/+11
changes: -fixes for several database corruption issues and crashes -fixes for Gedcom, ANSEL and XML import/export issues -translation updates -various small fixes to several reports
2008-01-30Update to phppgadmin-4.1.3. Patch provided by Aleksej Saushev.tnn3-103/+190
This adds, among other things, improved support for PostgreSQL 8.x and php 5.x. Also SSL support, many small bugfixes and updated translations.
2008-01-22Added some patches to fix the use of the sigsend() function, which isrillig5-4/+54
not available on NetBSD.
2008-01-18Per the process outlined in revbump(1), perform a recursive revbumptnn42-54/+84
on packages that are affected by the switch from the openssl 0.9.7 branch to the 0.9.8 branch. ok jlam@
2008-01-15Update to 0.23:wiz5-17/+18
shared-mime-info 0.23 (2007-12-18) * Mime-type Changes: - Add QTIF QuickTime image - Add SDP stream description - Add Vala source file - Add Atom feed, OPML - Add SAMI, MicroDVD, MPSub, SSA subtitles - Add audio/x-m4b as a sub-class of audio/mp4 - Add *.aac as a suffix for MPEG-4 audio files - Add Compressed Flash detection, add FutureSplash support - Add *.asc as a suffix for PGP armoured keys - Add application/msword as a sub-class of application/x-ole-storage - Don't associate *.htm and *.html to Mozilla bookmarks - Add more aliases for PowerPoint and Word mime-types - Add *.vlc as a suffix for m3u files - Better magic for Word and Office documents - Split Windows Media Station playlists from ASX ones - Fix up JPEG 2000 mime-types * Other: - Add a testsuite in the CVS tree
2008-01-14Changes 1.2.12:adam5-14/+47
- Fixed problem with DDL SCRIPT parser where C-style comments were not being processed properly - Added stored functions and documentation for adding empty tables (notably *partitions*) to replication. Note these functions do no work when not specifically requested. - Added a fairly substantial partitioning test to exercise the new stored functions above. - Backport "listen path" generator function from CVS HEAD (2.0) to 1.2 branch. - Fixed a problem with "EXECUTE SCRIPT" (introduced in remote_worker.c version 1.124.2.13) where moving the relevant code into a subroutine at the end led to losing the "BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;" query that needs to be the first thing run... - Fixing the archive sequence generations (in log shipping). All non-SYNC events must start the local transaction before creating the archive as well, so that the lock on the archive counter table serializes archive creation. - Fixed logging done in local_listener.c - various places, there was no '\n' in some cases, which would lead to entries being folded together. - Fix launch_slons.sh - was not stripping quotes from PID file name - Error handling for "ERROR: could not serialize access due to concurrent update" - Fixes to slonik_build_env script - it wasn't properly handling cases where there was just 1 table or 1 sequence, and had a problem with the -schema option - thanks, Bernd Helmle
2008-01-13Remove revision to match postgresql82 8.2.6adam1-2/+1
2008-01-13Update openldap packages to OpenLDAP 2.4.7 (forced update for db4-4.6.xghen20-175/+133
support, reported via PR pkg/37745 ). OpenLDAP 2.4.x brings a lot of new features, including multi-master support, dynamic configuration and schema changes, automatic reverse group membership, significant performance improvements, etc. One of the most noticeable changes for administrators though is the removal if the slurpd daemon (in favour of the sync replication mechanism). Users of slurpd replication should migrate to sync replication before upgrading to OpenLDAP 2.4.x.
2008-01-12db4 update related revision bumpadam8-12/+16
2008-01-12Change *_SITES to oracle (old one does not exist anymore).obache1-4/+3
2008-01-11fix PKGVERSION to start with a number, as suggested by Jeremy C. Reeddrochner1-1/+2
in pkgsrc-users
2008-01-10Changes 4.6.21:adam7-72/+147
* Fix a bug where mutex contention in database environments configured for hybrid mutex support could result in performance degradation. * Fix a bug where closing a database handle after aborting a transaction which included a failed open of that database handle could result in application failure. * Fix multiple MVCC bugs including a race which could result in incorrect data being returned to the application. * Fix a bug where a database store into a Hash database could self-deadlock in a database environment configured for the Berkeley DB Concurrent Data Store product and with a free-threaded DB_ENV or DB handle. * Fix an installation bug where Berkeley DB's PHP header file was not installed in the correct place.
2008-01-10Changes 1.2.3:adam26-380/+60
Bug fixes: * fixed simple bind with a patch from Pawel Salek (fixes 1753419) Changes 1.2.2: Bug fixes: * fixed a crash when loading the state file on BSD systems (patch from the NetBSD people) * make command line argument handling more robust Changes 1.2.1: Build Improvements * fixed a bash expression
2008-01-07Update databases/jdbc-postgresql80 from 318 to 321abs2-10/+10
Version 8.0-321 (2007-12-02) * fix Make code that parses queries for updateable resultsets aware of the ONLY clause. (jurka) Thanks to Oleg Vasylenko. * fix While custom type maps are not implemented, the code to detect the caller trying to use them threw a ClassCastException. Correctly detect the attempted use of custom types and bail out with a SQLException. (jurka) Version 8.0-320 (2007-07-31) * add Make setObject recognize a parameter of type java.lang.Byte. (jurka) Thanks to Boom Roos. * fix Updatable ResultSets did not work when updating bytea data and then retrieving it because we send the data to the server in binary format, but the ResultSet was expecting to read it in text format. So we need to convert the data from binary to text format before stuffing it into the ResultSet. (jurka) Thanks to Mikko Tiihonen. * fix Do escape processing on batch Statements prior to execution. This already worked for PreparedStatements, but not plain Statements. (jurka) Thanks to Hui Ye. * fix When retrieving the columns of a function that returns a complex type, don't retrieve system columns (like xmin/xmax/...) that you'll find if the type is from a table. (jurka) * fix Error message was reporting the wrong parameter type value in the V3 protocol's SimpleParameterList implementation. (jurka) Thanks to Nathan Keynes. * fix Explicitly state which source level we are compiling. Newer versions of gij/gcj run a 1.5 VM, but default to a 1.4 source level compile which tricks up our build system. This still doens't fix the case of running with a newer VM than compiler, but I don't see what we can do about that. (jurka) Thanks to Tom Lane, Oliver Jowett. Version 8.0-319 (2007-04-18) * add Implement ResultSet.updateArray by simply mapping it to updateObject which now works for arrays. (jurka) * fix Produce the timezone that we send to the server in the same format that we can parse. This is important for updatable ResultSets as we must be able to parse the format we produce. (jurka) Thanks to Leon Do. * fix Allow updatable ResultSets to update arrays. (jurka) Thanks to Vasylenko.
2008-01-07Update databases/jdbc-postgresql81 from 408 to 411abs2-10/+10
Version 8.1-411 (2007-12-02) * fix When doing batch execution we can have multiple Parse and DescribeStatement messages on the wire at the same time. When we finally get around to collecting the DescribeStatement results we must check whether they still apply to the currently parsed query. Otherwise we'll overwrite our type information with stale data that will cause failures down the line. (jurka) Thanks to Eric Faulhaber. * fix CallableStatements with OUT parameters that get executed more than prepareThreshold times failed if clearParameters() was called in between executions. When we've hit the prepareThreshold, we no longer send Parse messages which invoke SimpleParameterList.getTypeOID which has side effects required to setup the parameters correctly. Add an explicit convertFunctionOutParameters method to do this work instead that we call in all execution paths. (jurka) Thanks to Ludovico Bianchini. * fix Multiple calls to XAConnection.getConnection within the same user transaction ended up restarting the transaction on the server side as a result of manipulating the autocommit state. When retrieving a Connection, we must pay attention to whether a user transaction is in progress when setting the autocommit state. (jurka) Thanks to Heikki Linnakangas. * fix Make code that parses queries for updateable resultsets aware of the ONLY clause. (jurka) Thanks to Oleg Vasylenko. * fix While custom type maps are not implemented, the code to detect the caller trying to use them threw a ClassCastException. Correctly detect the attempted use of custom types and bail out with a SQLException. (jurka) Version 8.1-410 (2007-07-31) * add Make setObject recognize a parameter of type java.lang.Byte. (jurka) Thanks to Boom Roos. * fix Updatable ResultSets did not work when updating bytea data and then retrieving it because we send the data to the server in binary format, but the ResultSet was expecting to read it in text format. So we need to convert the data from binary to text format before stuffing it into the ResultSet. (jurka) Thanks to Mikko Tiihonen. * fix Do escape processing on batch Statements prior to execution. This already worked for PreparedStatements, but not plain Statements. (jurka) Thanks to Hui Ye. * fix Don't return quotes around identifiers in the results of DatabaseMetaData.getIndexInfo even if they would require quoting in SQL. (jurka) Thanks to Andrei Badea. * fix When retrieving the columns of a function that returns a complex type, don't retrieve system columns (like xmin/xmax/...) that you'll find if the type is from a table. (jurka) * fix The previous fix to try and set a XA based Connection's autocommit property correctly didn't quite work. Calling XAConnection.getConnection set autocommit to true even if we already had a transaction in progress. (jurka) Thanks to Luca Ferrari, Heikki Linnakangas. * fix Error message was reporting the wrong parameter type value in the V3 protocol's SimpleParameterList implementation. (jurka) Thanks to Nathan Keynes. * fix Backpatch fix to 8.1: Allow XAResource.start with TMJOIN in a limited set of circumstances to work with WebLogic. We allow TMJOIN only if the resource was previously ended and the Xid is the same as the current Xid. (jurka) Thanks to Jan de Visser and Heikki Linnakangas. * fix Backpatch fix to 8.1: A XAConnections default autocommit state should be true. The driver was previously setting autocommit to false and assuming it would stay that way. This caused two problems. First, some applications expected to be able to issue local autocommit transactions prior to begin(). Second, some TMs (Geronimo) set the autocommit state to true themselves, which causes problems as the driver did not expect it to be changed. This patch correctly disables and enables autocommit around begin, prepare, commit, and rollback methods. (jurka) Thanks to Allan Saddi. * fix Explicitly state which source level we are compiling. Newer versions of gij/gcj run a 1.5 VM, but default to a 1.4 source level compile which tricks up our build system. This still doens't fix the case of running with a newer VM than compiler, but I don't see what we can do about that. (jurka) Thanks to Tom Lane, Oliver Jowett. Version 8.1-409 (2007-04-18) * add Implement ResultSet.updateArray by simply mapping it to updateObject which now works for arrays. (jurka) * fix Statement.getTime, .getDate, and .getTimestamp methods which are passed a Calendar object were rotating the timezone in the wrong direction. Rewrite this code to use the existing TimestampUtils methods to match the working code in ResultSets. (jurka) Thanks to Ravi Periasmy. * fix Produce the timezone that we send to the server in the same format that we can parse. This is important for updatable ResultSets as we must be able to parse the format we produce. (jurka) Thanks to Leon Do. * fix Fix persistence of XA datasources. PGObjectFactory wasn't aware of PGXADataSource and can't be because of the requirements for different build versions. Add a new PGXADataSourceFactory to provide this functionality. (jurka) Thanks to Heikki Linnakangas. * fix Fix the error message generated by a CallableStatement not getting results that match the registered out parameters to report the correct parameter position. (jurka) * fix Interval formatting didn't work for negative seconds values greater than -1. It would format it as -.5, but interval input doesn't accept this, so write it as -0.5 instead. (jurka) * fix Allow updatable ResultSets to update arrays. (jurka) Thanks to Vasylenko. * fix In an error message reporting an unparseable timestamp value the code was trying to put the unparseable portion into the error message, but used the wrong variable to get the correct length. (jurka)
2008-01-07Update databases/jdbc-postgresql82 to 507 from 504abs2-9/+9
Version 8.2-507 (2007-12-02) * fix When doing batch execution we can have multiple Parse and DescribeStatement messages on the wire at the same time. When we finally get around to collecting the DescribeStatement results we must check whether they still apply to the currently parsed query. Otherwise we'll overwrite our type information with stale data that will cause failures down the line. (jurka) Thanks to Eric Faulhaber. * fix CallableStatements with OUT parameters that get executed more than prepareThreshold times failed if clearParameters() was called in between executions. When we've hit the prepareThreshold, we no longer send Parse messages which invoke SimpleParameterList.getTypeOID which has side effects required to setup the parameters correctly. Add an explicit convertFunctionOutParameters method to do this work instead that we call in all execution paths. (jurka) Thanks to Ludovico Bianchini. * fix The driver was incorrectly parsing identifiers that had parts that look like dollar quotes. Things like a$b$c are valid identifiers, not dollar quotes. When determining if a $ we've found is a dollar quote start, look at the preceding character and see if it is a valid identifier part to determine if we're in the midst of an identifier or are starting a new token. (jurka) Thanks to Michael Paesold. * fix Multiple calls to XAConnection.getConnection within the same user transaction ended up restarting the transaction on the server side as a result of manipulating the autocommit state. When retrieving a Connection, we must pay attention to whether a user transaction is in progress when setting the autocommit state. (jurka) Thanks to Heikki Linnakangas. * fix Support NULL array elements. (jurka) Thanks to Christian Schröder. * fix Make code that parses queries for updateable resultsets aware of the ONLY clause. (jurka) Thanks to Oleg Vasylenko. * fix While custom type maps are not implemented, the code to detect the caller trying to use them threw a ClassCastException. Correctly detect the attempted use of custom types and bail out with a SQLException. (jurka) Version 8.2-506 (2007-07-31) * add Make setObject recognize a parameter of type java.lang.Byte. (jurka) Thanks to Boom Roos. * update Brazilian Portuguese translation update. (jurka) Thanks to Euler Taveira de Oliveira. * update Serbian translation updates. (jurka) Thanks to Bojan Skaljac. * fix Updatable ResultSets did not work when updating bytea data and then retrieving it because we send the data to the server in binary format, but the ResultSet was expecting to read it in text format. So we need to convert the data from binary to text format before stuffing it into the ResultSet. (jurka) Thanks to Mikko Tiihonen. * fix ResultSet.updateNClob(String, Reader) goes into an infinite loop. It really meant to call updateNClob(int, Reader), but was calling itself instead. (jurka) Thanks to Mikko Tiihonen. * fix Do escape processing on batch Statements prior to execution. This already worked for PreparedStatements, but not plain Statements. (jurka) Thanks to Hui Ye. * fix Don't return quotes around identifiers in the results of DatabaseMetaData.getIndexInfo even if they would require quoting in SQL. (jurka) Thanks to Andrei Badea. * fix When retrieving the columns of a function that returns a complex type, don't retrieve system columns (like xmin/xmax/...) that you'll find if the type is from a table. (jurka) * fix The previous fix to try and set a XA based Connection's autocommit property correctly didn't quite work. Calling XAConnection.getConnection set autocommit to true even if we already had a transaction in progress. (jurka) Thanks to Luca Ferrari, Heikki Linnakangas. * fix Error message was reporting the wrong parameter type value in the V3 protocol's SimpleParameterList implementation. (jurka) Thanks to Nathan Keynes. * fix Explicitly state which source level we are compiling. Newer versions of gij/gcj run a 1.5 VM, but default to a 1.4 source level compile which tricks up our build system. This still doens't fix the case of running with a newer VM than compiler, but I don't see what we can do about that. (jurka) Thanks to Tom Lane, Oliver Jowett. Version 8.2-505 (2007-04-18) * add Initial Serbian translation. (jurka) Thanks to Bojan Skaljac. * add Implement ResultSet.updateArray by simply mapping it to updateObject which now works for arrays. (jurka) * fix Statement.getTime, .getDate, and .getTimestamp methods which are passed a Calendar object were rotating the timezone in the wrong direction. Rewrite this code to use the existing TimestampUtils methods to match the working code in ResultSets. (jurka) Thanks to Ravi Periasmy. * fix Produce the timezone that we send to the server in the same format that we can parse. This is important for updatable ResultSets as we must be able to parse the format we produce. (jurka) Thanks to Leon Do. * fix Make Large Object handling work when the oid counter has exceeded Integer.MAX_VALUE by handling oids as longs. (jurka) * fix Fix persistence of XA datasources. PGObjectFactory wasn't aware of PGXADataSource and can't be because of the requirements for different build versions. Add a new PGXADataSourceFactory to provide this functionality. (jurka) Thanks to Heikki Linnakangas. * fix Fix the error message generated by a CallableStatement not getting results that match the registered out parameters to report the correct parameter position. (jurka) * fix Interval formatting didn't work for negative seconds values greater than -1. It would format it as -.5, but interval input doesn't accept this, so write it as -0.5 instead. (jurka) * fix Change DatabaseMetaData.getSearchStringEscape to always return "\\" instead of "\\\\". Previously it was assuming that it would be fed directly into a query and it needed to escape itself for the backend's input parser. This doesn't work for things like PreparedStatement parameters or DatabaseMetaData methods that take patterns. (jurka) Thanks to Valery Meshkov. * fix Allow updatable ResultSets to update arrays. (jurka) Thanks to Vasylenko. * fix In an error message reporting an unparseable timestamp value the code was trying to put the unparseable portion into the error message, but used the wrong variable to get the correct length. (jurka) * fix Parse timezones that have offsets in seconds. 8.2 servers now return this information so we must be able to handle it. (jurka)
2008-01-07Changes 8.2.6:adam6-15/+21
This release contains a variety of fixes from 8.2.5, including fixes for significant security issues.
2008-01-07Changes 8.1.11:adam4-8/+14
This release contains a variety of fixes from 8.1.10, including fixes for significant security issues. This is the last 8.1.X release for which the PostgreSQL community will produce binary packages for Windows. Windows users are encouraged to move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X that are impractical to back-port. 8.1.X will continue to be supported on other platforms.
2008-01-07Changes 8.0.15:adam4-8/+13
This release contains a variety of fixes from 8.0.14, including fixes for significant security issues. This is the last 8.0.X release for which the PostgreSQL community will produce binary packages for Windows. Windows users are encouraged to move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X that are impractical to back-port. 8.0.X will continue to be supported on other platforms.