From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Notify client when a table was full |
Date: | 2018-01-19 15:40:01 |
Message-ID: | 2f4c0da8-9ae8-4262-667e-538d5f6f67ec@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-01-19 15:44:25 | Re: Notify client when a table was full |
Previous Message | hmidi slim | 2018-01-19 15:34:31 | Notify client when a table was full |