pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: reda kodi <kodi_reda@hotmail.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: problem
Date: Fri, 24 Apr 2020 17:29:25 -0400
Message-ID: <20200424212925.GA23555@momjian.us> (raw)
In-Reply-To: <20200424212805.GB25076@momjian.us>
References: <MN2PR20MB24292F19E2D4B92894E399108BD00@MN2PR20MB2429.namprd20.prod.outlook.com>
	<20200424212805.GB25076@momjian.us>

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 +





view thread (13+ messages)  latest in thread

Message-ID: <20200424212925.GA23555@momjian.us>
Permalink:  ../20200424212925.GA23555@momjian.us/
Also on:    postgresql.org/message-id/20200424212925.GA23555@momjian.us

 · 

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-bugs@postgresql.org
  Cc: bruce@momjian.us, kodi_reda@hotmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: problem
  In-Reply-To: <20200424212925.GA23555@momjian.us>

* 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