public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: me nefcanto <[email protected]>
To: [email protected]
Subject: Re: Please implement a catch-all error handler per row, for COPY
Date: Sat, 1 Mar 2025 08:31:08 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEHBEOCqqkSitU5gx=8aHD3ZeLtRy-1eC=Xs=xB-thFNR9JpYA@mail.gmail.com>
References: <CAEHBEOCqqkSitU5gx=8aHD3ZeLtRy-1eC=Xs=xB-thFNR9JpYA@mail.gmail.com>

On 3/1/25 07:18, me nefcanto wrote:
> Hello
> 
>
> All of these scenarios are such that data sanitation is difficult if not 
> possible before doing the bulk operation (copy).
> 
> I realized that when we specify `on_error ignore` it just handles a 
> handful of errors. I thought this was a bug and sent an email to the 
> pgsql-bugs maling list. But they said it's the intended behavior.
> 

Take a look at:

http://ossc-db.github.io/pg_bulkload/index.html

and

https://pgloader.io/

They may be able to meet your needs.

> 
> Regards
> Saeed

-- 
Adrian Klaver
[email protected]

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Please implement a catch-all error handler per row, for COPY
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox