Running vacuum while executing the application

Поиск
Список
Период
Сортировка
От Raquel Vieira
Тема Running vacuum while executing the application
Дата
Msg-id 03051510034301.01123@rvieira
обсуждение исходный текст
Ответы Re: Running vacuum while executing the application  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi!

My application in C++ use a Postgres Database. I'm executing vacuum once a
day in my database with the application running at the same time (and
interacting with Postgres).
When I execute vacuum, I obtain this error in my application (while trying to
execute a query in Postgres):

[unixODBC]Error while executing the query (non-fatal);
ERROR:  RelationClearRelation: relation 1233323 modified while in use


Is there any problem to execute vacuum and trying to access to the database
at the same time?

Thank you.

Raquel

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

Предыдущее
От: Himmet Karaman
Дата:
Сообщение: Re: [GENERAL] TESTING the DATABASE
Следующее
От: Bruno Mattarollo
Дата:
Сообщение: Can't drop a table ...