Re: Notify client when a table was full

> On Jan 21, 2018, at 6:44 PM, Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> wrote:
>
> 2018-01-21 19:31 GMT+01:00 Francisco Olarte <folarte(at)peoplecall(dot)com>:
>> On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier
>> <michael(dot)paquier(at)gmail(dot)com> wrote:
>>> On Fri, Jan 19, 2018 at 03:40:01PM +0000, Raymond O'Donnell wrote:
>> ...
>>>> How do you define "full"?
>
> The only possible and meaningful case, IMHO, as stated by David
> earlier, is "file system full".

If your filesystem is full you're pretty much off the air. It's something
that should never happen on a production system. So ... any automation
around "the filesystem is full" is going to be much the same as "the server
is dead". You're unlikely to be able to do anything useful from the
app at that point, let alone from a trigger function.

If the answer involves handling the case where the file system is full we're
not answering a useful question, and the original poster probably needs to
clarify.

> Which is communicated by Postgres with the "Class 53 — Insufficient
> Resources" error codes.
> Please refer to official documentation like:
>
> https://www.postgresql.org/docs/10/static/errcodes-appendix.html
>
> For specific programming languages more details need to be checked.
>

Cheers,
Steve