po 24. 2. 2020 v 14:34 odesílatel Prabhat Sahu < [email protected]> napsal:
> 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) > It is bug. Probably INHERITS clause is not well implemented for GTT > > 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 > >
