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 --inputdir=./ --bindir='/home/marcos/age_project/postgres/bin'    --load-extension=age --inputdir=.//regress --outputdir=.//regress --temp-instance=.//regress/instance --port=61958 --encoding=UTF-8 --dbname=contrib_regression scan graphid agtype catalog cypher expr cypher_create cypher_match cypher_unwind cypher_set cypher_remove cypher_delete cypher_with cypher_vle cypher_union cypher_call cypher_merge age_global_graph age_load index analyze graph_generation name_validation drop
============== removing existing temp instance        ==============
============== creating temporary instance            ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 61958 with PID 132693
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== installing age                         ==============
ERROR:  tables declared WITH OIDS are not supported
command failed: "/home/marcos/age_project/postgres/bin/psql" -X -c "CREATE EXTENSION IF NOT EXISTS \"age\"" "contrib_regression"
make: *** [/home/marcos/age_project/postgres/lib/pgxs/src/makefiles/pgxs.mk:420: installcheck] Error 2

How can I solve this?

Make sure your Apache AGE branch is compatible with the PostgreSQL version, and that you have used git fetch and git pulled so you can be up-to-date with everything.

You can follow the Apache AGE official guide and you will not have any problem!

This error is happening because the Apache AGE is not compatible with the version of PostgreSQL you have installed on your computer.

To resolve this, you need to make sure you have PostgreSQL version either 11, 12 or 13 because right now only those versions are supported.Then Based on the version of your PostgreSQL you need to clone the specific compatible branch of Apache AGE from the GitHub repository.

This will hopefully solve your problem.

git checkout to a branch of apache age version that's compatible with the postgres version installed on your machine. The error is most likely due to version incompatibilities.

This is as a result of compatibility issues between AGE and PostgreSQL installed on your device.

At the moment,
> You will need to install a AGE compatible version of Postgres, for now AGE only supports Postgres 11, 12 and 13.

It appears that you are using an incompatible PostgreSQL version. You should try using PG11 for setting up AGE from the source code.

You can check out the AGE Docs for installation steps at Docs

This error occurs due to version mismatch of AGE with the Postgres on the system. Using the correct branch should fix the issue. Even the supported version of Postgres does not work with all the branches of Apache AGE project.
If you check the branch list, there is a branch for all the versions of Postgres.

To switch the branch for compatible Postgres, use this command:

git checkout <Required Branch>

For the complete installation guide, follow this article. Install Apache AGE from Source

Also, make sure you use the correct path of pg_config during installation and install check.

The issue at hand here is of compatibility between the version of Postgres and AGE installed on the machine. Currently, PG 11, 12, and 13 are compatible to be used with AGE.

Clearly it is the issue with the compatibility of your postgresql version, as per the documentation of apacheAGE only verion 11, 12, and 13 of postgresql are compatible with apacheAGE.

Well you haven't mentioned your postgreSQL version installed. But from your picture it is clear that it is a compatibility issue between AGE and postgreSQL. What I suggest is to change the branch to the required postgreSQL version for AGE.

For that please use

cd age
git checkout required-version

Currently AGE is supported for postgreSQL 11,12 & 13.

If you have any further questions, I suggest going through the AGE documentation on the main repo.

WITH OIDS was supported in the older versions of PostgreSQL and its purpose was to generate object IDs.

It is not supported by the new versions of PostgreSQL which are compatible with AGE. So, you have to use the PostgreSQL compatible version (PG11,12,13) with AGE.

Incompatibility between AGE and Postgres versions.

> You will need to install a AGE compatible version of Postgres, for now AGE only supports Postgres 11, 12 and 13.

Check out the official documentation.