Re: Partitioned TEMP tables

Ed Behn <ed(dot)behn(at)rockwellcollins(dot)com> writes:
> I tried that. I didn't seem to help.

Well, it works in a simple test case for me. You'll need to post a
self-contained example that's not working if you want much help ...

regression=# create temp table pp(f1 int, f2 text);
CREATE TABLE
regression=# create temp table c1(check(f1 between 0 and 1)) inherits(pp);
CREATE TABLE
regression=# create temp table c2(check(f1 between 1 and 2)) inherits(pp);
CREATE TABLE
regression=# explain select * from pp where f1 < 1;
QUERY PLAN
------------------------------------------------------------
Append (cost=0.00..25.88 rows=424 width=36)
-> Seq Scan on pp (cost=0.00..0.00 rows=1 width=36)
Filter: (f1 < 1)
-> Seq Scan on c1 (cost=0.00..25.88 rows=423 width=36)
Filter: (f1 < 1)
(5 rows)

regression=# explain select * from pp where f1 > 1;
QUERY PLAN
------------------------------------------------------------
Append (cost=0.00..25.88 rows=424 width=36)
-> Seq Scan on pp (cost=0.00..0.00 rows=1 width=36)
Filter: (f1 > 1)
-> Seq Scan on c2 (cost=0.00..25.88 rows=423 width=36)
Filter: (f1 > 1)
(5 rows)

regards, tom lane