Re: Adding tests for inheritance trees with temporary tables
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Cc: Postgres hackers <pgsql-hackers@postgresql.org>
Date: 2018-06-20T06:09:55Z
Lists: pgsql-hackers
Attachments
- inherit-temp-tests-v2.patch (text/x-diff) patch v2
On Tue, Jun 19, 2018 at 01:04:43PM +0530, Ashutosh Bapat wrote: > Thanks. Some review comments here. Thanks for the review! > +create table inh_perm_parent (a1 int); > +create temp table inh_temp_parent (a1 int); > +create temp table inh_temp_child (a1 int) inherits (inh_perm_parent); -- ok > +NOTICE: merging column "a1" with inherited definition > > You could actually avoid this notice by changing create table statement like > create temp table inh_temp_child () inherits (inh_perm_parent); Okay, fixed. > select tabloid::regclass will also print the name of the table where > the row resides. That will be useful to check where the rows come from > and also to test the inheritance children. Good point, I have added those. Except that you meant tableoid::regclass. -- Michael
Commits
-
Add tests for inheritance trees mixing permanent and temporary relations
- 9994013ff32c 12.0 landed