[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: ERROR : invalid transaction termination : PostgreSQL v12
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2020-11-24 21:21:34
Message-ID: 310681.1606252894 () sss ! pgh ! pa ! us
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]