| Lists: | pgadmin-hackers |
|---|
| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | 9.2 fix: spclocation is gone |
| Date: | 2012-04-19 18:05:02 |
| Message-ID: | 4F9053CE.2040207@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-hackers |
pg_tablespace.spclocation column is gone in PostgreSQL 9.2. It's been
replaced by pg_tablespace_location(oid) function. Attached is a patch to
fix a query used by pgAdmin accordingly.
(this started to get on my nerve, as the query is executed every time
you connect to a database..)
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| fix-spclocation-query.patch | text/x-diff | 900 bytes |
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Re: 9.2 fix: spclocation is gone |
| Date: | 2012-04-19 20:36:58 |
| Message-ID: | 1334867818.2281.15.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-hackers |
On Thu, 2012-04-19 at 21:05 +0300, Heikki Linnakangas wrote:
> pg_tablespace.spclocation column is gone in PostgreSQL 9.2. It's been
> replaced by pg_tablespace_location(oid) function. Attached is a patch to
> fix a query used by pgAdmin accordingly.
>
> (this started to get on my nerve, as the query is executed every time
> you connect to a database..)
>
Magnus already took care of this last december, just after commiting his
patch on PostgreSQL. See commit
b80b851a35fdd090b0d5fe9ed43d5563a4f8bd3d. Only on master of course.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com