Re: problem

On Fri, Apr 24, 2020 at 05:28:05PM -0400, Bruce Momjian wrote:
> On Fri, Apr 24, 2020 at 08:58:44PM +0000, reda kodi wrote:
> > please i need this rpm for conto's 6 
> > https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/
> > pgdg-redhat-repo-42.0-9.noarch.rpm;
> > 
> > link doesn't work please help me when i instal new rpm i hav this problem
> > 
> > 
> > Erreur SQL :
> > 
> > ERROR:  column "spclocation" does not exist
> > LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
> >                                                              ^
> > 
> > Dans l'instruction :
> > 
> > SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
> >                     (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS
spccomment
> >                                         FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY
spcname
> 
> PG 12 had this change:

Sorry, PG 9.2 had this change:

> 
>         Remove the <structfield>spclocation</structfield> field from <link
>         linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>
>         (Magnus Hagander)

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +