Ühel kenal päeval, L, 2007-12-15 kell 01:12, kirjutas Tom Lane: > Josh Berkus <[EMAIL PROTECTED]> writes: > > There's no way we can do a transactionless load, then? I'm thinking of the > > load-into-new-partition which is a single pass/fail operation. Would > > ignoring individual row errors in for this case still cause these kinds of > > problems? > > Given that COPY fires triggers and runs CHECK constraints, there is no > part of the system that cannot be exercised during COPY. So I think > supposing that we can just deal with some simplified subset of reality > is mere folly.
But can't we _define_ such a subset, where we can do a transactionless load ? I don't think that most DW/VLDB schemas fire complex triggers or custom data-modifying functions inside CHECK's. Then we could just run the remaining simple CHECK constraints ourselves and not abort on non-check, but just log the rows ? The COPY ... WITH ERRORS TO ... would essentially become a big conditional RULE through which the incoming data is processed. ------------------ Hannu ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
