Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAkrL-005g4M-Jh for pgsql-announce@arkaria.postgresql.org; Mon, 20 Oct 2025 08:03:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vAkrK-00FJWt-IG for pgsql-announce@arkaria.postgresql.org; Mon, 20 Oct 2025 08:03:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAkrJ-00FJWf-LJ for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 08:03:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vAkrD-003Bq0-1X for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 08:03:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=P4hoMWaUMinPanVq+t9Q0T8P6oX6kcC9rrauuS631HU=; b=u63IMMJ/hg2+FPxaIazDti3qO2 eo6eUlEUi8Mjpt8mPl6XfNJvsdy/FXBAdK3ff/cQl0GCE8OT364WuUI2IyzTMoKqEpij7sSF27cEu TapKU/enLTK+aFZXhDdsIm+wA8ZPHX06dUv6x9oNnAobQC+RjvQvJ0IbnmAJzbtdQxcyCqRAUfqr0 9ZJI/ToH+7r3UczK3M5RZrHJPgEPWL4esm41X+62IdOmh+d+fZlA5eTDzntYD+EMOgVUGcOSrOEH0 FQFL/hFLSG+SL6CfZOLdB5tmw1quURGF3EVD6kuHz2jl+CriIq4UmMuSiYTHN8HMZKZtlLQWW8YBI I3UAPJ4g==; Received: from wrigleys.postgresql.org ([217.196.149.60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAkrC-002jkC-8Z for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 08:03:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vAkr9-008hXJ-04 for pgsql-announce@lists.postgresql.org; Mon, 20 Oct 2025 08:03:03 +0000 Content-Type: multipart/mixed; boundary="===============2585712398298985805==" MIME-Version: 1.0 Subject: Announcing the release of AgensGraph v2.16.0 To: PostgreSQL Announce From: "SKAI Worldwide (formerly Bitnine) via PostgreSQL Announce" Reply-To: umar.hayat@skaiworldwide.com Date: Mon, 20 Oct 2025 08:02:48 +0000 Message-ID: <176094736872.770.13418405380925044271@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: community,proprietary,related X-pglister-tagsig: 5bd3bbc854e6a8bb534526b2d7b18b5f592e3d8ee085299db930e3992455ed0c List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2585712398298985805== Content-Type: multipart/alternative; boundary="===============3778053515352029484==" MIME-Version: 1.0 --===============3778053515352029484== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable The AgensGraph Development Team is pleased to announce the release of Agens= Graph v2.16.0 AgensGraph is a new generation multi-model graph database for the modern co= mplex data environment. AgensGraph is a multi-model database, which support= s the relational and graph data model at the same time that enables develop= ers to integrate the legacy relational data model and the flexible graph da= ta model in one database. AgensGraph supports ANSI-SQL and [openCypher](htt= p://www.opencypher.org) and partially ISO/GQL. SQL queries and Cypher queri= es can be integrated into a single query in AgensGraph. AgensGraph is based on the powerful PostgreSQL RDBMS, and is very robust, f= ully-featured and ready for enterprise use. AgensGraph is optimized for han= dling complex connected graph data and provides plenty of powerful database= features essential to the enterprise database environment including ACID t= ransactions, multi-version concurrency control, stored procedure, triggers,= constraints, sophisticated monitoring and a flexible data model (JSON). Mo= reover, AgensGraph leverages the rich eco-systems of PostgreSQL and can be = extended with many outstanding external modules, like PostGIS, pgvector and= AI extensions. For more details please see the [release notes](https://tech.skaiworldwide.= com/docs/en/agensgraph/latest/release_notes/agensgraph_release_notes_2_16_0= .html). ## Major Improvements in AgensGraph v2.16.0 This release of AgensGraph brings significant enhancements and bug fixes, i= ncluding upstream compatibility with PostgreSQL 16.9, improved Cypher query= support, and AI integration updates. ### Upstream Changes * **Upstream Merge:** AgensGraph is now compatible with [PostgreSQL 16](htt= ps://www.postgresql.org/docs/release/16.0/) up to the 16.9 release, incorpo= rating the latest PostgreSQL improvements and security patches. * **Parallel FULL and RIGHT/OUTER Hash Joins:** Added support for parallel = execution of `FULL` and internal `RIGHT OUTER` hash joins, improving perfor= mance on large join queries. * **SQL/JSON Standard Functions:** New SQL/JSON features such as `JSON_ARRA= Y()`, `JSON_ARRAYAGG()`, `JSON_OBJECT()`, and `JSON_EXISTS()` provide more = standard-compliant JSON processing. * **Vacuum Freezing Improvements:** Reduced overhead for vacuum operations = and smarter freezing strategy lowers maintenance costs on large tables. ### Enhancements * **Allow Row Level Security Policies to work with cypher queries:** Enabl= es row-level access using user-defined policies, useful for enforcing data = security and managing permissions in database administration. * **Add meta extension for agensgraph:** Collection of helper functions fo= r AgensGraph that simplify working with graph metadata. * **Improve interoperability with extensions:** Enhances compatibility wit= h other PostgreSQL extensions, such as pgvector, enabling smoother integrat= ion within cypher queries. ### AI Library You can access those products at the [AI Repository](https://github.com/ska= iworldwide-oss/agensgraph-ai) * **LangChain AgensGraph: ** Python plugin for GraphStore and VectorStore i= ntegration in `langchain`. * **LlamaIndex AgensGraph:** Python plugin for AgensGraphStore, PropertyGra= phIndex, AgensgraphVectorStore integration in `llamaindex`. * **AgensGraph LightRag:** Python plugin for storing and querying knowledge= graphs in AgensGraph with `LightRAG`. * **Cognee Community Graph Adapter - AgensGraph: ** Python plugin to provid= e an AgensGraph graph database adapter for the `Cognee` framework. * **AgensGraph MCP Server:** A Model Context Protocol (MCP) server implemen= tation that provides database interaction and allows graph exploration capa= bilities through AgensGraph. ### Bug Fixes * **ACL logic to the ModifyGraph:** ACL check logic was previously in the E= xecDeleteGraph function, but it was not specific to that operation. It has = now been moved to ExecInitModifyGraph. * **Crash and errors on some cases of non-existent labels:** The server wou= ld crash or error out if a non-existent label was used in MATCH/MERGE claus= e for some cases. * **Crash on variable reuse in MERGE clause:** The server would crash if an= already declared variable from the previous clauses is referenced in MERGE= clause. * **Alter the default expression to column properties** * In the dumping action, the default column properties were not properl= y set. Now it'll set the default column property after the dump properly. * **Invalid label numbering after RENAME command:** After executing the ALT= ER LABEL RENAME command, the target label ID was not properly updated when = inserting into that label. It will now correctly follow the proper label ID. * **fix: Columns not visible when using a VLE:** Variable used VLE expressi= on is not visible in subsequent transformation. The new version is immediately available for [download](https://tech.skaiwo= rldwide.com/downloads/#agensgraph). --===============3778053515352029484== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Announcing the release of AgensGraph v2.16.0
 

Announcing the release of AgensGraph v2.16.0

The AgensGraph Development Team is pleased = to announce the release of AgensGraph v2.16.0

AgensGraph is a new generation multi-model = graph database for the modern complex data environment. AgensGraph is a mul= ti-model database, which supports the relational and graph data model at th= e same time that enables developers to integrate the legacy relational data= model and the flexible graph data model in one database. AgensGraph suppor= ts ANSI-SQL and openCypher and partially ISO/GQL. SQL q= ueries and Cypher queries can be integrated into a single query in AgensGra= ph.

AgensGraph is based on the powerful Postgre= SQL RDBMS, and is very robust, fully-featured and ready for enterprise use.= AgensGraph is optimized for handling complex connected graph data and prov= ides plenty of powerful database features essential to the enterprise datab= ase environment including ACID transactions, multi-version concurrency cont= rol, stored procedure, triggers, constraints, sophisticated monitoring and = a flexible data model (JSON). Moreover, AgensGraph leverages the rich eco-s= ystems of PostgreSQL and can be extended with many outstanding external mod= ules, like PostGIS, pgvector and AI extensions.

For more details please see the release notes.

Major Improvements in AgensGrap= h v2.16.0

This release of AgensGraph brings significa= nt enhancements and bug fixes, including upstream compatibility with Postgr= eSQL 16.9, improved Cypher query support, and AI integration updates.

Upstream Changes

  • Upstrea= m Merge: AgensGraph is now compatible with PostgreSQL 16 up to the 16.9 release, incorporating the la= test PostgreSQL improvements and security patches.
  • Paralle= l FULL and RIGHT/OUTER Hash Joins: Added support for parallel exec= ution of FULL and internal RIGHT OUTER hash joins= , improving performance on large join queries.
  • SQL/JSO= N Standard Functions: New SQL/JSON features such as JSON_ARR= AY(), JSON_ARRAYAGG(), JSON_OBJECT(), and = JSON_EXISTS() provide more standard-compliant JSON processing.=
  • Vacuum = Freezing Improvements: Reduced overhead for vacuum operations and = smarter freezing strategy lowers maintenance costs on large tables.

Enhancements

  • Allow R= ow Level Security Policies to work with cypher queries: Enables r= ow-level access using user-defined policies, useful for enforcing data secu= rity and managing permissions in database administration.
  • Add met= a extension for agensgraph: Collection of helper functions for Ag= ensGraph that simplify working with graph metadata.
  • Improve= interoperability with extensions: Enhances compatibility with ot= her PostgreSQL extensions, such as pgvector, enabling smoother integration = within cypher queries.

AI Library

You can access those products at the AI Repository

  • LangCha= in AgensGraph: Python plugin for GraphStore and VectorStore integ= ration in langchain.
  • LlamaIn= dex AgensGraph: Python plugin for AgensGraphStore, PropertyGraphIn= dex, AgensgraphVectorStore integration in llamaindex.
  • AgensGr= aph LightRag: Python plugin for storing and querying knowledge gra= phs in AgensGraph with LightRAG.
  • Cognee = Community Graph Adapter - AgensGraph: Python plugin to provide an= AgensGraph graph database adapter for the Cognee framework.
  • AgensGr= aph MCP Server: A Model Context Protocol (MCP) server implementati= on that provides database interaction and allows graph exploration capabili= ties through AgensGraph.

Bug Fixes

  • ACL log= ic to the ModifyGraph: ACL check logic was previously in the ExecD= eleteGraph function, but it was not specific to that operation. It has now = been moved to ExecInitModifyGraph.
  • Crash a= nd errors on some cases of non-existent labels: The server would c= rash or error out if a non-existent label was used in MATCH/MERGE clause fo= r some cases.
  • Crash o= n variable reuse in MERGE clause: The server would crash if an alr= eady declared variable from the previous clauses is referenced in MERGE cla= use.
  • Alter t= he default expression to column properties
    • In the dumping = action, the default column properties were not properly set. Now it'll set = the default column property after the dump properly.
  • Invalid= label numbering after RENAME command: After executing the ALTER L= ABEL RENAME command, the target label ID was not properly updated when inse= rting into that label. It will now correctly follow the proper label ID.
  • fix: Co= lumns not visible when using a VLE: Variable used VLE expression i= s not visible in subsequent transformation.

The new version is immediately available fo= r download.
This email was sent to you from SKAI Worldwide (formerly Bitnine). It was d= elivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to SKAI Worldwide (formerly Bitnine).

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for for one of the content tags Community, Related Proprietary or Related Open = Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============3778053515352029484==-- --===============2585712398298985805==--