Re: Notify client when a table was full

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(dot)g(dot)johnston(at)gmail(dot)com>:

> On Fri, Jan 19, 2018 at 8:34 AM, hmidi slim <hmidi(dot)slim2(at)gmail(dot)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.
>