BUG #5198: Plain dump: wrong field order for inherited tables - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      5198
Logged by:          Lyamin Mikhail
Email address:      lma032@gmail.com
PostgreSQL version: 8.3.8
Operating system:   Debian
Description:        Plain dump: wrong field order for inherited tables
Details:

pg_dump - version 4.8.1 under Windows 7

1) create table
2) create inherited table
3) add fields in parent table
4) add fields in child table
5) make dump

Now you have wrong order of fields in insert. This haooend because in new
child table you will have first inherited fields, then newly added. And in
dump you have fields, that are ordered by appending

Possible solution: in data insertion write: "insert into TABLE_NAME (<fields
list>) VALUES (<values list>)"

instead of
"insert into TABLE_NAME VALUES (<values list>)"