Re: pg_relation_size locking

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pg_relation_size locking
Дата
Msg-id 20051212160552.GA22135@surnet.cl
обсуждение исходный текст
Ответ на Re: pg_relation_size locking  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:

> In the above example, the contrib code would have not done the right
> thing at all --- if I'm not mistaken, it would have kept handing back
> the size of the original, pre-TRUNCATE file, since the new pg_class
> row with the new relfilenode isn't committed yet.  So it wouldn't have
> done what you wish anyway.

It wouldn't have worked anyway because it used the Oid to search the
file, not the relfilenode.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_relation_size locking
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Different length lines in COPY CSV