FME tells me that there was 1 feature written to the database, but it is not true. In my opinion that’s a bug because the statement is objectively wrong.
In this case the translation failed because of an error. No features were written to the database. No table was created. I guess FME counts the schema feature, although it is NOT written to the database.
Here’s a part of the log and the workspace is attached.
POSTGRES Writer: Fanout for feature type 'SQLCreator' failed to find feature type template 'schema_from_query'
POSTGRES writer: An error has occurred. Check the logfile above for details
Successfully closed POSTGRES database writer
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Feature output statistics for `POSTGRES' writer using keyword `POSTGRES_1':
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Features Written
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
SQLCreator 1
==============================================================================
Total Features Written 1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Translation FAILED with 2 error(s) and 2 warning(s) (1 feature(s) output)
FME Session Duration: 3.4 seconds. (CPU: 0.2s user, 2.0s system)
END - ProcessID: 7120, peak process memory usage: 50976 kB, current process memory usage: 50976 kB
WARNING: there is no transaction in progress
POSTGRES writer: An error has occurred. Check the logfile above for details
Program Terminating
Translation FAILED.