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

Re: pg_tablespace.spclocation column removed in 9.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Golub <pavel(at)gf(dot)microolap(dot)com>, Pavel Golub <pavel(at)microolap(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_tablespace.spclocation column removed in 9.2
Date: 2012-06-25 13:46:26
Message-ID: 20031.1340631986@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Pavel Golub <pavel(at)microolap(dot)com> writes:
> I'm aware of problems caused by this hard coded column. My proposal is
> to convert pg_tablespace to system view may be?

It's not that easy to make a 100% backwards compatible view for a system
catalog.  The main sticking point is the OID column; see recent problems
with pg_roles' OID column for an example.  On the whole I don't think
renaming pg_tablespace and inserting a mostly-compatible view would be
a net advance.

More generally, I don't see that this particular incompatibility in
the system catalogs is worse than many others that we've perpetrated.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2012-06-25 14:08:31
Subject: Re: pg_tablespace.spclocation column removed in 9.2
Previous:From: Andres FreundDate: 2012-06-25 13:43:39
Subject: Re: Catalog/Metadata consistency during changeset extraction from wal

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2012-06-25 14:08:31
Subject: Re: pg_tablespace.spclocation column removed in 9.2
Previous:From: Pavel GolubDate: 2012-06-25 08:10:23
Subject: Re: pg_tablespace.spclocation column removed in 9.2

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