> 2020年2月24日 下午9:34,Prabhat Sahu <prabhat.s...@enterprisedb.com> 写道: > > Hi All, > > I observe a different behavior in "temporary table" and "global temporary > table". > Not sure if it is expected? > > postgres=# create global temporary table parent1(a int) on commit delete > rows; > CREATE TABLE > postgres=# create global temporary table child1() inherits (parent1); > CREATE TABLE > postgres=# insert into parent1 values(1); > INSERT 0 1 > postgres=# insert into child1 values(2); > INSERT 0 1 > postgres=# select * from parent1; > a > --- > (0 rows) > > postgres=# select * from child1; > a > --- > (0 rows) Because child1 inherits its father's on commit property. I can make GTT behave like local temp table.
> > > postgres=# create temporary table parent2(a int) on commit delete rows; > CREATE TABLE > postgres=# create temporary table child2() inherits (parent2); > CREATE TABLE > postgres=# insert into parent2 values(1); > INSERT 0 1 > postgres=# insert into child2 values(2); > INSERT 0 1 > postgres=# select * from parent2; > a > --- > 2 > (1 row) > > postgres=# select * from child2; > a > --- > 2 > (1 row) > > > Thanks, > Prabhat Sahu >