Re: Notify client when a table was full - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Notify client when a table was full
Date
Msg-id 2f4c0da8-9ae8-4262-667e-538d5f6f67ec@iol.ie
Whole thread Raw
In response to Notify client when a table was full  (hmidi slim <hmidi.slim2@gmail.com>)
Responses Re: Notify client when a table was full  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
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"?

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


pgsql-general by date:

Previous
From: hmidi slim
Date:
Subject: Notify client when a table was full
Next
From: "David G. Johnston"
Date:
Subject: Re: Notify client when a table was full