290 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
40
views
Why does SET p1 = $person in Apache AGE Cypher return "SET clause expects a map" when using a prepared statement?
I'm using Apache AGE with PostgreSQL 17. I’m trying to create a node and set all of its properties from a parameter map using a prepared statement, as mentioned here: https://age.apache.org/age-manual/...
1
vote
1
answer
56
views
Filtering Out Null Keys in JSON Output Using Apache AGE Cypher Query with json_object_agg
Is there a way to filter out null keys for my json? This is using Apache AGE extension:
SELECT json_object_agg(k, v)
FROM cypher('hermech', $$
MATCH (a:contact_name)
WHERE id(a) = ...
0
votes
1
answer
69
views
How to store Nodes with array of ip-addresses (::inet) as property in Apache AGE
I need to store nodes with array of ip-addresses, ip-prefixes (::inet or ::cidr). After that I want to retrieve some nodes that have properties-prefixes from some other net-prefix.
Tried to create ...
0
votes
0
answers
39
views
Apache AGE seems to add double quotation marks on string properties - causes issues when trying to join in a regular SQL query
I'm having issues with extracting any string properties from an Apache AGE graph to PostgreSQL. It seems like AGE is adding double quotes (") to each string when the node gets created and when it'...
-1
votes
1
answer
35
views
Compilation Error When Installing AGE Plugin: Incompatible Function Parameters [closed]
I am trying to install the Apache AGE graph database plugin on the open-source version of PolarDB 15. According to the documentation, the AGE plugin supports PG versions 11, 12, 13, 14, 15, and 16, so ...
2
votes
0
answers
851
views
Build a GraphRag with PostGreSQL and Apache AGE Extension
I'm trying to understand if it's possible to use PostgreSQL as a GraphRAG. As far as I understand, GraphRAG allows hybrid retrieval that combines vector search and graph search.
It feels like Apache ...
-3
votes
1
answer
342
views
Apache AGE Cypher query in dynamic PL/pgSQL functions
I'm using the official release from Apache AGE GitHub for PostgreSQL 14 installed via homebrew on a Mac. I've run into an issue related to creating functions with Cypher and PL/pgSQL.
I'm trying to ...
0
votes
0
answers
143
views
Docker container for apache/age image is not able to setup configuration with input redirection
I am developing a python module that uses Apache AGE and I want to do some unit testing. For this, I wrote a bash script that runs the container, copies a SQL configuration file to it, executes the ...
0
votes
1
answer
71
views
Express abscence of edges in OpenCypher
This question has an answer for how to find nodes which don't have outgoing edges on neo4j and cypher:
MATCH ()-[:A]->(n) WHERE NOT (n)-->() RETURN n
However, this does not work on Apache AGE:
...
1
vote
0
answers
82
views
TypeError: ApacheAgeClient.connect is not a function
I am trying to use npm package apache-age-client, in order to connect to my Apache Age instance.
The problem is that, in order to initialize connection, I need execute ApacheAgeClient.connect method; ...
1
vote
0
answers
228
views
How to sync data between AGE vertex table and normal row table in Postgres?
I'm trying to determine how I can sync data from a standard row relational table or view in Postgres to the table I built with Apache AGE.
I have standard tables already defined in Postgres with ...
0
votes
0
answers
33
views
Indexes in AGE fail to create [duplicate]
I am trying to create indexes via OpenCypher in AGE:
postgres=# SELECT * FROM cypher('testGraph', $$ CREATE INDEX FOR (n:PkgType) ON (n.type) $$) AS (a agtype);
ERROR: syntax error at or near "...
1
vote
1
answer
127
views
DirectFunctionCall not executing for a function in the same file
In Apache AGE, when I call the DirectFunctionCall() function. It doesn't get executed. I have tried putting logging statements using elog() function in the write() function. But, it's of no use. The ...
1
vote
1
answer
159
views
Same query plan of AGE and different stacktrace (PostgreSQL version 15 & 16)
Currently I am working on an issue that happens on PostgreSQL server version 16 and does not happen with the 15 version (alongside Apache AGE).
The issue happens when executing the OPTIONAL MATCH ...
1
vote
3
answers
177
views
How can I return dynamically created matrices in functions written in C for PostgreSQL?
I was developing a function for Apache AGE that allows us to store graphs, a PostgreSQL extension, to return an adjacency matrix from a given graph. I used SPI to connect to the database and to ...