Notify client when a table was full

Поиск
Список
Период
Сортировка
От hmidi slim
Тема Notify client when a table was full
Дата
Msg-id CAMsqVxsC0KNNra5t4Sd_A119U=MAXQqmZ7BmQpk0LimK=-qC7A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Notify client when a table was full  (Raymond O'Donnell <rod@iol.ie>)
Re: Notify client when a table was full  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Hi,
I'm looking for a function in postgresql which notify the client if a table was full or not.So I found the function Notify https://www.postgresql.org/docs/9.0/static/sql-notify.html.
This function send a notification when a new action was done to the table. Is there a way to send a notification only  when the table was full and no future actions (insertion of new rows for examples) will be done. I was connected to an external api and saving the data received from it to a postgres database and I want to be notified when the table was full and no rows will be inserted. Does it realizable or Should I create a trigger and listens for every insertion and notify the client?

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

Предыдущее
От: Bjørn T Johansen
Дата:
Сообщение: pgaudit?
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Notify client when a table was full