Re: [HACKERS] Listen/Notify payload and interfaces

2010-02-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 >> No - there's a note in the code to look into that at some point. So >> stick to ASCII for the moment. I'm sure the great DBD::Pg utf-8 >> overhaul (where we get rid of the pg_enable_utf8 hack) will encompass >> payloads as well. > Is that

Re: [HACKERS] Listen/Notify payload and interfaces

2010-02-18 Thread David E. Wheeler
On Feb 18, 2010, at 1:01 PM, Greg Sabino Mullane wrote: >> Is the payload decoded to utf8 when pg_enable_utf8 is true? > > No - there's a note in the code to look into that at some point. So > stick to ASCII for the moment. I'm sure the great DBD::Pg utf-8 > overhaul (where we get rid of the pg

Re: [HACKERS] Listen/Notify payload and interfaces

2010-02-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > Is the payload decoded to utf8 when pg_enable_utf8 is true? No - there's a note in the code to look into that at some point. So stick to ASCII for the moment. I'm sure the great DBD::Pg utf-8 overhaul (where we get rid of the pg_enable_utf8

Re: [HACKERS] Listen/Notify payload and interfaces

2010-02-17 Thread David E. Wheeler
On Feb 17, 2010, at 10:04 AM, Greg Sabino Mullane wrote: > while (my $notify = $dbh->pg_notifies) { > my ($name, $pid, $payload) = @$notify; > print qq{I received notice "$name" from PID $pid, payload was "$payload"\n}; > > } > > Not sure what you mean by adapting interfaces t

Re: [HACKERS] Listen/Notify payload and interfaces

2010-02-17 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > With the new listen/notify implementation we can send a payload along > with the notification. This has been in the protocol already since > years and there is no change needed for libpq. However we need to > adapt the various interfaces to al

[HACKERS] Listen/Notify payload and interfaces

2010-02-17 Thread Joachim Wieland
This one is for the maintainers of the various postgresql interfaces: With the new listen/notify implementation we can send a payload along with the notification. This has been in the protocol already since years and there is no change needed for libpq. However we need to adapt the various interfa