How can I tell if pg_restore is running?

Поиск
Список
Период
Сортировка
От Moshe Jacobson
Тема How can I tell if pg_restore is running?
Дата
Msg-id CAJ4CxLnPbq8nuaYcsJfxSQcnXNM8j8W1GRyweORQqsp=RSwJCw@mail.gmail.com
обсуждение исходный текст
Ответы Re: How can I tell if pg_restore is running?  (Keith Fiske <keith@omniti.com>)
Re: How can I tell if pg_restore is running?  (Martin French <Martin.French@romaxtech.com>)
Re: How can I tell if pg_restore is running?  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-general
My extension has a config table that is dumped by pg_dump and populated by pg_restore.
However, this table has triggers on it that I would like not to do anything if the table is being populated by pg_restore. I want the triggers to operate only if the user is manipulating the table directly after the database has been restored and is running.

Is there a way for my extension's trigger functions to return immediately when triggered by pg_restore?

Thanks.

Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_standby replication problem
Следующее
От: Keith Fiske
Дата:
Сообщение: Re: How can I tell if pg_restore is running?