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 avoid placing any rows in that table it is quick.
I expect to remove that restriction in 8.2 by declarative SQL.
Best Regards, Simon Riggs