From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Yogi Barot <YBarot(at)symcor(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Postgresql 9.5 error |
Date: | 2016-02-18 14:58:59 |
Message-ID: | CAEfWYyydNAwgy2v24jOL30drM54oT0afeFXBLef0yHSGKVxuWQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
You are probably using an old client with a new server. Update the client
first.
Cheers,
Steve
On Thu, Feb 18, 2016 at 6:14 AM, Yogi Barot <YBarot(at)symcor(dot)com> wrote:
> Hi,
>
>
>
> 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"*
>
>
>
> *Thanks,*
>
> *Yogi*
>
>
>
> CONFIDENTIALITY WARNING
> This communication, including any attachments, is for the exclusive use of
> addressee and may contain proprietary and/or confidential information. If
> you are not the intended recipient, any use, copying, disclosure,
> dissemination or distribution is strictly prohibited. If you are not the
> intended recipient, please notify the sender immediately by return e-mail,
> delete this communication and destroy all copies.
>
> AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ
> Ce message, ainsi que les pièces qui y sont jointes, est destiné à l’usage
> exclusif de la personne à laquelle il s’adresse et peut contenir de
> l’information personnelle ou confidentielle. Si le lecteur de ce message
> n’en est pas le destinataire, nous l’avisons par la présente que toute
> diffusion, distribution, reproduction ou utilisation de son contenu est
> strictement interdite. Veuillez avertir sur-le-champ l’expéditeur par
> retour de courrier électronique et supprimez ce message ainsi que toutes
> les pièces jointes.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2016-02-18 15:02:32 | Re: Postgresql 9.5 error |
Previous Message | Tom Lane | 2016-02-18 14:51:59 | Re: Postgresql 9.5 error |