On 2019/05/17 12:40, Rushabh Lathia wrote: > Hi, > > Consider the below test: > > create tablespace mytbs location '/home/rushabh/mywork/workspace/pg/'; > create table test ( a int , b int ) partition by list (a); > > set default_tablespace to mytbs; > create table test_p1 partition of test for values in (1); > > In the above test, after the setting the default_tablespace I am creating > a partition table and expecting that to get created under "mytbs" > tablespace. > > But that is not the case: > > postgres@66247=#select relname, reltablespace from pg_class where relname = > 'test_p1'; > relname | reltablespace > ---------+--------------- > test_p1 | 0 > (1 row) > > I noticed the behaviour change for default_tablespace with partition table > with below commit. > > commit 87259588d0ab0b8e742e30596afa7ae25caadb18 > Author: Alvaro Herrera <alvhe...@alvh.no-ip.org> > Date: Thu Apr 25 10:20:23 2019 -0400 > > Fix tablespace inheritance for partitioned rels > > Commit ca4103025dfe left a few loose ends. The most important one > (broken pg_dump output) is already fixed by virtue of commit > 3b23552ad8bb, but some things remained: > > I don't think that new behaviour is intended
Should we add this to open items? Thanks, Amit
