On Fri, Jan 19, 2018 at 8:34 AM, hmidi slim <hmidi.sl...@gmail.com> wrote:
> 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? > The only way a table becomes "full" is if you run out of disk space - and you should be monitoring that at the O/S level and not at a database table level... As for clients - if they are inserting data they will simply get failures when they attempt to do so - for me that seems like sufficient notification for something that should rarely if ever happen. David J.