On Fri, Jan 19, 2018 at 03:40:01PM +0000, Raymond O'Donnell wrote: > On 19/01/18 15:34, hmidi slim 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? > > How do you define "full"? There could be two definitions here: 1) A table contains more data than a customly-defined amount of data on-disk. 2) The partition where the table data is located runs out of disk space. -- Michael
Attachment:
signature.asc
Description: PGP signature
