Skip site navigation (1) Skip section navigation (2)

pg_tablespace.spclocation column removed in 9.2

From: Pavel Golub <pavel(at)microolap(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: pg_tablespace.spclocation column removed in 9.2
Date: 2012-06-25 05:26:24
Message-ID: 1571492617.20120625082624@gf.microolap.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
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?

-- 
With best wishes,
 Pavel                          mailto:pavel(at)gf(dot)microolap(dot)com


Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2012-06-25 07:12:37
Subject: Re: warning handling in Perl scripts
Previous:From: Amit KapilaDate: 2012-06-25 05:16:34
Subject: Re: Catalog/Metadata consistency during changeset extraction from wal

pgsql-bugs by date

Next:From: Guillaume LelargeDate: 2012-06-25 08:02:42
Subject: Re: pg_tablespace.spclocation column removed in 9.2
Previous:From: Craig RingerDate: 2012-06-25 04:41:50
Subject: Re: BUG #6705: 32 bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group