Re: Server goes to Recovery Mode when run a SQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Server goes to Recovery Mode when run a SQL
Дата
Msg-id 572934.1597413823@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Server goes to Recovery Mode when run a SQL  (PegoraroF10 <marcos@f10.com.br>)
Ответы Re: Server goes to Recovery Mode when run a SQL  (PegoraroF10 <marcos@f10.com.br>)
Re: Server goes to Recovery Mode when run a SQL  (PegoraroF10 <marcos@f10.com.br>)
Список pgsql-general
PegoraroF10 <marcos@f10.com.br> writes:
> This is the way you can test to push your server immediatelly to recovery
> mode. This one you´ll get the problem instantaneously, differently from the
> last one which you have to wait a long time to happen.

When I try this I get

ERROR:  operator does not exist: smallint = text
LINE 2: ...eber_ID) filter (where ((status <> 6) or (TipoRecebimento in
                                                                     ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

which makes me wonder whether you've got a buggy custom operator.

            regards, tom lane



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

Предыдущее
От: Anass El Bouanani
Дата:
Сообщение: Postgres Clusterisation best choice ?
Следующее
От: Rene Romero Benavides
Дата:
Сообщение: Re: PostgreSQL 10.12. background writer not cleaning buffers, small working set, big shared_buffers