Re: BUG #14164: Postgres allow to insert more data into field than this field allow

To my mind, postgres should not rely on third party code and write broken data to the disk.
I suppose this may override other records (even those the user have no access) which are stored close to this broken one if data in the 'text' field of mysql are large enough.

And, yes, mysql_fdw, should also do checks for data constistency

30.05.2016, 20:10, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> kes-kes(at)yandex(dot)ru writes:
>>  Because of type of column of source and destination tables are equal
>>  postgres does not check actual data so very long data at text field of mysql
>>  database is inserted into limited field at postgres DB.
>
> I would say this is a bug in mysql_fdw, not Postgres proper. In general
> it's the responsibility of an FDW to ensure that data it passes back
> meets the constraints of the foreign table declaration.
>
>                         regards, tom lane