Hi, I seem to recall that in Oracle you load into specific partitions
without specifically naming them in insert statements (in other words you
insert into table, the engine redirects data to the corrisponding
partition), I quickly looked at postgresql partitioning and it seems to me
that you need
On Fri, 2005-09-23 at 12:30 +0200, Paolo Magnoli wrote:
It would be good to have an insert behaviour similar to Oracle by default.
OK, thanks.
Also I see that the original table is always scanned, partition exclusion
happens only on the derived tables, is this correct?
Yes, though if you
Paolo Magnoli wrote:
Hi, I seem to recall that in Oracle you load into specific partitions
without specifically naming them in insert statements (in other words you
insert into table, the engine redirects data to the corrisponding
partition),
This is correct
--