| From: | Yogi Barot <YBarot(at)symcor(dot)com> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Postgresql 9.5 error |
| Date: | 2016-02-18 14:14:06 |
| Message-ID: | 6795a92102084df89e4c260ab92092fc@MX002.symprod.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2016-02-18 14:26:11 | Re: Postgresql 9.5 error |
| Previous Message | Gilberto Castillo | 2016-02-18 14:08:02 | Re: [MASSMAIL]Re: oracle db reads from postgresql |