Re: Notify client when a table was full

2018-01-22 Thread Vincenzo Romano
2018-01-22 14:58 GMT+01:00 John McKown : > On Mon, Jan 22, 2018 at 2:07 AM, Steve Atkins wrote: >> >> >> > On Jan 21, 2018, at 6:44 PM, Vincenzo Romano >> > wrote: >> > >> > 2018-01-21 19:31 GMT+01:00 Francisco Olarte : >> >> On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier >> >> wrote: >> >>> O

Re: Notify client when a table was full

2018-01-22 Thread John McKown
On Mon, Jan 22, 2018 at 2:07 AM, Steve Atkins wrote: > > > On Jan 21, 2018, at 6:44 PM, Vincenzo Romano < > vincenzo.rom...@notorand.it> wrote: > > > > 2018-01-21 19:31 GMT+01:00 Francisco Olarte : > >> On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier > >> wrote: > >>> On Fri, Jan 19, 2018 at 03

Re: Notify client when a table was full

2018-01-22 Thread Steve Atkins
> On Jan 21, 2018, at 6:44 PM, Vincenzo Romano > wrote: > > 2018-01-21 19:31 GMT+01:00 Francisco Olarte : >> On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier >> wrote: >>> On Fri, Jan 19, 2018 at 03:40:01PM +, Raymond O'Donnell wrote: >> ... How do you define "full"? > > The only pos

Re: Notify client when a table was full

2018-01-21 Thread Vincenzo Romano
2018-01-21 19:31 GMT+01:00 Francisco Olarte : > On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier > wrote: >> On Fri, Jan 19, 2018 at 03:40:01PM +, Raymond O'Donnell wrote: > ... >>> How do you define "full"? The only possible and meaningful case, IMHO, as stated by David earlier, is "file sys

Re: Notify client when a table was full

2018-01-21 Thread Francisco Olarte
On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier wrote: > On Fri, Jan 19, 2018 at 03:40:01PM +, Raymond O'Donnell wrote: ... >> 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

Re: Notify client when a table was full

2018-01-21 Thread Michael Paquier
On Fri, Jan 19, 2018 at 03:40:01PM +, 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.

Re: Notify client when a table was full

2018-01-19 Thread David G. Johnston
On Fri, Jan 19, 2018 at 8:47 AM, hmidi slim wrote: > I need to be notified when the table is full to launch a script whis dumps > this table. > ​Please don't top post. You are going to need to explain the entire process is greater detail if you want help. As Raymond said while I was writing, y

Re: Notify client when a table was full

2018-01-19 Thread hmidi slim
I need to be notified when the table is full to launch a script whis dumps this table. H.S 2018-01-19 16:44 GMT+01:00 David G. Johnston : > On Fri, Jan 19, 2018 at 8:34 AM, hmidi slim wrote: > >> Hi, >> I'm looking for a function in postgresql which notify the client if a >> table was full or n

Re: Notify client when a table was full

2018-01-19 Thread David G. Johnston
On Fri, Jan 19, 2018 at 8:34 AM, 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 acti

Re: Notify client when a table was full

2018-01-19 Thread Raymond O'Donnell
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 ta

Notify client when a table was full

2018-01-19 Thread hmidi slim
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