Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D345E63352F; Wed, 17 Feb 2010 16:50:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 78296-08; Wed, 17 Feb 2010 20:50:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.kineticode.com (host-201.commandprompt.net [207.173.203.201]) by mail.postgresql.org (Postfix) with ESMTP id C92166334BB; Wed, 17 Feb 2010 16:50:14 -0400 (AST) Received: from [10.0.1.4] (c-24-21-193-250.hsd1.or.comcast.net [24.21.193.250]) by smtp.kineticode.com (Postfix) with ESMTPSA id 6C928508054; Wed, 17 Feb 2010 12:43:38 -0800 (PST) Subject: Re: [HACKERS] Listen/Notify payload and interfaces Mime-Version: 1.0 (Apple Message framework v1077) Content-Type: text/plain; charset=us-ascii From: "David E. Wheeler" In-Reply-To: <06fb833dde8748d07bb996c39d221bd8@biglumber.com> Date: Wed, 17 Feb 2010 12:50:12 -0800 Cc: pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <7A380D88-3DBB-40DC-9FC5-21DA3CE6759A@kineticode.com> References: <06fb833dde8748d07bb996c39d221bd8@biglumber.com> To: Greg Sabino Mullane X-Mailer: Apple Mail (2.1077) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.079 tagged_above=-10 required=5 tests=AWL=-1.080, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201002/4 X-Sequence-Number: 6899 On Feb 17, 2010, at 10:04 AM, Greg Sabino Mullane wrote: > while (my $notify =3D $dbh->pg_notifies) { > my ($name, $pid, $payload) =3D @$notify; > print qq{I received notice "$name" from PID $pid, payload was = "$payload"\n}; =20 > } >=20 > Not sure what you mean by adapting interfaces to send payloads, I = imagine=20 > most if not all simply require a NOTIFY to be sent via PQexec. Is the payload decoded to utf8 when pg_enable_utf8 is true? Best, David