Hello, Guillaume.
You wrote:
GL> Hi Pavel,
GL> On Mon, 2012-06-25 at 08:26 +0300, Pavel Golub wrote:
>> Hello, Pgsql-bugs.
>>
>> According to the "Moving tablespaces" thread started by Bruce
>> http://archives.postgresql.org/pgsql-docs/2011-12/msg00003.php
>> pg_tablespace.spclocation column is removed in the 9.2beta. However
>> this breaks backward compatibility for a bunch of products, e.g.
>> pgAdmin, phpPgAdmin, PgMDD etc.
>>
>> I'm not sure this is the best choice. Because each application with
>> tablespace support will need additional check now to determine what
>> way to use for obtaining tablespace location:
>> pg_get_tablespace_location(oid) or tablespace.spclocation
>>
>> I'm aware of problems caused by this hard coded column. My proposal is
>> to convert pg_tablespace to system view may be?
>>
GL> I don't see why it causes you so much trouble.
Not so much. However.
GL> You should already have
GL> many locations in your code where you need to check the version to be
GL> compatible with the latest major releases.
This is holy true.
GL> I know pgAdmin does. So I
GL> guess that one more is not a big deal.
GL> And this change in PostgreSQL helps a lot DBAs who want to move
GL> tablespaces (not really common work AFAIK, I agree).
I know. I just followed the advice of Josh Berkus and added this as a
bug.
--
With best wishes,Pavel mailto:pavel@gf.microolap.com