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
1
vote
11 answers

Tables declared WITH OIDS are not supported

This error occurs when I run the PG installcheck of AGE: cd ~/new-age/age make PG_CONFIG=~/age_project/postgres/bin/pg_config installcheck Output: /home/marcos/age_project/postgres/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress…
Marcos Silva
  • 115
  • 5
1
vote
4 answers

Binding the property with JSON parameter

I'm working on a system deals with dynamic properties. If I want to create a vertex, I can do it like this before that: select * from ag_catalog.cypher('people',$$ create (nyk:person{name:'nyk'}) return nyk $$) as (v ag_catalog.agtype); But now, I…
Aadil Bashir
  • 111
  • 5
1
vote
3 answers

How to add Apache AGE extension to PostgreSQL on Amazon RDS?

How can I add the Apache AGE extension to my PostgreSQL database hosted on Amazon RDS? I want to utilize the graph database capabilities offered by Apache AGE within my existing PostgreSQL environment. I have researched the process but couldn't find…
Omar Saad
  • 349
  • 3
  • 8
1
vote
5 answers

Installing AGE PG16 beside Postgresql v16beta1 giving bison is missing while it is not

I have installed Postgres v16beta1 and while installing that I got an issue that while configuring that using ./configure --prefix=$(pwd) -enable-debug it shows that: checking for icu-uc icu-i18n... no configure: error: ICU library not found If you…
Mohamed Mokhtar - rrrokhtar
  • 678
  • 5
  • 12
1
vote
16 answers

Removing the label name in Apache agedb produces error

I am using the following sample query to create a node with a label. SELECT * FROM cypher('vg-graph', $$ CREATE (m:Movie {name: "Movie Name", uid: "12345678", body: "Description"}) $$) as (n agtype); Following query should remove label…
Abdul
  • 69
  • 5
1
vote
8 answers

How to not need to rewrite SET search_path = ag_catalog every time

Every time I run postgres instance, I need to manually set the search_path to be to ag_catalog by SET search_path=ag_catalog; and then load the age, is there a way makes me don't need to every time to do that?
ahmed_131313
  • 142
  • 6
1
vote
1 answer

Changing from RTE to PNSI struct in Apache AGE

Postgres source code has changed some struct members between versions. In Apache AGE source code, the RTE members are used a lot and we are trying to verify if it's possible to change RTE to PNSI in some cases. For instance, some of these changes in…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
5 answers

AGE Installation for PG 16 throws error: could not create src/backend/parser/ag_scanner.c

I have installed postgres-16-beta and I was assigned to a project to make possible to use AGE with PostgreSQL 16. I have configured postgres with: ./configure --prefix=$(pwd) --enable-cassert --enable-debug CFLAGS="-ggdb -Og -g3…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
17 answers

What is the difference between percentileDisc and percentileCount in Apache Age aggregation functions?

Difference between percentileDisc and percentileCount aggregation functions in Apache AGE. I am unable to understand the difference between percentileDisc and percentileCount aggregation functions. It says in the documentation that we use…
Awais Bin Adil
  • 17
  • 1
1
vote
5 answers

Implementing a Date Function in AGE

I am trying to implement date() function in AGE, but C doesn't have an in-build date function that I can use. I am considering utilizing the age_timestamp() function and converting its output to date format. However, I have been unable to find the…
Muhammad Abdullah
  • 1
  • 5
1
vote
7 answers

Unsupported operation error when updating records in Apache Age table using Go

I'm working on a Go application where I need to update records in an Apache Age table. I'm facing an error "unsupported operation" when performing the update operation. Error message: When executing the update query against the Apache Age table, I…
Prachi
  • 39
  • 3
1
vote
3 answers

Install and run apache/age and postgreSQL via docker-compose

This is my docker-compose.yml file version: '3' services: age: image: apache/age container_name: myAge ports: - "5555:5555" volumes: - age-data:/var/lib/age depends_on: - db command: ["age-server",…
Hassan Rehan
  • 21
  • 6
1
vote
5 answers

Cannot change max_function_args parameter in PostgreSQL

I'm trying to modify the max_function_args parameter in PostgreSQL, but I'm getting an error message saying that the parameter cannot be changed. I'm using PostgreSQL version X.X on operating system Y. I've checked my user role and confirmed that I…
AmrShams07
  • 96
  • 1
  • 7
1
vote
11 answers

Apache agedb produces error when ORDER BY and RETURN AS r is used. Unexpected behaviour

When I execute these queries on apache ageDB SELECT * FROM cypher('sample_graph', $$ CREATE (:opt_match_v {prop: 'value1'})-[:opt_match_e]->(:opt_match_v {prop: 'value2'}), (:opt_match_v {prop: 'value3'})-[:opt_match_e]->(:opt_match_v…
Abdul
  • 69
  • 5
1
vote
2 answers

Ambiguous count results in Apache ageDB cypher query when alias is not defined: Why?

I am not able to get why this apache agedb behaviour is not returning correct result in the following query when alias in not defined SELECT * from cypher('sample_graph', $$ CREATE (a:Part {part_num: '111'}), (b:Part {part_num: '222'}), …
Abdul
  • 69
  • 5
1 2 3
…
27 28