On Sat, 2008-05-03 at 09:11 -0700, Christophe wrote: > I will have a log table which, once a day or so, is copied to a file > (for movement to a data warehouse), and the log table emptied.
... > Is there a better way to handle this kind of thing that I'm > missing? Anyone care to comment about whether a table partition might be better here? Could an insert rule on a table partition automatically create the inherited table, if needed, and insert there? Thanks, Reece -- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0