Bug report #18021
no refresh using notify in postgis
| Status: | Open | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| 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 |
Description
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
History
#1
Updated by Sabin Kolarov about 6 years ago
Postgresql 10.3 and QGIS 3.2.2-Bonn.: the bug is still present.
#2
Updated by Giovanni Manghi about 6 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 almost 6 years ago
- File Capture.PNG added
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 almost 6 years ago
- Affected QGIS version changed from 3.2.2 to 3.4.2