Re: field error on refreshed materialized view

2024-01-27 Thread Tom Lane
Michael Nolan writes: > 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'

Re: field error on refreshed materialized view

2024-01-27 Thread Michael Nolan
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 t