Notify client when a table was full

From: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Notify client when a table was full
Date: 2018-01-19 15:34:31
Message-ID: CAMsqVxsC0KNNra5t4Sd_A119U=MAXQqmZ7BmQpk0LimK=-qC7A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2018-01-19 15:40:01 Re: Notify client when a table was full
Previous Message Marco Nenciarini 2018-01-19 11:37:36 Re: [PATCH] Logical decoding of TRUNCATE