Re: Postgresql 9.5 error - Mailing list pgsql-admin

From Steve Crawford
Subject Re: Postgresql 9.5 error
Date
Msg-id CAEfWYyydNAwgy2v24jOL30drM54oT0afeFXBLef0yHSGKVxuWQ@mail.gmail.com
Whole thread Raw
In response to Postgresql 9.5 error  (Yogi Barot <YBarot@symcor.com>)
List 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@symcor.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql 9.5 error
Next
From: Steve Crawford
Date:
Subject: Re: Postgresql 9.5 error