On Tue, Dec 13, 2011 at 12:02 PM, Julien Tachoires <jul...@gmail.com> wrote: > Right, it seems to happen when the destination tablespace is the same > as the database's tbs, because, in this case, relation's tbs is set to > InvalidOid : > src/backend/commands/tablecmds.c line 8342 > > + rd_rel->reltablespace = (newTableSpace == MyDatabaseTableSpace) ? > InvalidOid : newTableSpace; > > Why don't just asign newTableSpace value here ?
When a relation is stored in the default tablespace, we always record that in the system catalogs as InvalidOid. Otherwise, if the database's default tablespace were changed, things would break. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers