Re: Table inheritance and column ordering question - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Table inheritance and column ordering question
Date
Msg-id 15837.1565555875@sss.pgh.pa.us
Whole thread Raw
In response to Table inheritance and column ordering question  (Stephan Doliov <stephan.doliov@gmail.com>)
List pgsql-hackers
Stephan Doliov <stephan.doliov@gmail.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



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: SQL/JSON path: collation for comparisons, minor typos in docs
Next
From: pantilimonov michael
Date:
Subject: Re: [GSoC] artbufmgr