Re: [SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-06-01 Thread Dean le Roux
I installed the recommended JDBC driver. Set it up to connect using Open office. Still need to test to see how the queries build now, but problem is that the access to the database is dramatically slower than using the sdbc. Is this to be expected. thanks. On 05/24/2011 07:58 AM, Dean le Ro

[SQL] 9.0+ way of determining if a LISTEN channel has a backend listening?

2011-06-01 Thread James Robinson
Is there a way in post-9.0 postgres for one session to determine if a LISTEN channel currently has a backend registered to receive notifications? Prior to 9.0, one could select from system catalog table pg_listener. Function pg_listening_channels() returns list of symbol names *this* sess

Re: [SQL] 9.0+ way of determining if a LISTEN channel has a backend listening?

2011-06-01 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > Is there a way in post-9.0 postgres for one session to determine if a > LISTEN channel currently has a backend registered to receive > notifications? No, there is no way. As mentioned on a similar thread on -hackers, you could possibly u