Re: Notify client when a table was full
| От | David G. Johnston |
|---|---|
| Тема | Re: Notify client when a table was full |
| Дата | |
| Msg-id | CAKFQuwZR0fAAAAL05Gk6TjHhnjcPT_wJsc-H7XD4azua_31RAw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Notify client when a table was full (hmidi slim <hmidi.slim2@gmail.com>) |
| Ответы |
Re: Notify client when a table was full
|
| Список | pgsql-general |
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?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.
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.
В списке pgsql-general по дате отправления: