Re: Prevent COPY FREEZE on Foreign tables

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: Prevent COPY FREEZE on Foreign tables
Дата
Msg-id Z6O69xg5qNT7y4DW@nathan
обсуждение исходный текст
Ответы Re: Prevent COPY FREEZE on Foreign tables
Список pgsql-hackers
On Wed, Feb 05, 2025 at 01:05:32PM -0600, Sami Imseih wrote:
>> Instead of throwing an error, how about we turn that into a warning?
>> This way, if someone is batch-importing data for multiple tables, it won´t interrupt their script that generates a
COPYfor each table.
 
>> Is it better to give them a heads-up without making them modify their commands right away?
> 
> Hmm, I prefer we error out the transaction as it can be difficult
> to detect a warning and the user will assume that the
> transaction completed. Also, we currently error out when
> copy freeze is on a parent partition, so I rather we keep
> this behavior consistent.

Yeah, I'd rather error out than expect users to respond to warnings to the
effect of "hey, you told us to do something, but we did something else that
isn't what you asked us to do."  That both retains the broken feature and
adds more noise, neither of which seems desirable.

-- 
nathan



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