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
--
__
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
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