Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\))
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and
 13 versions.
From: "Edward J. Sabol" <edwardjsabol@gmail.com>
In-Reply-To: 
 <CAMZ99nfm_eF-x91KbqRMrdGZj-Pcgioi7mH8fR-ghQQ-LA2xXQ@mail.gmail.com>
Date: Mon, 29 Nov 2021 13:28:20 -0500
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <BED8E59E-D98F-4048-BD38-38ED304B1A60@gmail.com>
References: 
 <CAMZ99nd6sMpMSFS+iRYvQ-s=J1hW=fr81tWhp9E_jk0gd3aS0A@mail.gmail.com>
 <d5dca6e1f58261828e86b3c513703bbd06380e84.camel@cybertec.at>
 <CAMZ99nc6_sbVeuZjAU-dywhoxXMnGeUx1ESkgzJan9ABuXsD1A@mail.gmail.com>
 <5b932ae0-820c-d34f-1d7f-19f786741119@gmail.com>
 <CAMZ99nfm_eF-x91KbqRMrdGZj-Pcgioi7mH8fR-ghQQ-LA2xXQ@mail.gmail.com>
To: Gaurav Anand <gaurav.anand@saama.com>
Archived-At: 
 <https://www.postgresql.org/message-id/BED8E59E-D98F-4048-BD38-38ED304B1A60%40gmail.com>
Precedence: bulk

Going to https://pgxn.org/dist/temporal_tables/, I discovered that the =
latest version is 1.2.0, which was released in 2017. The CHANGELOG =
mentions adding support for PostgreSQL 10. I think you are trying to use =
it with PostgreSQL 12 or 13. Do you see the problem? That version of the =
temporal_tables extension does not support any version of PostgreSQL =
greater than 10.

The https://pgxn.org/dist/temporal_tables/ web page also has a link to =
the GitHub repository for the project: =
https://github.com/arkhipov/temporal_tables

If you go there and view the commits, you'll find that the most recent =
commit "make(s) temporal_tables extension compile with PostgreSQL 13". =
Unfortunately, it hasn't been released yet. I would advise cloning the =
GitHub repository and trying to compile that version. If you have =
problems, you should take it up with the temporal_tables developer by =
filing an issue at https://github.com/arkhipov/temporal_tables/issues. =
There's nothing the PostgreSQL team can do to help here.

Hope this helps,
Ed

On 11/29/21 2:17 AM, Gaurav Anand wrote:
> Hi Laurenz,
>=20
> Thank you for kind attention and acknowledging.
>=20
> We are using installation steps from the PGXN website =
https://pgxn.org/dist/temporal_tables/=20