| 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: | Whole Thread | Raw Message | 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
| 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 |