summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2021-01-16Pullup ticket #6402 - requested by niabsiegert1-1/+9
databases/py-ldap: NetBSD build fix Revisions pulled up: - databases/py-ldap/Makefile 1.89 --- Module Name: pkgsrc Committed By: nia Date: Thu Jan 14 11:41:03 UTC 2021 Modified Files: pkgsrc/databases/py-ldap: Makefile Log Message: py-ldap: Force pkgsrc version on NetBSD where version detection fails PR pkg/55902
2020-12-30py-ana: Nothing stopping this from working with py38/etcnia1-2/+2
2020-12-28Remove extra RUBY_VERSIONS_ACCEPTED.taca1-3/+1
2020-12-23py-peewee: fix building with Python 3.9adam1-1/+5
2020-12-20db4: remove workaround for very old GCCmaya1-25/+0
2020-12-20db5: remove workaround for very old GCCmaya1-25/+0
2020-12-19guile-pg: Update to 0.49gdt2-9/+14
- 0.49 | 2020-11-13 - dependency clarified: state range Previously, the README file intimated that any Guile 1.4.x and later would work w/ Guile-PG. This has now been clarified to state the actual working range (1.4.x to 2.0.x, inclusive). We have plans for adding support for 2.2.x (and maybe 3.x) in the near to middling future. See also file test/OK. - Guile "auto-compilation" suppressed In all three phases: configuration, build, and test, Guile 2.x "auto-compilation" of .scm to .go files is suppressed by setting the env var ‘GUILE_AUTO_COMPILE=0’. We will do intentional compilation at some point, as soon as we figure out how to DTRT. See project CMOD-PLAY for experiments.
2020-12-19postgresql-postgis2: Update to 3.1.0gdt3-11/+27
packaging changes: PostgresQL 9.5 is no longer supported. Upstream NEWS: PostGIS 3.1.0 2020/12/18 This version requires PostgreSQL 9.6 or higher and GEOS 3.6 or higher Additional features are enabled if you are running GEOS 3.9. * Breaking changes * - #4737, Bump minimum protobuf-c requirement to 1.1.0 (Raúl Marín) The configure step will now fail if the requirement isn't met or explicitly disabled (--without-protobuf) - #4258, Separated postgis_sfcgal from postgis into its own lib file and extension (Regina Obe) - #4577, Drop support for PostgreSQL 9.5 (Raúl Marín) - #4601, ST_TileEnvelope signature changed. - #3057, ST_Force3D, ST_Force3DZ, ST_Force3DM and ST_Force4D signatures changed. * Deprecated signatures * - Function postgis_svn_version() replaced by postgis_lib_revision() (Sandro Santilli) - #4214, Deprecated ST_Count(tablename,...), ST_ApproxCount(tablename, ...) ST_SummaryStats(tablename, ..), ST_Histogram(tablename, ...), ST_ApproxHistogram(tablename, ...), ST_Quantile(tablename, ...), ST_ApproxQuantile(tablename, ...) removed. (Darafei Praliaskouski) * New features* - #4687, (GEOS 3.9+) MaximumInscribedCircle (Paul Ramsey) - (GEOS 3.9+) Optional gridSize parameter to ST_Union, ST_UnaryUnion, ST_Difference, ST_Intersection, ST_SymDifference, ST_Subdivide for overlay with exact tolerance (Sandro Santilli) - #4624, ST_HexagonGrid and ST_SquareGrid, set returning functions to generate tilings of the plane (Paul Ramsey) - #4624, ST_Hexagon and ST_Square, shape generators (Paul Ramsey) - #4804, (GEOS 3.9+) ST_ReducePrecision allows valid precision reduction (Paul Ramsey) - #4710, ST_ClusterKMeans now works with 3D geometries (Darafei Praliaskouski) - #4801, ST_ClusterKMeans supports weights in POINT[Z]M geometries (Darafei Praliaskouski) - #4805, _ST_SortableHash exposed to work around parallel soring performance issue in Postgres. If your table is huge, use ORDER BY _ST_SortableHash(geom) instead of ORDER BY geom to make parallel sort faster (Darafei Praliaskouski) - #4625, Correlation statistics now calculated. Run ANALYZE for BRIN indexes to start kicking in. (Darafei Praliaskouski) - #4698, Add a precision parameter to ST_AsEWKT (Raúl Marín) * Enhancements * - #4789, Sped up TopoJSON output for areal TopoGeometry with many holes (Sandro Santilli) - #4758, Improved topology noding robustness (Sandro Santilli) - Make ST_Subdivide interruptable (Sandro Santilli) - #4660, Changes in double / coordinate printing (Raúl Marín) - Use the shortest representation (enough to guarantee roundtrip). - Uses scientific notation for absolute numbers smaller than 1e-8. The previous behaviour was to output 0 for absolute values smaller than 1e-12 and fixed notation for anything bigger than that. - Uses scientific notation for absolute numbers greater than 1e+15 (same behaviour). - The precision parameter now also affects the scientific notation (before it was fixed [5-8]). - All output functions now respect the requested precision (without any limits). - The default precision is the same (9 for GeoJSON, 15 for everything else). - #4746, Micro optimizations to the serialization process (Raúl Marín) - #4623, Optimize varlena returning functions (Raúl Marín) - #4615, Speed up geojson output (Raúl Marín) - #4737, Improve performance and reduce memory usage in ST_AsMVT, especially in queries involving parallelism (Raúl Marín) - #4719, Fail fast when srids don't match ST_Intersection(geometry,raster) Also schema qualify calls in function. (Regina Obe) - #4784, Add ST_CollectionExtract(geometry) with default behaviour of extracting the components of highest coordinate dimension. (Paul Ramsey) - #4675, topology.GetRingEdges now implemented in C (Sandro Santilli) - #4672, Cache getSRSbySRID and getSRIDbySRS for better performance (Raúl Marín) - #4676, #4657 Avoid decompressing toasted geometries to read only the header (Raúl Marín) - #4677, Share gserialized objects between different cache types (Raúl Marín) - #4601, Add ST_TileEnvelope margin argument (Yuri Astrakhan) - #2972, Add quiet mode (-q) to pgsql2shp (Kristian Thy) - #3057, Optional value params for Force3D*, Force4D functions (Kristian Thy) - #4569, Allow unknown SRID geometry insertion into typmod SRID column (Paul Ramsey) - #4149, ST_Simplify(geom, 0) is now O(N). ST_Affine (ST_Translate, ST_TransScale, ST_Rotate) optimized. ST_SnapToGrid optimized. (Darafei Praliaskouski) - #4656, Cast a geojson_text::geometry for implicit GeoJSON ingestion (Raúl Marín)
2020-12-18py-sqlalchemy: updated to 1.3.21adam2-7/+7
1.3.21 orm [orm] [bug] Added a comprehensive check and an informative error message for the case where a mapped class, or a string mapped class name, is passed to relationship.secondary. This is an extremely common error which warrants a clear message. Additionally, added a new rule to the class registry resolution such that with regards to the relationship.secondary parameter, if a mapped class and its table are of the identical string name, the Table will be favored when resolving this parameter. In all other cases, the class continues to be favored if a class and table share the identical name. [orm] [bug] Fixed bug in Query.update() where objects in the _ormsession.Session that were already expired would be unnecessarily SELECTed individually when they were refreshed by the “evaluate”synchronize strategy. [orm] [bug] Fixed bug involving the restore_load_context option of ORM events such as InstanceEvents.load() such that the flag would not be carried along to subclasses which were mapped after the event handler were first established. sql [sql] [bug] A warning is emmitted if a returning() method such as Insert.returning() is called multiple times, as this does not yet support additive operation. Version 1.4 will support additive operation for this. Additionally, any combination of the Insert.returning() and ValuesBase.return_defaults() methods now raises an error as these methods are mutually exclusive; previously the operation would fail silently. [sql] [bug] Fixed structural compiler issue where some constructs such as MySQL / PostgreSQL “on conflict / on duplicate key” would rely upon the state of the Compiler object being fixed against their statement as the top level statement, which would fail in cases where those statements are branched from a different context, such as a DDL construct linked to a SQL statement. postgresql [postgresql] [usecase] Added new parameter ExcludeConstraint.ops to the ExcludeConstraint object, to support operator class specification with this constraint. Pull request courtesy Alon Menczer. [postgresql] [bug] [mysql] Fixed regression introduced in 1.3.2 for the PostgreSQL dialect, also copied out to the MySQL dialect’s feature in 1.3.18, where usage of a non Table construct such as text() as the argument to Select.with_for_update.of would fail to be accommodated correctly within the PostgreSQL or MySQL compilers. mysql [mysql] [bug] [reflection] Fixed issue where reflecting a server default on MariaDB only that contained a decimal point in the value would fail to be reflected correctly, leading towards a reflected table that lacked any server default. [mysql] [sql] Added missing keywords to the RESERVED_WORDS list for the MySQL dialect: action, level, mode, status, text, time. Pull request courtesy Oscar Batori. sqlite [sqlite] [usecase] Added sqlite_with_rowid=False dialect keyword to enable creating tables as CREATE TABLE … WITHOUT ROWID. Patch courtesy Sean Anderson. mssql [mssql] [bug] Fixed bug where a CREATE INDEX statement was rendered incorrectly when both mssql-include and mssql_where were specified. Pull request courtesy @Adiorz. [mssql] [bug] Added SQL Server code “01000” to the list of disconnect codes. [mssql] [reflection] [sqlite] Fixed issue with composite primary key columns not being reported in the correct order. Patch courtesy @fulpm. oracle [oracle] [usecase] Implemented support for the SERIALIZABLE isolation level for Oracle databases, as well as a real implementation for Connection.get_isolation_level().
2020-12-10prometheus: updated to 2.23.0adam2-7/+7
2.23.0: [CHANGE] UI: Make the React UI default. [CHANGE] Remote write: The following metrics were removed/renamed in remote write. prometheus_remote_storage_succeeded_samples_total was removed and prometheus_remote_storage_samples_total was introduced for all the samples attempted to send. prometheus_remote_storage_sent_bytes_total was removed and replaced with prometheus_remote_storage_samples_bytes_total and prometheus_remote_storage_metadata_bytes_total. prometheus_remote_storage_failed_samples_total -> prometheus_remote_storage_samples_failed_total . prometheus_remote_storage_retried_samples_total -> prometheus_remote_storage_samples_retried_total. prometheus_remote_storage_dropped_samples_total -> prometheus_remote_storage_samples_dropped_total. prometheus_remote_storage_pending_samples -> prometheus_remote_storage_samples_pending. [CHANGE] Remote: Do not collect non-initialized timestamp metrics. [FEATURE] [EXPERIMENTAL] Remote write: Allow metric metadata to be propagated via remote write. The following new metrics were introduced: prometheus_remote_storage_metadata_total, prometheus_remote_storage_metadata_failed_total, prometheus_remote_storage_metadata_retried_total, prometheus_remote_storage_metadata_bytes_total. [ENHANCEMENT] Remote write: Added a metric prometheus_remote_storage_max_samples_per_send for remote write. [ENHANCEMENT] TSDB: Make the snapshot directory name always the same length. [ENHANCEMENT] TSDB: Create a checkpoint only once at the end of all head compactions. [ENHANCEMENT] TSDB: Avoid Series API from hitting the chunks. [ENHANCEMENT] TSDB: Cache label name and last value when adding series during compactions making compactions faster. [ENHANCEMENT] PromQL: Improved performance of Hash method making queries a bit faster. [ENHANCEMENT] promtool: tsdb list now prints block sizes. [ENHANCEMENT] promtool: Calculate mint and maxt per test avoiding unnecessary calculations. [ENHANCEMENT] SD: Add filtering of services to Docker Swarm SD. [BUGFIX] React UI: Fix button display when there are no panels. [BUGFIX] PromQL: Fix timestamp() method for vector selector inside parenthesis. [BUGFIX] PromQL: Don't include rendered expression on PromQL parse errors. [BUGFIX] web: Fix panic with double close() of channel on calling /-/quit/. [BUGFIX] TSDB: Fixed WAL corruption on partial writes within a page causing invalid checksum error on WAL replay. [BUGFIX] Update config metrics prometheus_config_last_reload_successful and prometheus_config_last_reload_success_timestamp_seconds right after initial validation before starting TSDB. [BUGFIX] promtool: Correctly detect duplicate label names in exposition.
2020-12-10Updated databases/pgocaml to 4.2.2.jaapb4-25/+25
Changes are minor, mostly compatibility-related.
2020-12-09py-mongo: updated to 3.11.2adam3-8/+26
Changes in Version 3.11.2 Issues Resolved Version 3.11.2 includes a number of bugfixes. Highlights include: Fixed a memory leak caused by failing SDAM monitor checks on Python 3 (PYTHON-2433). Fixed a regression that changed the string representation of BulkWriteError (PYTHON-2438). Fixed a bug that made it impossible to use bson.codec_options.CodecOptions.with_options() and with_options() on some early versions of Python 3.4 and Python 3.5 due to a bug in the standard library implementation of collections.namedtuple._asdict() (PYTHON-2440). Fixed a bug that resulted in a TypeError exception when a PyOpenSSL socket was configured with a timeout of None (PYTHON-2443). Changes in Version 3.11.1 Version 3.11.1 adds support for Python 3.9 and includes a number of bugfixes. Highlights include: Support for Python 3.9. Initial support for Azure and GCP KMS providers for client side field level encryption is in beta. See the docstring for MongoClient, AutoEncryptionOpts, and encryption. Note: Backwards-breaking changes may be made before the final release. Fixed a bug where the bson.json_util.JSONOptions API did not match the bson.codec_options.CodecOptions API due to the absence of a bson.json_util.JSONOptions.with_options() method. This method has now been added. Fixed a bug which made it impossible to serialize BulkWriteError instances using pickle. Fixed a bug wherein PyMongo did not always discard an implicit session after encountering a network error. Fixed a bug where connections created in the background were not authenticated. Fixed a memory leak in the bson module when using a TypeRegistry. Changes in Version 3.11.0 Version 3.11 adds support for MongoDB 4.4 and includes a number of bug fixes. Highlights include: Support for OCSP (Online Certificate Status Protocol). Support for PyOpenSSL as an alternative TLS implementation. PyOpenSSL is required for OCSP support. It will also be installed when using the “tls” extra if the version of Python in use is older than 2.7.9. Support for the MONGODB-AWS authentication mechanism. Support for the directConnection URI option and kwarg to MongoClient. Support for speculative authentication attempts in connection handshakes which reduces the number of network roundtrips needed to authenticate new connections on MongoDB 4.4+. Support for creating collections in multi-document transactions with create_collection() on MongoDB 4.4+. Added index hinting support to the replace_one(), update_one(), update_many(), find_one_and_replace(), find_one_and_update(), delete_one(), delete_many(), and find_one_and_delete() commands. Added index hinting support to the ReplaceOne, UpdateOne, UpdateMany, DeleteOne, and DeleteMany bulk operations. Added support for bson.binary.UuidRepresentation.UNSPECIFIED and MongoClient(uuidRepresentation='unspecified') which will become the default UUID representation starting in PyMongo 4.0. See Handling UUID Data for details. Added the background parameter to pymongo.database.Database.validate_collection(). For a description of this parameter see the MongoDB documentation for the validate command. Added the allow_disk_use parameters to pymongo.collection.Collection.find(). Added the hedge parameter to PrimaryPreferred, Secondary, SecondaryPreferred, Nearest to support disabling (or explicitly enabling) hedged reads in MongoDB 4.4+. Fixed a bug in change streams that could cause PyMongo to miss some change documents when resuming a stream that was started without a resume token and whose first batch did not contain any change documents. Fixed an bug where using gevent.Timeout to timeout an operation could lead to a deadlock. Deprecations: Deprecated the oplog_replay parameter to pymongo.collection.Collection.find(). Starting in MongoDB 4.4, the server optimizes queries against the oplog collection without requiring the user to set this flag. Deprecated pymongo.collection.Collection.reindex(). Use command() to run the reIndex command instead. Deprecated pymongo.mongo_client.MongoClient.fsync(). Use command() to run the fsync command instead. Deprecated pymongo.mongo_client.MongoClient.unlock(). Use command() to run the fsyncUnlock command instead. See the documentation for more information. Deprecated pymongo.mongo_client.MongoClient.is_locked. Use command() to run the currentOp command instead. See the documentation for more information. Unavoidable breaking changes: GridFSBucket and GridFS do not support multi-document transactions. Running a GridFS operation in a transaction now always raises the following error: InvalidOperation: GridFS does not support multi-document transactions
2020-12-08repmgr: updated to 5.2.1adam4-25/+38
repmgr 5.2.1 is a minor release. A.1.1. Improvements repmgr standby clone: option --recovery-min-apply-delay added, overriding any setting present in repmgr.conf. A.1.2. Bug fixes Configuration: fix parsing of replication_type configuration parameter. repmgr standby clone: handle case where postgresql.auto.conf is absent on the source node. repmgr standby clone: in PostgreSQL 11 and later, an existing data directory's permissions will not be changed to 0700 if they are already set to 0750. repmgrd: prevent termination when local node not available and standby_disconnect_on_failover is set. repmgrd: ensure reconnect_interval is correctly handled. repmgr witness --help: fix witness unregister description.
2020-12-07slony1: updated to 2.2.10adam2-7/+7
Slony 2.2.10 now available The next bug fix release in the 2.2.x series is now available. This release includes the following * Remove unsupported warning with PG13
2020-12-07py-multidict: updated to 5.1.0adam2-7/+7
5.1.0 (2020-12-03) ================== Features -------- - Support ``GenericAliases`` (``MultiDict[str]``) for Python 3.9+ Bugfixes -------- - Synchronize the declared supported Python versions in ``setup.py`` with actually supported and tested ones.
2020-12-06py-whisper: updated to 1.1.7adam3-10/+15
1.1.7: Graphite release 1.1.7 1.1.6: Graphite release 1.1.6 * set package long description * Dump as raw values
2020-12-06slony1: updated to 2.2.9adam2-7/+7
Slony 2.2.9 now available The next bug fix release in the 2.2.x series is now available. This release includes the following * fix slonik_build_env.pl so it works with PG11+ * Remove unsupported warning with PG12 * Fix compiler warnings with -fno-common
2020-12-06py-pypika: updated to 0.44.1adam2-7/+7
0.44.1: Unknown changes
2020-12-05databases: Add postgresql-wal2json 2.3otis5-1/+47
wal2json is an output plugin for logical decoding. It means that the plugin have access to tuples produced by INSERT and UPDATE. Also, UPDATE/DELETE old row versions can be accessed depending on the configured replica identity. Changes can be consumed using the streaming protocol (logical replication slots) or by a special SQL API.
2020-12-04Revbump packages with a runtime Python dep but no version prefix.nia16-30/+32
For the Python 3.8 default switch.
2020-12-04Revbump for openpam cppflags change months ago, belatedly.riastradh45-53/+90
2020-12-03mongodb: updated to 4.2.11adam2-8/+7
4.2.11: Issues fixed in 4.2.11: SERVER-43664: Speedup WiredTiger storage engine startup for many tables by optimizing WiredTigerUtil::setTableLogging() SERVER-45938: Allow matching O/OU/DC in client x509 cert if clusterMode:keyFile SERVER-48523: Unconditionally check the first entry in the oplog when attempting to resume a change stream SERVER-51120: Find queries with SORT_MERGE incorrectly sort the results when the collation is specified WT-6507: Exit cache eviction worker after our operation has timed out All JIRA issues closed in 4.2.11 4.2.10: Issues fixed in 4.2.10: SERVER-26726: Check number of arguments for createIndex() and throw error if more than two arguments SERVER-31368: Log time spent waiting for other shards in merge cursors aggregation stage SERVER-37422: Log balancer start and stop events in the actionlog SERVER-40317: $facet execution has no limit on how much memory it can consume SERVER-43233: Add ability to request only specific attribute(s) for the LDAP groups SERVER-47469: applyOps does not take exclusive lock for views operation SERVER-50463: Make PooledLDAPConnection::refresh take self-ownership SERVER-51041: Throttle starting transactions for secondary reads All JIRA issues closed in 4.2.10 4.2.9: Issues fixed in 4.2.9: SERVER-44051: getShardDistribution() does not report “Collection XYZ is not sharded” on dropped but previously sharded collections SERVER-45610: Some reads work while system is RECOVERING SERVER-47714: Secondary asserts on system.profile collection with WiredTigerRecordStore::insertRecord 95: Operation not supported SERVER-48067: Reduce memory consumption for unique index builds with large numbers of non-unique keys SERVER-49233: Introduce a flag to toggle the logic for bumping collection’s major version during split WT-6480: Fix a bug where files without block modification information were repeatedly copied at each incremental backup All JIRA issues closed in 4.2.9 4.2.8: Issues fixed in 4.2.8: SERVER-46897: REMOVED node may never send heartbeat to fetch newest config SERVER-47799: AsyncRequestsSender should update replica set monitor in between retries for InterruptedAtShutdown SERVER-47994: Fix for numerical overflow in GeoHash SERVER-48307: 3 Transactions that write to exactly one shard and read from one or more other shards may incorrectly indicate failure on retry after successful commit WT-6366: Off-by-one overflow in block-modification bitmaps for incremental backup All JIRA issues closed in 4.2.8
2020-12-03mongo-c-driver: updated to 1.17.3adam3-9/+15
mongo-c-driver 1.17.3 ===================== Bug fixes: * Do not send session ID on GSSAPI auth commands. * Fix build against zlib when zlib is installed in non-standard location. * Fix build when source directory path contains a space. * Fix a platform-specific bug causing mongoc_client_pool_pop to block indefinitely if all clients are checked out. * Fix a possible buffer overflow with hostnames resolving to IPv6 addresses on OpenSSL. mongo-c-driver 1.17.2 ===================== Bug fixes: * Stop the SRV polling thread when an SRV URI is used to connect to a deployment other than a sharded cluster. mongo-c-driver 1.17.1 ===================== Bug fixes: * Fix SRV/TXT record lookup for DNS records exceeding 1024 bytes. mongo-c-driver 1.17.0 ===================== This release adds support for MongoDB 4.4 servers. Features: * Support streamable server monitoring to reduce recovery time when the server topology changes. * Support the MONGODB-AWS authentication mechanism. * Support Online Certificate Status Protocol (OCSP). * Support configuring hedged reads in read preferences. * Reduce the number of round trips necessary for SCRAM and X509 authentication. * Monitor servers in parallel when using a mongoc_client_pool_t instead of doing serial scans. * Support the "hint" option in operations using the update, replace, delete, and findAndModify commands. * Improve behavior for retryable writes. * Improve resuming behavior of change streams on server errors. * Remove restriction of 255 character collection namespaces. Bug fixes: * Fix criteria for resumable errors in change streams. * Fix rare crashes when server is invalidated during authentication. * Reject client session for mongoc_collection_estimated_document_count. * Fix behavior of a SecondaryPreferred read preference for exhaust cursor operations against a sharded cluster. Prior to the fix, a nonzero maxStalenessSeconds would not trigger sending the read preference. * Fix SRV polling. Prior to the fix, SRV polling did not properly apply newly discovered results. * Fix checks for existing GridFS indexes to handle indexes created by the MongoDB shell. * Fix possible use of invalidated streams during an unordered OP_QUERY bulk write, and when ending many pooled sessions at client destruction. * Fix a crash when setting the crl_file TLS option for Secure Channel. * Avoid emitting duplicate ServerChanged events when no change is observed during monitoring. * Properly handle large SASL messages instead of erroring. Notes: * Deprecated "lib" prefixed artifacts are no longer produced when building on Windows.
2020-12-02sqlite3: updated to 3.34.0adam7-97/+24
SQLite Release 3.34.0 Added the sqlite3_txn_state() interface for reporting on the current transaction state of the database connection. Enhance recursive common table expressions to support two or more recursive terms as is done by SQL Server, since this helps make queries against graphs easier to write and faster to execute. Improved error messages on CHECK constraint failures. CLI enhancements: The .read dot-command now accepts a pipeline in addition to a filename. Added options --data-only and --nosys to the .dump dot-command. Added the --nosys option to the .schema dot-command. Table name quoting works correctly for the .import dot-command. The generate_series(START,END,STEP) table-valued function extension is now built into the CLI. The .databases dot-command now show the status of each database file as determined by sqlite3_db_readonly() and sqlite3_txn_state(). Added the --tabs command-line option that sets .mode tabs. The --init option reports an error if the file named as its argument cannot be opened. The --init option also now honors the --bail option. Query planner improvements: Improved estimates for the cost of running a DISTINCT operator. When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks. The new OP_SeekScan opcode is used to improve performance of multi-column index look-ups when later columns are constrained by an IN operator. The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even if one or more attached database files are read-only. Enhanced FTS5 to support trigram indexes. Improved performance of WAL mode locking primitives in cases where there are hundreds of connections all accessing the same database file at once. Enhanced the carray() table-valued function to include a single-argument form that is bound using the auxiliary sqlite3_carray_bind() interface. The substr() SQL function can now also be called "substring()" for compatibility with SQL Server. The syntax diagrams are now implemented as Pikchr scripts and rendered as SVG for improved legibility and ease of maintenance.
2020-11-27py-bsddb3: updated to 6.2.9adam2-7/+7
6.2.9: * For some reason, 6.2.8 release was incomplete. Let's try again.
2020-11-26py-bsddb3: updated to 6.2.8adam2-7/+7
6.2.8: * In Python 3.9, "find_unused_port" has been moved to "test.support.socket_helper". Reported by Michał Górny. * If we use "set_get_returns_none()" in the environment, the value could not be correctly inherited by the child databases. Reported by Patrick Laimbock and modern GCC warnings. * If you install this library under Python 3 >= 3.6, let you know this is a legacy library and points you to "berkeleydb" library.
2020-11-25postgis: Update to 3.0.3gdt5-11/+17
Packaging changes: make bl3 refer to PGSQL_VERSION, not 12, reverting an earlier change labeled "revbump" which does not make sense for such a change. Upstream changes: bugfixes
2020-11-23kyotocabinet: Update to 1.2.78nia2-9/+9
2020-07-20 FAL Labs <info@fallabs.com> - Fixed build warnings. - Release: 1.2.78
2020-11-22mysql-workbench: Disable gnome-keyring dependency in BROKEN packagenia1-2/+2
2020-11-21py-pymysql: updated to 0.10.1adam3-8/+9
v0.10.1 * Fix missing import of ProgrammingError. * Fix auth switch request handling.
2020-11-19Remove DJB_RESTRICTED, no longer used.schmonz1-3/+1
2020-11-19gdbm: reflect shlib major bumpgutteridge1-2/+2
(This was missed during the last update to this package almost three months ago, so no point in doing a dependent PKGREVISION bump now.)
2020-11-17Reset PKGREVISIONadam1-2/+1
2020-11-17py-tortoise-orm: updated to 0.16.18adam3-13/+15
0.16.18 Support custom function in update. Add Model.refresh_from_db. Add timezone support, be careful to upgrade to this version, see docs for details. Remove aerich in case of cyclic dependency.
2020-11-17py-pypika: updated to 0.44.0adam2-7/+7
0.44.0: Unknown changes
2020-11-17prometheus: updated to 2.22.2adam2-7/+7
2.22.2: [BUGFIX] Fix race condition in syncing/stopping/reloading scrapers.
2020-11-16py-multidict: updated to 5.0.2adam2-7/+7
multidict 5.0.2 release Fox a bug in release process, upload x86 Windows wheels multidict 5.0.1 release Bugfixes Provide x86 Windows wheels
2020-11-16postgresql: updated to 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24adam73-157/+144
PostgreSQL 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 Security Issues * CVE-2020-25695: Multiple features escape "security restricted operation" sandbox * CVE-2020-25694: Reconnection can downgrade connection security settings * CVE-2020-25696: psql's \gset allows overwriting specially treated variables Bug Fixes and Improvements This update also fixes over 65 bugs that were reported in the last several months. Some of these issues only affect version 13, but may also apply to other supported versions. Some of these fixes include: Fix a breakage in the replication protocol by ensuring that two "command completion" events are expected for START_REPLICATION. Ensure fsync is called on the SLRU caches that PostgreSQL maintains. This prevents potential data loss due to an operating system crash. Fix ALTER ROLE usage for users with the BYPASSRLS permission. ALTER TABLE ONLY ... DROP EXPRESSION is disallowed on partitioned tables when there are child tables. Ensure that ALTER TABLE ONLY ... ENABLE/DISABLE TRIGGER does not apply to child tables. Fix for ALTER TABLE ... SET NOT NULL on partitioned tables to avoid a potential deadlock in parallel pg_restore. Fix handling of expressions in CREATE TABLE LIKE with inheritance. DROP INDEX CONCURRENTLY is disallowed on partitioned tables. Allow LOCK TABLE to succeed on a self-referential view instead of throwing an error. Several fixes around statistics collection and progress reporting for REINDEX CONCURRENTLY. Ensure that GENERATED columns are updated when any columns they depend on are updated via a rule or an updatable view. Support hash partitioning with text array columns as partition keys. Allow the jsonpath .datetime() method to accept ISO 8601-format timestamps. During a "smart" shutdown, ensure background processes are not terminated until all foreground client sessions are completed, fixing an issue that broke the processing of parallel queries. Several fixes for the query planner and optimizer. Ensure that data is de-toasted before being inserted into a BRIN index. This could manifest itself with errors like "missing chunk number 0 for toast value NNN". If you have seen a similar error in an existing BRIN index, you should be able to correct it by using REINDEX on the index. Fix the output of EXPLAIN to have the correct XML tag nesting for incremental sort plans. Several fixes for memory leaks, including ones involving RLS policies, using CALL with PL/pgSQL, SIGHUP processing a configuration parameter that cannot be applied without a restart, and an edge-case for index lookup for a partition. libpq can now support arbitrary-length lines in the .pgpass file. On Windows, psql now reads the output of a backtick command in text mode, not binary mode, so it can now properly handle newlines. Fix how pg_dump, pg_restore, clusterdb, reindexdb, and vacuumdb use complex connection-string parameters. When the \connect command of psql reuses connection parameters, ensure that all non-overridden parameters from a previous connection string are also re-used. Ensure that pg_dump collects per-column information about extension configuration tables, avoiding crashes when specifying --inserts. Ensure that parallel pg_restore processes foreign keys referencing partitioned tables in the correct order. Several fixes for contrib/pgcrypto, including a memory leak fix.
2020-11-13Revbump all Go packages after go115 updatebsiegert8-15/+16
2020-11-13kyotocabinet: Needs 64-bit atomic ops on powerpcnia1-1/+5
2020-11-12sqlitebrowser: updated to 3.12.1adam2-8/+7
DB Browser for SQLite 3.12.1 This is the first bug fix release for our 3.12.x series. There aren't any "super critical must upgrade" bugs fixed, so updating isn't urgent. 😄 The changes in this over the 3.12.0 release include: Enhancements Completely reworked interface for accessing DBHub.io Add .Net DateTime.Ticks to list of supported display formats Add more options for setting font sizes New predefined settings for simplified window layout Bug fixes Fix loading of project files with empty filter values Fix initial table view when using the -t / --table command line option Add status message when opening a file from the recent file list (4dfe4f7) Make sure to not show "NULL" for empty but non-NULL values in the Edit dialog Fix plot being drawn before all data is loaded Restore original default for having condition format in filter line (f28ecc0) Fix default font in the format toolbar (c4b2ffc) Improve binary detection for cases starting by chance by a BOM Make sure the order of the statements in the SQL log is correct (05db901) Fix executing selected SQL text when there are multi-byte characters Fix executing SQL queries with compound operators Fix SQL import of files with BOM Also update schema when clicking the Refresh button in Browse Data tab (16c3d8d) Select column in table results when column header is pressed Tweak the output wording for command line options Remove the default property of the cancel button in the "Fetching data..." dialog Fix not being saved and not applied when modifying database cells in Windows external program (f2d8f79) Fix incorrect display of SQL calltips containing non-US-ASCII characters (9f7851b) Fix to 'Window Layout' options work properly Building and packaging Fix CMake warning during compilation (115aa00) snap: Add environment variables to set Qt theme (7b5d652) Updated to OpenSSL 1.1.1h for the Windows and macOS builds Platform specific No longer force Light theme on macOS when "Follow the desktop style" is chosen (508118f) Keep registry key consistent on Windows Allow use of integrated graphics card instead of high performance graphics card in macOS Use native path separators in Preferences dialog (f38b829) Added message box for informative command line arguments for Windows
2020-11-12postgresql13-contrib: PLIST fix for uuidadam1-2/+1
2020-11-12prometheus: updated to 2.22.1adam2-8/+7
2.22.1 * [BUGFIX] Fix potential "mmap: invalid argument" errors in loading the head chunks, after an unclean shutdown, by performing read repairs. * [BUGFIX] Fix serving metrics and API when reloading scrape config. * [BUGFIX] Fix head chunk size calculation for size based retention.
2020-11-12ldb: updated to 2.2.0adam2-7/+7
2.2.0: Unknown changes
2020-11-11databases/guile-pg: Update to 0.48gdt3-11/+12
pkgsrc: changes: re-enable .la There are some test issues, but it seems better to move to 0.48 than stay at 0.47. If you are a pkgsrc user of guile-pg and disagree, please speak up (and help test/fix!). - 0.48 | 2020-10-26 - installation by default deletes the .la files See README re "SOFIXFLAGS". - configuration changes - configure script tries to use pkg-config(1) The configure script now tries to use pkg-config(1) to determine directory values for the ‘-I’ and ‘-L’ compiler switches. The standard way is still supported (see README). - configure-time ‘INITDB’ specification For "make check", you can specify to the configure script the initdb(1) program to use with option ‘INITDB=/path/to/initdb’. For example: ./configure INITDB=/usr/lib/postgresql/9.4/bin/initdb This saves the value of ‘INITDB’ so you don't need to specify it manually for each "make check" invocation (see README). - builtin array variant types now have prefix-asterisk names Previously, the builtin array variant types had names that end in "[]" (i.e., one or more pairs of square braces). These now have prefix-asterisk names. (was) (now) text[] *text text[][] **text int4[] *int4 aclitem[] *aclitem Furthermore, old-style names are no longer supported. This is concomitant w/ dropping of ‘define-db-col-type-array-variant’ (see below). - dropped items All these were announced in Guile-PG 0.47 (2015-02-23). - module ‘(database postgres-resdisp)’ - proc ‘(database postgres) pg-lo-read’ - procs in module ‘(database postgres-types)’ - ‘dbcoltypes’ - ‘dbcoltype-lookup’ - ‘dbcoltype:stringifier’ - ‘dbcoltype:default’ - ‘dbcoltype:objectifier’ - ‘define-db-col-type-array-variant’
2020-11-11phpmyadmin: update to 4.9.7tm3-11/+11
4.9.7 (2020-10-15) - issue #16397 Fix compatibility problems with older PHP versions (also issue #16399) - issue #16396 Fix broken two-factor authentication 4.9.6 (2020-10-09) - issue [security] Fix XSS vulnerability with the transformation feature (PMASA-2020-5) - issue [security] Fix SQL injection vulnerability with search feature (PMASA-2020-6)
2020-11-11openldap: updated to 2.4.56adam5-18/+20
OpenLDAP 2.4.56 Fixed slapd to remove assert in certificateListValidate Fixed slapd to remove assert in csnNormalize23 Fixed slapd to better parse ldapi listener URIs
2020-11-09py-peewee: updated to 3.14.0adam3-11/+10
3.14.0 This release has been a bit overdue and there are numerous small improvements and bug-fixes. The bugfix that prompted this release is 2293, which is a regression in the Django-inspired .filter() APIs that could cause some filter expressions to be discarded from the generated SQL. Many thanks for the excellent bug report, Jakub. Add an experimental helper, shortcuts.resolve_multimodel_query(), for resolving multiple models used in a compound select query. Add a lateral() method to select query for use with lateral joins. Added support for nested transactions (savepoints) in cockroach-db (requires 20.1 or newer). Automatically escape wildcards passed to string-matching methods. Allow index-type to be specified on MySQL. Added a new API, converter() to be used for specifying a function to use to convert a row-value pulled off the cursor. Add set() and clear() method to the bitfield flag descriptor. Add support for range types with IN and other expressions. Support CTEs bound to compound select queries. Bug-fixes Fix to return related object id when accessing via the object-id descriptor, when the related object is not populated. Fix to ensure we do not insert a NULL value for a primary key. Fix to conditionally set the field/column on an added column in a migration. Apply field conversion logic to model-class values. Clone node before modifying it to be flat in an enclosed nodelist expr. Fix an invalid item assignment in nodelist. Fix an incorrect truthiness check used with save() and only=. Fix regression in filter() where using both *args and **kwargs caused the expressions passed as args to be discarded.
2020-11-08Revbump all Go packages after Go 1.15 update.bsiegert8-15/+16
2020-11-06postgresql11: Fix build with ICU 68otis2-1/+17