Re: Save failed records into auxiliary table

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Save failed records into auxiliary table
Дата
Msg-id CAKFQuwYYZFvhSvSQ0phhcbNyb42uOtLm5aaQq+9eDz-m+7PRjg@mail.gmail.com
обсуждение исходный текст
Ответ на Save failed records into auxiliary table  (Il Mimo di Creta <mimo.creta@gmail.com>)
Ответы Re: Save failed records into auxiliary table
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: MichaelDBA
Дата:
Сообщение: Re: Two postgres masters
Следующее
От: John Scalia
Дата:
Сообщение: Working with partition tables