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

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How to check whether table is busy or free before running the ALTER or creating TRIGGER on that table
Date: 2018-08-21 13:25:33
Message-ID: CAEHH7R6MFc5j1+WWh=Nc_Lsvdc36DQD3-fmEDs9ANce4DjZ39A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-08-21 14:17:08 Re: How to check whether table is busy or free before running the ALTER or creating TRIGGER on that table
Previous Message Zhiquan Simon Sui 2018-08-21 00:46:20 Question about replication