BUG #5198: Plain dump: wrong field order for inherited tables

From: "Lyamin Mikhail" <lma032(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5198: Plain dump: wrong field order for inherited tables
Date: 2009-11-19 11:31:13
Message-ID: 200911191131.nAJBVDvi048409@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5198
Logged by: Lyamin Mikhail
Email address: lma032(at)gmail(dot)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>)"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Inoue 2009-11-19 11:40:50 Re: BUG #5194: fire IDispatch Error #3015 when run PutCollect() in ADO
Previous Message Dave Page 2009-11-19 06:58:43 Re: pgsql-jdbc/pgsql-odbc