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"
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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