Re: [BUGS] BUG #6618: incorrect restore for composite columns when order changes

2012-04-26 Thread Rikard Pavelic
On 27.4.2012. 0:39, Tom Lane wrote: > > There is no supported method for changing the order of attributes in a > composite type, so I wonder exactly how you did step 4. If it involved > direct manipulation of the system catalogs, I would say this falls in > the category of "if you break it, you ge

Re: [BUGS] BUG #6618: incorrect restore for composite columns when order changes

2012-04-26 Thread Tom Lane
rikard.pave...@zg.htnet.hr writes: > Steps to reproduce problem: > 1) create composite type > 2) use composite type as column in a table > 3) clone database > 4) change order of attributes in cloned database > 5) dump to plain sql with column names > 6) restore sql dump to cloned database There is

[BUGS] BUG #6618: incorrect restore for composite columns when order changes

2012-04-26 Thread rikard . pavelic
The following bug has been logged on the website: Bug reference: 6618 Logged by: Rikard Pavelic Email address: rikard.pave...@zg.htnet.hr PostgreSQL version: 9.1.3 Operating system: Windows 7 Description: We've run into another issue with composite types. I've search