On Fri, 2014-05-09 at 17:16 -0400, Stephen Frost wrote: > Guillaume, > > * Guillaume Lelarge (guilla...@lelarge.info) wrote: > > Should information_schema tables be moved and not pg_catalog ones? it > > doesn't seem consistent to me. > > The catalog tables are moved by changing the database's tablespace, eg: > > ALTER DATABASE ... SET TABLESPACE > > That also moves any objects which are not assigned to a specific > tablespace. > > The question ends up being just which side of "is it part of the > catalog, or not?" the information schema falls on to. For this case, I > had considered those to *not* be part of the catalog as they can be > moved independently of the ALTER DATABASE ... SET TABLESPACE. > > This is happily documented: > > System catalogs will not be moved by this command- individuals wishing to > move a whole database should use ALTER DATABASE, or call ALTER TABLE on the > individual system catalogs. Note that relations in > <literal>information_schema</literal> > will be moved, just as any other normal database objects, if the user is > the > superuser or considered an owner of the relations in > <literal>information_schema</literal>. >
Thanks for the explanation. I should have RTFM before complaining. Sorry for the noise :) -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers