Postgres Pro
Downloads
Home   >   mailing lists

How to check whether table is busy or free before running the ALTERor creating TRIGGER on that table - Mailing list pgsql-general

From Raghavendra Rao J S V
Subject How to check whether table is busy or free before running the ALTERor creating TRIGGER on that table
Date
Msg-id CAEHH7R6MFc5j1+WWh=Nc_Lsvdc36DQD3-fmEDs9ANce4DjZ39A@mail.gmail.com
Whole thread Raw
Responses Re: How to check whether table is busy or free before running theALTER or creating TRIGGER on that table
List pgsql-general
Tree view
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 by date:

Previous
From: Zhiquan Simon Sui
Date:
Subject: Question about replication
Next
From: Adrian Klaver
Date:
Subject: Re: How to check whether table is busy or free before running theALTER or creating TRIGGER on that table