Stack Overflow
Stack Overflow

Questions tagged [apache-age]

Use this tag for programming, integration and configuration questions related to using Apache AGE in your software project. Apache AGE is a extension to PostgreSQL which provides graph database capabilities.

Apache AGE is an extension to PostgreSQL providing graph database capabilities.

A core objective of Apache AGE, from their overview, is:

"to create single storage that can handle both relational and graph model data so that users can use standard ANSI SQL along with openCypher, the Graph query language."

Resources:

420 questions
0
votes
11 answers

Why I am getting a fatal error (No such file or directory found) in process of configuring AGE with PostgreSQL

I am installing AGE software in my system (Ubuntu OS.In the step of configuration of AGE with PostgreSql, when enter this command I am getting an error. I’ve also reinstalled the software but I am getting same error every time. This is the link of…
Maimoona Abid
  • 567
  • 4
0
votes
1 answer

In Postgres 16 BETA, should the ParseNamespaceItem have the same index as it's RangeTableEntry?

I have been working on updating Apache AGE with the latest version of Postgres, the REL_16_BETA version. One of the main problems that I am facing is the fact that the code was reworked to update the permission checking and now some of the queries…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
0 answers

Why query is getting unrecognized RTE kind: 2 (PG16 - AGE16)

We are having an issue while execution of the queries that contains join conversed subquery from apache age's parser to PostgreSQL's parser OPTIONAL MATCH with MATCH cause that error The following query SELECT * FROM cypher('cypher_match', $$ …
Mohamed Mokhtar - rrrokhtar
  • 678
  • 5
  • 12
0
votes
1 answer

Getting Error: I want to connect pyAdmin (Installed on Windows) with postgreSQL on ubuntu 22.04

I want to connect pgadmin (Windows) with postgreSQL-11.18 (Ubuntu 22.04) and getting error: connection timeout error I am following steps from: link I have started postgres as mentioned in steps: Started postgreSQL While Connecting with pgAdmin I am…
Vinay Kumar Talreja
  • 1
  • 1
  • 8
0
votes
4 answers

How to use non-blocking connection function in libpq and trigger a notification or callback when the connection is established withlibpq — C Library?

I am trying to establish a non-blocking connection to a PostgreSQL database using the libpq library in C, and I want to be able to trigger a notification or callback function once the connection is established. I know that PQconnectStart() can be…
AmrShams07
  • 96
  • 1
  • 7
0
votes
12 answers

How to properly write AGE queries with the `RETURN *` Cypher command

I am trying to add support for the following query for an AGE project that converts Cypher queries to SQL: MATCH p=({name: 'agens-graph'})-[{lang: 'java'}]->(m) RETURN *; This successfully converts into the following: SELECT * FROM cypher('test',…
Ken W.
  • 397
  • 1
  • 13
0
votes
2 answers

Apache AGE. PREPARE. ERROR: function cypher_stored_procedure(unknown) does not exist

According to instructions Apache AGE docs wrote a function: CREATE OR REPLACE FUNCTION sh_univeronto.f_example() RETURNS TABLE(res ag_catalog.agtype) LANGUAGE plpgsql AS $function$ begin LOAD 'age'; SET search_path TO ag_catalog,…
kealog
  • 11
  • 4
0
votes
3 answers

npm start throws exception *digital envelop routines are unsupported*

I was assigned a task to work on the front end of a react application but I have faced a very strange error. When I forked and cloned it on my machine, I ran npm i for installing the necessary dependencies. After the installation was complete I ran…
Talha Munir
  • 121
  • 5
0
votes
12 answers

Postgres installation failed

I am trying to install PostgreSQL on Ubuntu but ./configure is failing ./configure --enable-debug --enable-cassert --prefix=$(pwd) CFLAGS="-ggdb -Og -fno-omit-frame-pointer" checking for icu-uc icu-i18n... no configure: error: ICU library not…
MOIEZ IBRAR
  • 39
  • 5
0
votes
4 answers

How to retrieve both the array and the integer arguments of an age function?

I have created a function for age which receives an array as an argument and outputs all it's elements except the head of the list. But I wanted to add a second argument to output the N last elements from the array. Although many age list functions…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
2 answers

Node not getting labelled during visualization and giving some ids instead in AgeViewer

I have two files: 1st: City.csv: 2nd file: Mfr.csv When I load both files into two separate graph the first graph for 1st file is label nicely with name field, but for 2nd file the graph is some random GIDs, How can I solve this issue? Query…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
2 answers

Is function overloading possible in AGE?

AGE's functions can be found in the age--1.3.0.sql file. Although there are no examples of function overloading, is there any possibility to create multiple functions with the same name but with different parameters for AGE? If yes, then how? If…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
2 answers

How does an AGE function works when the passed argument is a PATH?

I've analyzed the behavior of the age_relationships() function - that can be found here - and looking how it works in GDB, it seems that the function is called multiple times for each available path. So, for example, if we want to find all paths…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
3 answers

Is it possible to use SPI within an age_ function?

I was wondering if I could utilize SPI to access the server and perform a query to return an agtype value. I wanted to implement a function that uses an already created one but then perform an ORDER BY and then return the agtype results from there.…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
4 answers

Encountering error while creating new Database in postgres using initdb command

When running bin/initdb demo I encounter the following error: The files belonging to this database system will be owned by user "USER_1". This user must also own the server process. The database cluster will be initialized with locales COLLATE: …
ShaHeen
  • 59
  • 5
1 2 3
…
27 28