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

From Steve Atkins
Subject Re: Notify client when a table was full
Date
Msg-id F81CEADA-15AF-4B70-BF8C-73F3365FCFBE@blighty.com
Whole thread Raw
In response to Re: Notify client when a table was full  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: Notify client when a table was full  (John McKown <john.archie.mckown@gmail.com>)
List pgsql-general
> On Jan 21, 2018, at 6:44 PM, Vincenzo Romano <vincenzo.romano@notorand.it> wrote:
>
> 2018-01-21 19:31 GMT+01:00 Francisco Olarte <folarte@peoplecall.com>:
>> On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier
>> <michael.paquier@gmail.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

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Setting up streaming replication problems
Next
From: Bjørn T Johansen
Date:
Subject: Re: pgaudit?