Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem

problem

From
reda kodi
Date:

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

Re: problem

From
Bruce Momjian
Date:
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:

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

I suggest you read all major release notes from your old PG version to
your new one.  You did not tell us what is generating this query.

Also, this has nothing to do with security, so you should post to only
one email list.

-- 
  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 +

Re: problem

From
Bruce Momjian
Date:
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 +

Re: problem

From
Alvaro Herrera
Date:
On 2020-Apr-24, 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

Hello,

This address is for reporting security issues in PostgreSQL, not for
general support questions.

Please see https://www.postgresql.org/support/ and in particular the
pgsql-general mailing list for venues for general support questions.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: problem

From
Alvaro Herrera
Date:
On 2020-Apr-29, Alvaro Herrera wrote:

> On 2020-Apr-24, 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
> 
> Hello,
> 
> This address is for reporting security issues in PostgreSQL, not for
> general support questions.

Apologies, I forgot to remove the CC to pgsql-bugs.  The above was meant
to have the security@postgresql.org CC only.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services