listen/notify not working in pgadmin 4 2.1

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

listen/notify not working in pgadmin 4 2.1

Derek Ealy
I was trying to test a notify/listen channel but couldn't get things working in PGAdmin4. I'm running it in server mode with Python on Linux. Eventually I went back to PGAdmin3 and listened on the same channel and everything worked fine. When the notification happened I simply ran: select 1; in the same connection and the notify data appeared in the messages tab as expected.

When I try the same thing in PGAdmin4 there are no errors, but I cannot see anything indicating that a notification was published.

Is there some other/better way of listening for and seeing notifications in PGAdmin4?

Thanks, Derek

--
dme


Derek Ealy
Sr. Software Architect

NovaWurks, Inc. 
10772 Noel Street 
Los Alamitos, CA 90720
P: <a href="tel:562.340.6270%20x%20700" value="+15623406270" style="color:rgb(17,85,204)" target="_blank">562.340.6270 
F: <a href="tel:877.353.7537" value="+18773537537" style="color:rgb(17,85,204)" target="_blank">877.353.7537  
C: <a href="tel:801.319.4613" value="+18013194613" style="color:rgb(17,85,204)" target="_blank">310.936.4070

........................................
CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: listen/notify not working in pgadmin 4 2.1

Khushboo Vashi


On Tue, Mar 13, 2018 at 7:56 PM, Derek Ealy <[hidden email]> wrote:
I was trying to test a notify/listen channel but couldn't get things working in PGAdmin4. I'm running it in server mode with Python on Linux. Eventually I went back to PGAdmin3 and listened on the same channel and everything worked fine. When the notification happened I simply ran: select 1; in the same connection and the notify data appeared in the messages tab as expected.

When I try the same thing in PGAdmin4 there are no errors, but I cannot see anything indicating that a notification was published.

If you are facing this kind of issue mentioned in the RM then, it has been fixed.
You will get a fix in the upcoming release which is going to be happened very soon.
Is there some other/better way of listening for and seeing notifications in PGAdmin4?

Thanks, Derek

--
dme


Derek Ealy
Sr. Software Architect

NovaWurks, Inc. 
P: <a href="tel:562.340.6270%20x%20700" value="+15623406270" style="color:rgb(17,85,204)" target="_blank">562.340.6270 
F: <a href="tel:877.353.7537" value="+18773537537" style="color:rgb(17,85,204)" target="_blank">877.353.7537  
C: <a href="tel:801.319.4613" value="+18013194613" style="color:rgb(17,85,204)" target="_blank">310.936.4070

........................................
CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.

Reply | Threaded
Open this post in threaded view
|

Re: listen/notify not working in pgadmin 4 2.1

Derek Ealy
I don't think this is the same problem as issue 3094 because I never see the notification at all, whereas the description of issue 3094 says that the notification does appear eventually.

On Tue, Mar 13, 2018 at 7:45 AM, Khushboo Vashi <[hidden email]> wrote:


On Tue, Mar 13, 2018 at 7:56 PM, Derek Ealy <[hidden email]> wrote:
I was trying to test a notify/listen channel but couldn't get things working in PGAdmin4. I'm running it in server mode with Python on Linux. Eventually I went back to PGAdmin3 and listened on the same channel and everything worked fine. When the notification happened I simply ran: select 1; in the same connection and the notify data appeared in the messages tab as expected.

When I try the same thing in PGAdmin4 there are no errors, but I cannot see anything indicating that a notification was published.

If you are facing this kind of issue mentioned in the RM then, it has been fixed.
You will get a fix in the upcoming release which is going to be happened very soon.
Is there some other/better way of listening for and seeing notifications in PGAdmin4?

Thanks, Derek

--
dme


Derek Ealy
Sr. Software Architect

NovaWurks, Inc. 
P: <a href="tel:562.340.6270%20x%20700" value="+15623406270" style="color:rgb(17,85,204)" target="_blank">562.340.6270 
F: <a href="tel:877.353.7537" value="+18773537537" style="color:rgb(17,85,204)" target="_blank">877.353.7537  
C: <a href="tel:801.319.4613" value="+18013194613" style="color:rgb(17,85,204)" target="_blank">310.936.4070

........................................
CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.




--
dme


Derek Ealy
Sr. Software Architect

NovaWurks, Inc. 
10772 Noel Street 
Los Alamitos, CA 90720
P: <a href="tel:562.340.6270%20x%20700" value="+15623406270" style="color:rgb(17,85,204)" target="_blank">562.340.6270 
F: <a href="tel:877.353.7537" value="+18773537537" style="color:rgb(17,85,204)" target="_blank">877.353.7537  
C: <a href="tel:801.319.4613" value="+18013194613" style="color:rgb(17,85,204)" target="_blank">310.936.4070

........................................
CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: listen/notify not working in pgadmin 4 2.1

Khushboo Vashi
Hi Derek,

On Tue, Mar 13, 2018 at 8:23 PM, Derek Ealy <[hidden email]> wrote:
I don't think this is the same problem as issue 3094 because I never see the notification at all, whereas the description of issue 3094 says that the notification does appear eventually.


Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4  with details.
Also, add steps to reproduce the issue.
 
Thanks,
Khushboo

On Tue, Mar 13, 2018 at 7:45 AM, Khushboo Vashi <[hidden email]> wrote:


On Tue, Mar 13, 2018 at 7:56 PM, Derek Ealy <[hidden email]> wrote:
I was trying to test a notify/listen channel but couldn't get things working in PGAdmin4. I'm running it in server mode with Python on Linux. Eventually I went back to PGAdmin3 and listened on the same channel and everything worked fine. When the notification happened I simply ran: select 1; in the same connection and the notify data appeared in the messages tab as expected.

When I try the same thing in PGAdmin4 there are no errors, but I cannot see anything indicating that a notification was published.

If you are facing this kind of issue mentioned in the RM then, it has been fixed.
You will get a fix in the upcoming release which is going to be happened very soon.
Is there some other/better way of listening for and seeing notifications in PGAdmin4?

Thanks, Derek

--
dme


Derek Ealy
Sr. Software Architect

NovaWurks, Inc. 
P: <a href="tel:562.340.6270%20x%20700" value="+15623406270" style="color:rgb(17,85,204)" target="_blank">562.340.6270 
F: <a href="tel:877.353.7537" value="+18773537537" style="color:rgb(17,85,204)" target="_blank">877.353.7537  
C: <a href="tel:801.319.4613" value="+18013194613" style="color:rgb(17,85,204)" target="_blank">310.936.4070

........................................
CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.




--
dme


Derek Ealy
Sr. Software Architect

NovaWurks, Inc. 
P: <a href="tel:562.340.6270%20x%20700" value="+15623406270" style="color:rgb(17,85,204)" target="_blank">562.340.6270 
F: <a href="tel:877.353.7537" value="+18773537537" style="color:rgb(17,85,204)" target="_blank">877.353.7537  
C: <a href="tel:801.319.4613" value="+18013194613" style="color:rgb(17,85,204)" target="_blank">310.936.4070

........................................
CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.

Previous Thread Next Thread