Re: [HACKERS] different column orders in regression test database - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] different column orders in regression test database
Date
Msg-id a4168f23-a845-4cfc-0cc0-bea2d528bedb@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] different column orders in regression test database  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: [HACKERS] different column orders in regression test database
Re: [HACKERS] different column orders in regression test database
List pgsql-hackers
On 5/18/17 16:21, Thomas Munro wrote:
> That's because if you attach a partition with a different column
> ordering,

Is it intentional and sensible to allow that in the first place?  Or was
it just inherited from inheritance?

> pg_dump dumps it with a normal CREATE TABLE ... PARTITION OF
> ... command, so the ordering it lost.

So it appears that either the above should be prohibited or pg_dump
should be fixed.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgindent (was Re: [HACKERS] [COMMITTERS] pgsql: Preventive maintenance in advance of pgindent run.)
Next
From: Thomas Munro
Date:
Subject: Re: [HACKERS] different column orders in regression test database