pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.53k stars 656 forks source link

Notify/Listen not working in version 2.1 (RM #3204) #1732

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3204 Originally created by Derek Ealy at 2018-03-13 17:33:55 UTC.

Notifications are not appearing in PGAdmin 4 v2.1

Running PGAdmin in server mode on Linux with Python. If I listen for a channel in a query window, and then execute a notify on that channel in another connection, there is no notification I can find in PGAdmin 4. I've verified that that the notifications are working properly by using PGAdmin III to listen on on the channel. When using PGAdmin III the notification appears in the messages tab.

Steps to reproduce:

  1. Start a new query tool window, and execute: listen "foo";
  2. In some other connection to the same DB execute: select pg_notify('foo', 'bar'); --I get the same behavior if using: NOTIFY 'foo', 'bar';
  3. Back in the original PGAdmin 4 query tool window there is no indication of a notification arriving on that connection.
  4. Still in the original PGAdmin 4 query tool window execute: select 1;
  5. There is still no indication of a notification on the "foo" channel which is what was listened for in step 1
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-1 Originally created by Akshay Joshi at 2018-04-06 10:44:43 UTC.

Redmine ticket header update:

Name Old Value New Value
Tracker changed Bug Feature
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-2 Originally created by Akshay Joshi at 2018-05-04 10:58:56 UTC.

Redmine ticket header update:

Name Old Value New Value
Priority changed Normal High
Sprint changed Ready
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-3 Originally created by Akshay Joshi at 2018-05-09 09:52:49 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready EDB Sprint 14
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-4 Originally created by Akshay Joshi at 2018-05-14 12:15:22 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Akshay Joshi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-5 Originally created by Akshay Joshi at 2018-05-15 10:02:27 UTC.

Patch Sent: https://www.postgresql.org/message-id/CANxoLDcfwOXs6GcNhDUiEZmpdA9o4jYhNn7RQGskfx_HNcpgMg@mail.gmail.com

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-6 Originally created by Akshay Joshi at 2018-05-23 09:37:42 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 14 EDB Sprint 15
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-7 Originally created by Dave Page at 2018-05-31 01:56:17 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.1
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-8 Originally created by Akshay Joshi at 2018-05-31 01:58:34 UTC.

Applied in changeset commit:38ee39ae7acb32e331f0ba291e1036d721de8eb4.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3204#note-9 Originally created by Fahar Abbas at 2018-06-04 07:35:11 UTC.

This is resolved in Windows 2016 server 64 bit on chrome browsers. https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2018-06-04/

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.