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

From: rikard(dot)pavelic(at)zg(dot)htnet(dot)hr
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6618: incorrect restore for composite columns when order changes
Date: 2012-04-26 22:20:51
Message-ID: E1SNX3T-0003Mk-Gy@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6618
Logged by: Rikard Pavelic
Email address: rikard(dot)pavelic(at)zg(dot)htnet(dot)hr
PostgreSQL version: 9.1.3
Operating system: Windows 7
Description:

We've run into another issue with composite types.
I've search internets but didn't find any reference to this, so I guess it's
not a documented problem.

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

Problem:
Composite type will be restored in order from original instead of cloned
database.

While I don't see a nice solution to this problem, it's not a too big issue
for us.
Just trying to document some more gotchas with composite types ;(

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2012-04-26 22:35:17 Re: 291 pg_toast_temp schemas?
Previous Message Tom Lane 2012-04-26 19:50:33 Re: hstore parser incorrectly handles malformed input