Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes: > You are right. I coleage of mine has added the delete column after the > schema was created and it ptobably was on the bottom of the table and > dumped there. But now when I restore the schema this column is on the > top and the copy command wouldn't work. So I must change the schema file > on hand. To remove the column from the tracking_base table, and to add > it manuly on the bottem of each table that inherits it.
No, you need not change the database schema, just fix the COPY commands for the child tables. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match