Josh Berkus <josh@agliodbs.com> 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.
regards, tom lane