Question

SQLExecuter update messages

  • 19 July 2018
  • 1 reply
  • 0 views

Badge

I have a workbench where features are updated in my postgresql database using the SQLexecuter. I am wondering if it is possible to view weather the update was successful or not? When SQLexecuter runs into an error I get the error message in the log but what I am looking for is more of what you see when you run a query in PGadmin "query executed successfully 250 features updated". what I really am interested in for QC purposes is "query executed successfully 0 features updated"


1 reply

Badge +2

We probably need a SQL guru to step in here. But I don't think you'll be able to see what you want in PGadmin. That will be a separate transaction to the one you used in FME's SQLExecutor transformer and the update messages will be lost or buried in the postgreSQL log files.

 

I suspect what you need to do is record the log message to a table with RAISE in the SQLExecutor. If you have any success with that please post the solution back to the community

Reply