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(at)momjian(dot)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 +