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"
+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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.