Re: WIP patch: Improve relation size functions such as pg_relation_size() to avoid producing an error when called against a no longer visible relation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WIP patch: Improve relation size functions such as pg_relation_size() to avoid producing an error when called against a no longer visible relation
Дата
Msg-id 17463.1324578833@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WIP patch: Improve relation size functions such as pg_relation_size() to avoid producing an error when called against a no longer visible relation  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: WIP patch: Improve relation size functions such as pg_relation_size() to avoid producing an error when called against a no longer visible relation  (Phil Sorber <phil@omniti.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I'm wondering if we oughta just return NULL and be done with it.

+1.  There are multiple precedents for that sort of response, which we
introduced exactly so that "SELECT some_function(oid) FROM some_catalog"
wouldn't fail just because one of the rows had gotten deleted by the
time the scan got to it.  I don't think it's necessary for the
relation-size functions to be any smarter.  Indeed, I'd assumed that's
all that Phil's patch did, since I'd not looked closer till just now.
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: WIP patch: Improve relation size functions such as pg_relation_size() to avoid producing an error when called against a no longer visible relation
Следующее
От: Jignesh Shah
Дата:
Сообщение: Re: Page Checksums + Double Writes