Tables declared WITH OIDS are not supported

Question

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?

score 1 · Answer 1 · edited Jul 07 '23 at 21:38

1

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!

edited Jul 07 '23 at 21:38

Peter Mortensen

30,738
21
105
131

answered Jul 06 '23 at 13:43

Panagiotis Foliadis

254
1
1
8

ShaHeen · Answer 2 · 2023-07-08T05:00:43.863

0

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.

edited Jul 08 '23 at 05:00

answered Jul 07 '23 at 15:38

ShaHeen

59
5

Re *"to clown"*: I am sure some think that is what is going on – Peter Mortensen Jul 07 '23 at 21:36

score 0 · Answer 3 · answered Jul 09 '23 at 20:42

0

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.

answered Jul 09 '23 at 20:42

Peter

43
4

score 0 · Answer 4 · answered Jul 11 '23 at 07:57

0

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.

answered Jul 11 '23 at 07:57

Tito

289
8

score 0 · Answer 5 · answered Jul 11 '23 at 13:28

0

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

answered Jul 11 '23 at 13:28

Humza Tareen

146
6

score 0 · Answer 6 · answered Jul 11 '23 at 17:34

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.

score 0 · Answer 7 · answered Jul 11 '23 at 21:33

0

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.

answered Jul 11 '23 at 21:33

Sadeed Ahmad

83
3

score 0 · Answer 8 · answered Jul 11 '23 at 22:52

0

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.

answered Jul 11 '23 at 22:52

Muhammad Sarmad

118
4

score 0 · Answer 9 · edited Jul 13 '23 at 14:51

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.

score 0 · Answer 10 · answered Jul 26 '23 at 20:23

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.

score 0 · Answer 11 · answered Jul 26 '23 at 23:23

0

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.

answered Jul 26 '23 at 23:23

Vinay Kumar Talreja

1
1
8

Tables declared WITH OIDS are not supported

11 Answers11