I need to be notified when the table is full to launch a script whis dumps this table.
H.S 2018-01-19 16:44 GMT+01:00 David G. Johnston <david.g.johns...@gmail.com>: > 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. >