Re: Table inheritance and column ordering question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Doliov <stephan(dot)doliov(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Table inheritance and column ordering question
Date: 2019-08-11 20:37:55
Message-ID: 15837.1565555875@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stephan Doliov <stephan(dot)doliov(at)gmail(dot)com> writes:
> I'd like to know whether there is any way to control the order of inherited
> columns?

Nope, not at present.

There's a lot of wished-for functionality around separating the
presentation order of table columns from their physical storage order.
If we had that it'd fix your problem too. But right now, those are
tied together and also tied to the columns' catalog identifiers (attno).
People have investigated changing that, but it looks enormously bug-prone
since the existing code doesn't distinguish these concepts.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message pantilimonov michael 2019-08-11 21:51:42 Re: [GSoC] artbufmgr
Previous Message Alexander Korotkov 2019-08-11 20:11:36 Re: SQL/JSON path: collation for comparisons, minor typos in docs