Is there a way to catch "Raise Warning" and "Raise Notice" (while editing PostGIS-Layers) from a PostgreSQL/PostGIS-Trigger-Function within QGIS? One example: I have a trigger that reacts to insert or update-events and sends back notices to the client.In QGIS i just get messages from raise exeption but not notices or warnings.

I found a old question ( How do I catch PostGIS/PostgreSQL RAISE messages in QGIS? ) but I can't imagine that QGIS is still not capable of catching these important "feedbacks" from the Database, especially as it has its origin in working together with PostGIS. Does anyone know more about that?

  • Is there a ticket in the bug tracker for handling such events? – Nathan W Feb 11 '15 at 9:13
  • Just a thought on a halfway workaround. Can you raise the warning and notice as an exception in Postgresql. That is use the exception to deliver the warning and notice to QGIS – Jakob Feb 11 '15 at 9:39
  • @NathanW No not as far as I know. Can I open a ticket there or does this has to be tone by a developer? – gis_analyst05 Feb 11 '15 at 9:55
  • @Jacob thanks for the workaround idea but I want to make a difference between notices/warnings and exeptions. The best option would be if the notices would be displayed like in a console, so that I could inform the user how many loops already are done and how many are left... – gis_analyst05 Feb 11 '15 at 9:58
  • You can open one here hub.qgis.org/wiki/quantum-gis/Bugreports – Nathan W Feb 11 '15 at 10:13

This seems to be implemented in the meantime: http://hub.qgis.org/issues/12184#change-59414

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.