Re: Notify client when a table was full

Поиск
Список
Период
Сортировка
От Steve Atkins
Тема Re: Notify client when a table was full
Дата
Msg-id F81CEADA-15AF-4B70-BF8C-73F3365FCFBE@blighty.com
обсуждение исходный текст
Ответ на Re: Notify client when a table was full  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Ответы Re: Notify client when a table was full  (John McKown <john.archie.mckown@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Setting up streaming replication problems
Следующее
От: Bjørn T Johansen
Дата:
Сообщение: Re: pgaudit?