Re: [BUGS] pg_tablespace.spclocation column removed in 9.2

2012-06-25 Thread Magnus Hagander
On Mon, Jun 25, 2012 at 3:46 PM, Tom Lane wrote: > Pavel Golub 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 sti

Re: [BUGS] pg_tablespace.spclocation column removed in 9.2

2012-06-25 Thread Tom Lane
Pavel Golub 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_

[BUGS] pg_tablespace.spclocation column removed in 9.2

2012-06-24 Thread Pavel Golub
Hello, Pgsql-bugs. According to the "Moving tablespaces" thread started by Bruce http://archives.postgresql.org/pgsql-docs/2011-12/msg3.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,