Re: Selecting large tables gets killed

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: Selecting large tables gets killed
Дата
Msg-id E2DBCFEEAE18C1FE69040BC3@apophis.credativ.lan
обсуждение исходный текст
Ответ на Re: Selecting large tables gets killed  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Selecting large tables gets killed  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers

--On 20. Februar 2014 09:51:47 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Yeah.  The other reason that you can't just transparently change the
> behavior is error handling: people are used to seeing either all or
> none of the output of a query.  In single-row mode that guarantee
> fails, since some rows might get output before the server detects
> an error.

That's true. I'd never envisioned to this transparently either, exactly of 
this reason. However, i find to have single row mode somewhere has some 
attractiveness, be it only to have some code around that shows how to do it 
right. But i fear we might complicate things in psql beyond what we really 
want.

-- 
Thanks
Bernd



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: WAL Rate Limiting
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: WAL Rate Limiting