Re: ERROR : invalid transaction termination : PostgreSQL v12

Holger Jakobs <holger@jakobs.com> writes:
> Oracle's behaviour of saving all non-failing records while discarding 
> all failing records is not directly possible with PostgreSQL, because 
> the sense of a transaction is all-or-nothing.

There are external tools that can emulate row-at-a-time loading,
such as pgloader [1].  I'm not sure what sort of speed penalty
you pay for that, but I imagine it's not trivial.

            regards, tom lane

[1] https://pgloader.io