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

Поиск
Список
Период
Сортировка
От Lyamin Mikhail
Тема BUG #5198: Plain dump: wrong field order for inherited tables
Дата
Msg-id 200911191131.nAJBVDvi048409@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5198: Plain dump: wrong field order for inherited tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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>)"

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: BUG #5194: fire IDispatch Error #3015 when run PutCollect() in ADO
Следующее
От: Thomas Poindessous
Дата:
Сообщение: Re: BUG #5196: Excessive memory consumption when using csvlog