From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: Postgresql 9.5 error
Date: Thu, 18 Feb 2016 15:26:11 +0100
Message-ID: <na4ka4$g7k$1@ger.gmane.org> (raw)
In-Reply-To: <6795a92102084df89e4c260ab92092fc@MX002.symprod.com>
References: <6795a92102084df89e4c260ab92092fc@MX002.symprod.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Yogi Barot schrieb am 18.02.2016 um 15:14:
> I have migrated data from postgresql 9.0 to 9.5, When I run following command, it does not
> show tablespace location and fails with bellow error. Can someone provide fix in the next release?
>
>
> We are planning to put release in production from March 15, hopefully get fix before this date.
>
> postgres=# select * from pg_tablespace; -- Spclocation column is missing in pg_tablespace.
>
> spcname | spcowner | spcacl | spcoptions
>
> -----------------+----------+--------+------------
> pg_default | 10 | |
> pg_global | 10 | |
> foa_table_space | 16384 | |
>
> (3 rows)
>
> *postgres=# \db**
> *ERROR: column "spclocation" does not exist*
> *LINE 3: spclocation AS "Location"*
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-admin@postgresql.org
Cc: spam_eater@gmx.net
Subject: Re: Postgresql 9.5 error
In-Reply-To: <na4ka4$g7k$1@ger.gmane.org>
* 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