How to check whether table is busy or free before running the ALTERor creating TRIGGER on that table

Поиск
Список
Период
Сортировка
От Raghavendra Rao J S V
Тема How to check whether table is busy or free before running the ALTERor creating TRIGGER on that table
Дата
Msg-id CAEHH7R6MFc5j1+WWh=Nc_Lsvdc36DQD3-fmEDs9ANce4DjZ39A@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to check whether table is busy or free before running theALTER or creating TRIGGER on that table  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
Hi All,

We have thousands of tables. Out of these tables we have few tables. Which are busy some times. If I execute any ALTER statement or creating trigger on those tables I am unable to do it. How to check whether table is busy or free before running the ALTER/DDL or creating TRIGGER on that table in postgresql database.

--
Regards,
Raghavendra Rao J S V

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

Предыдущее
От: Zhiquan Simon Sui
Дата:
Сообщение: Question about replication
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to check whether table is busy or free before running theALTER or creating TRIGGER on that table