Postgres Pro
Downloads
Home   >   mailing lists

Re: Diffrent column ordering after dump/restore tables with INHERITS - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Diffrent column ordering after dump/restore tables with INHERITS
Date
Msg-id 9487.1246807706@sss.pgh.pa.us
Whole thread Raw
In response to Diffrent column ordering after dump/restore tables with INHERITS  (Oleg Serov <serovov@gmail.com>)
Responses Re: Diffrent column ordering after dump/restore tables with INHERITS  (Greg Stark <gsstark@mit.edu>)
List pgsql-bugs
Tree view 
Oleg Serov <serovov@gmail.com> writes:
> If i have tables with inherits, and the
> n i adding a column in to the base table, the new column will be at
> the on of column list in child table, but when i done dump->restore i
> have surprise,
> Column ordering was changed.

This is not a bug, it's the intended behavior.

            regards, tom lane

pgsql-bugs by date:

Previous
From: wmlonergan@aol.com
Date:
Subject:
Next
From: Tom Lane
Date:
Subject: Re: BUG #4899: Open parenthesis breaks query plan