I wrote: > "Sebastjan Trepca" <trepca@xxxxxxxxx> writes: >> This is how to reproduce this issue: >> ... >> inh_test=# alter table capitals inherit cities; > Fascinating. pg_dump is almost smart enough to get this right, ... I've fixed this --- if you need a patch right away, see here: http://archives.postgresql.org/pgsql-committers/2007-10/msg00448.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend