Bug report #18021

no refresh using notify in postgis

Added by Lee Han about 5 years ago. Updated about 4 years ago.

Category:Data Provider/PostGIS
Affected QGIS version:3.4.2 Regression?:No
Operating System:windows 7 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:25917


following this : http://oslandia.com/en/2017/10/07/refresh-your-maps-from-postgresql/.
I checked the two boxes in the rendering tab, and used 'refresh qgis' message.
Then in a psql shell, I write listen qgis,
I import a shp in my database,
I write Notify qgis, 'refresh qgis' ;
All that I get in return is : Asynchronous notification "qgis" with payload "refresh qgis" received from server process with PID 1848
And the canevas is unchanged.
Did I miss something ?

Postgres 9.3 ; qgis 2.99 ; windows 7

Capture.PNG (5.33 KB) Lee Han, 2018-12-04 09:35 AM


#1 Updated by Sabin Kolarov over 4 years ago

Postgresql 10.3 and QGIS 3.2.2-Bonn.: the bug is still present.

#2 Updated by Giovanni Manghi over 4 years ago

  • Affected QGIS version changed from master to 3.2.2
  • Subject changed from no refresh using notify in postgis and qgis 2.99 to no refresh using notify in postgis

#3 Updated by Lee Han about 4 years ago

Qgis 3.4.2, postgres 9.6, postgis 2.3, windows 7

I followed the same method to get the map refreshed automatically but unsuccessfully.
I tried with an import and an update on a feature this time,
each time I wrote NOTIFY QGIS, 'refresh qgis' in psql,
no change in the map.

#4 Updated by Giovanni Manghi about 4 years ago

  • Affected QGIS version changed from 3.2.2 to 3.4.2

Also available in: Atom PDF