Oliver Elphick <olly@lfix.co.uk> writes: > ... in this particular case, the column > order was wrong. I should add that the table inherits from another one, > but the swapped columns are a long way into the extra columns specific > to this table.
Hm. Could we see the actual pg_attribute data for both this table and its parent? I'm thinking of something like select * from pg_attribute where attrelid = 'foo'::regclass order by attnum; for each table. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster