Re: issue, dumping and restoring tables with table inheritance can alter column order

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ingmar Brouns <swingi(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: issue, dumping and restoring tables with table inheritance can alter column order
Date: 2015-09-14 16:59:31
Message-ID: CAKFQuwaA0SZ1+TB5-4MU0as78nTafM6Lc38=da_i=ohWvBCxBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 14, 2015 at 11:11 AM, Ingmar Brouns <swingi(at)gmail(dot)com> wrote:

>
> However, when I dump the schema using pg_dump, and then load the
> resulting sql file, suddenly 'c' does follow 'a'. So restoring my
> schema has changed my table's layout. I feel dumping and loading
> should not alter column positions. Any thoughts?
>
>
​Any or all of the following:​

1) Help the community implement the outstanding concepts surrounding the
separation and recording of separate data for physical and logical column
order.
2) Suggest, and/or implement, ways that the current behavior could be more
readily discovered and comprehended by users without having to discover it
by accident.
3) Understand the problem and mitigate its impact in your specific work.

David J.


In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-09-14 19:03:06 Re: BUG #13619: regression functions return Null
Previous Message David G. Johnston 2015-09-14 16:53:08 Re: BUG #13619: regression functions return Null