Re: Save failed records into auxiliary table

Поиск
Список
Период
Сортировка
От Il Mimo di Creta
Тема Re: Save failed records into auxiliary table
Дата
Msg-id CAPDeFrdtJ54Tq2NVr3ywsHiE3bVz=8=B4dHq0jOUPOhNDo9y+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Save failed records into auxiliary table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Thank you David,
I tried other solutions, but at this point I agree this looks like the most viable way to solve the problem.

Thank you for your help


On Thu, Nov 12, 2020 at 4:26 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Nov 12, 2020 at 2:01 AM Il Mimo di Creta <mimo.creta@gmail.com> wrote:
I would like to save such records, and only such records, in an auxiliary table.

You will probably need to resort to loading the incoming data into an unlogged (and consider temporary) staging table then executing one query to load the known good data into the main table and a second query to load the known bad data into the auxiliary table.  For me this is the most direct solution generally anyway and should be used absent a performance problem necessitating optimization work.

Upsert isn't going to help you load incoming data into an auxiliary table, it can only adjust the data to avoid the conflict relative to the referenced table.

David J.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Working with partition tables
Следующее
От: John Scalia
Дата:
Сообщение: Re: Working with partition tables