Re: [HACKERS] COPY vs. transition tables

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: [HACKERS] COPY vs. transition tables
Дата
Msg-id CAEepm=3g6oS4Ko7t7+vorX5LSHMiyGXJHYor=2WigTAob2z3OQ@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] COPY vs. transition tables  (David Fetter <david@fetter.org>)
Ответы Re: [HACKERS] COPY vs. transition tables  (David Fetter <david@fetter.org>)
Re: [HACKERS] COPY vs. transition tables  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
On Sat, Jul 8, 2017 at 8:42 PM, David Fetter <david@fetter.org> wrote:
> Using the script attached, I'm getting this very odd result set below.
>
> Audit records from COPY to the "foo bar" table aren't getting
> recorded, but audit records from COPY to the baz table are.

Thanks for the bug report.  I think it's the presence of the index on
"foo bar", not the space in its name (but thanks for that curve
ball!), that causes these tuples not to be captured.
CopyFromInsertBatch takes a different path depending on whether there
are any indexes, and mistakenly passes NULL for transition_capture.
The attached seems to fix it, but I'll look more closely and send a
version with a regression test on Monday.

-- 
Thomas Munro
http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

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

Предыдущее
От: Mark Rofail
Дата:
Сообщение: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Следующее
От: David Fetter
Дата:
Сообщение: Re: [HACKERS] COPY vs. transition tables