pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Edward J. Sabol <edwardjsabol@gmail.com>
To: Gaurav Anand <gaurav.anand@saama.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
Date: Mon, 29 Nov 2021 13:28:20 -0500
Message-ID: <BED8E59E-D98F-4048-BD38-38ED304B1A60@gmail.com> (raw)
In-Reply-To: <CAMZ99nfm_eF-x91KbqRMrdGZj-Pcgioi7mH8fR-ghQQ-LA2xXQ@mail.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>

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,
> 
> Thank you for kind attention and acknowledging.
> 
> We are using installation steps from the PGXN website https://pgxn.org/dist/temporal_tables/ 






view thread (7+ messages)

Message-ID: <BED8E59E-D98F-4048-BD38-38ED304B1A60@gmail.com>
Permalink:  ../BED8E59E-D98F-4048-BD38-38ED304B1A60@gmail.com/
Also on:    postgresql.org/message-id/BED8E59E-D98F-4048-BD38-38ED304B1A60@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: edwardjsabol@gmail.com, gaurav.anand@saama.com, pgsql-admin@lists.postgresql.org
  Subject: Re: PGXN installation failure for Postgres Image of PostgreSQL 12 and 13 versions.
  In-Reply-To: <BED8E59E-D98F-4048-BD38-38ED304B1A60@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox