From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | hmidi slim <hmidi(dot)slim2(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Notify client when a table was full |
Date: | 2018-01-19 15:44:25 |
Message-ID: | CAKFQuwZR0fAAAAL05Gk6TjHhnjcPT_wJsc-H7XD4azua_31RAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | kpi6288 | 2018-01-19 15:46:21 | Use left hand column for null values |
Previous Message | Raymond O'Donnell | 2018-01-19 15:40:01 | Re: Notify client when a table was full |