Re: ESQL/C no indicator variables ./. error -213

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ESQL/C no indicator variables ./. error -213
Дата
Msg-id 1451504.1592415593@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ESQL/C no indicator variables ./. error -213  (Matthias Apitz <guru@unixarea.de>)
Ответы Re: ESQL/C no indicator variables ./. error -213
Список pgsql-general
Matthias Apitz <guru@unixarea.de> writes:
> We encountered that if our ESQL/C written servers see on SELECT or FETCH
> in a row a NULL value, it will raise correctly the error -213 as written
> and explained in https://www.postgresql.org/docs/11/ecpg-variables.html#ECPG-INDICATORS
> We catch this error -213 and deal with in.

> What we did not knew and discovered today is something very fatal: In
> such a situation on a FETCH of a row of some 55 columns, the transfer of
> the column elements into their hostvariables stops on first NULL value,
> as here to be seen in the log:

Could you provide a self-contained test case for this?  It's hard to
guess at what the problem might be.

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: Matthias Apitz
Дата:
Сообщение: ESQL/C no indicator variables ./. error -213
Следующее
От: "Jim Hurne"
Дата:
Сообщение: RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked