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 code sample is given below - PG_FUNCTION_INFO_V1(some_function); PG_FUNCTION_INFO_V1(write);…
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 query which lead to a LEFT-JOIN Both…
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 retrieve the data from…
I was thinking on developing a function for age that returns a graph's adjacency matrix. An adjacency matrix stores the number of edges between two nodes. The complexity to check if an edge exists within an adjacency matrix is O(1),…
I have PostgreSQL 15 running with the Apache AGE extension installed on it. I can view graphs and run queries using AGE Viewer, but I get the following error when creating a new graph from AGE Viewer. I restarted AGE…
I'm adding temporal Cypher functions to AGE, and I've implemented the date() Cypher function. Currently, it works, and my result is printed in the output as a string. SELECT * FROM cypher('graph', $$ RETURN date() $$) as (date agtype); date…
I am trying to run AgensBrowser on my Windows machine, I have already installed AgensGraph. First, I registered in the official website and was sent a link to download the Zip file, I extracted the contents in the Zip file…
I have followed the official documentation in order to run the container, using docker pull apache/age docker run --name age -p 5455:5432 -e POSTGRES_USER=postgresUser -e POSTGRES_PASSWORD=postgresPW -e POSTGRES_DB=postgresDB -d apache/age but it stops there. How can I log in to…
While installing Apache AGE from master branch, on PostgreSQL 14, the following error appeared while issuing make install: /usr/bin/install: cannot remove '/usr/local/pgsql/lib/age.so': Permission denied make: *** [/usr/local/pgsql/lib/pgxs/src/makefiles/../../src/Makefile.shlib:456: install-lib-shared] Error 1 What should I do to fix this? What I tried…
When using npm start to start AGE Viewer, I get the following error in my terminal. Error: Not connected at _callee4$ (/home/hallixon/age-viewer/backend/src/controllers/databaseController.js:64:19) at tryCatch (/home/hallixon/age-viewer/backend/node_modules/@babel/runtime/helpers/regeneratorRuntime.js:44:17) at Generator.<anonymous> (/home/hallixon/age-viewer/backend/node_modules/@babel/runtime/helpers/regeneratorRuntime.js:125:22) at Generator.next (/home/hallixon/age-viewer/backend/node_modules/@babel/runtime/helpers/regeneratorRuntime.js:69:21) at asyncGeneratorStep (/home/hallixon/age-viewer/backend/node_modules/@babel/runtime/helpers/asyncToGenerator.js:3:24) at _next (/home/hallixon/age-viewer/backend/node_modules/@babel/runtime/helpers/asyncToGenerator.js:22:9) at /home/hallixon/age-viewer/backend/node_modules/@babel/runtime/helpers/asyncToGenerator.js:27:7 at…