problem

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 +

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 +

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

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