I have an existing FME 2015 workspace that writes records to a PostgreSQL database.

With FME 2015, it writes 2626 records to the database.

With a FME 2018 workspace i count with SQLcreator the number of records in the PostgreSQL database using the next SQL statement.

Select

Nspname AS SchemaName, Relname, Reltuples

WHERE

Nspname NOT IN (' Pg_catalog ', ' information_schema ') AND

Relkind = ' R '

ORDER BY reltuples DESC;

It returns as result 2626 records

Now I open that same FME2015 workspace and save it as FME2018, I run that workspace again and it writes again 2626 Records.

Only, when I run workspace with the SQLcreator again, it returns as result only 1000 records.

In both cases, the PostgreSQL database has the correct number of records, only if they are written with 2015 The SQL statement gives the correct number of records and if they are written with 2018 then the SQLstatement gives a wrong number of records.