> On Apr 12, 2018, at 2:36 PM, Christophe Pettus <x...@thebuild.com> wrote: > > >> On Apr 12, 2018, at 09:17, Robert Haas <robertmh...@gmail.com> wrote: >> Hmm, that's interesting. So you want the children to inherit the >> parent's tablespace when they are created, but if the parent's >> tablespace is later changed, the existing children don't move? > > +1 to that behavior. > > While it's always possible to just say "do the right thing" to the > application when creating new children (that is, expect that they will always > specify a tablespace if it's not the default), this seems like the > least-surprising behavior. > > It's true that an unpartitioned table will always be created in the default > tablespace unless otherwise specified, but child tables are sufficiently > distinct from that case that I don't see it as a painful asymmetry.
If there are no strong objections I am going to add this to the “Older Bugs” section of Open Items in a little bit. Jonathan