Re: field error on refreshed materialized view

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Re: field error on refreshed materialized view
Дата
Msg-id CAOzAquK_y4L3pqhU5iq=DKEEg9=eCSu4YJ+e-i0VAtb1HNfNuw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: field error on refreshed materialized view  (Michael Nolan <htfoot@gmail.com>)
Ответы Re: field error on refreshed materialized view
Список pgsql-general
Followup:  The problem turned out to be a field in the mysql server
that was not size-limited to 255 characters and had several rows with
as many as 299 characters in them.  Apparently when using an FDW and
materialized view in postgresql 10.4, field size limits aren't
checked, because a query on the matview in the 10.4 system finds those
records with more than 255 characters in that field.

So, not a character encoding issue at all.
--
Mike Nolan



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

Предыдущее
От: pf@pfortin.com
Дата:
Сообщение: Re: permission denied on socket
Следующее
От: Tom Lane
Дата:
Сообщение: Re: field error on refreshed materialized view