Re: [PERFORM] psql -A (unaligned format) eats too much

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] psql -A (unaligned format) eats too much
Дата
Msg-id 15738.1149601723@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] psql -A (unaligned format) eats too much  (Hannu Krosing <hannu@skype.net>)
Ответы Re: [PERFORM] psql -A (unaligned format) eats too much  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
Hannu Krosing <hannu@skype.net> writes:
> Ühel kenal päeval, E, 2006-06-05 kell 14:10, kirjutas Tom Lane:
>> Note of course that such a thing would push the incomplete-result
>> problem further upstream.   For instance in (hypothetical --cursor
>> switch)
>>    psql --cursor -c "select ..." | myprogram
>> there would be no very good way for myprogram to find out that it'd
>> been sent an incomplete result due to error partway through the SELECT.

> would it not learn about it at the point of error ?

No, it would merely see EOF after some number of result rows.  (I'm
assuming you're also using -A -t so that the output is unadorned.)
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why do we want to %Remove behavior of postmaster -o
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: That EXPLAIN ANALYZE patch still needs work