Search Postgresql Archives

Re: How to add an INHERITS to an already populated table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Please note that the inheritance is not fully set -- if you discover
> strange behavior e.g. when altering any of the tables, don't be
> surprised.  In particular, you should set the attislocal and attinhcount
> attributes in pg_attribute for the child tables; also pg_depend entries
> are missing.  I don't know what else.
> 
> Also you definitely shouldn't be using relfilenode, but the real Oid of
> the table (relfilenode is the filename only, not the internal identifier
> of the table).

I think I'll make a script and propose it for revision to the list
before using it on any real database.

David
-- 
dpradier@xxxxxxxxxx - tel: 01.46.47.21.33 - fax: 01.46.47.21.37

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux