[EMAIL PROTECTED] writes: > Restoring inherited data destroys parent table data.
No it doesn't. You appear to be expecting the pre-7.1 behavior of SELECT on a parent table. Recent versions default to doing the equivalent of "SELECT FROM parent*". See the SQL_INHERITANCE configuration parameter if you prefer the old way. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster