Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7ADCC633574 for ; Wed, 17 Feb 2010 04:40:06 -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 18193-03 for ; Wed, 17 Feb 2010 08:39:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.155]) by mail.postgresql.org (Postfix) with ESMTP id 2E7EE632E6E for ; Wed, 17 Feb 2010 04:39:20 -0400 (AST) Received: by fg-out-1718.google.com with SMTP id 22so115011fge.1 for ; Wed, 17 Feb 2010 00:39:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:date :x-google-sender-auth:message-id:subject:from:to:content-type; bh=M2J8JfUKInnf8oPhjvHM30Uh9LACVttILp6IgM8Jwd8=; b=OHH4UDvD/6qY0PodFn5UABT7SZUyvY1NMFndTTxRy2m++/YjnxTWU/HLO4cr0l8EXC 5UrWRyV7bk4cix/VLlXOKA9Szie5PxM0D9FpXhR98n4rJT0PQ/nQN96sSRWNp3yWNl9J UQELC249/aGEKasS02CcMQxRNDe1SraoQi7JU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=QlWbauZ1X6Z9bve1KXt25W5iHtr3ebESiFMYR5uNg2UuMUtTxeROACXZnScIMjiKsx zXGDkb/Uyz1muGb5PCGsE87J2fRqZaeFRCkpDMWpD3GRl6L0LKL3aM7Q34i/OUrULcqd 1sK9GWC7173oS0GIy0vVRyoN6+IRiUDzC4kJU= MIME-Version: 1.0 Received: by 10.239.190.19 with SMTP id v19mr837301hbh.171.1266395958990; Wed, 17 Feb 2010 00:39:18 -0800 (PST) Date: Wed, 17 Feb 2010 09:39:18 +0100 X-Google-Sender-Auth: 3f0c40e2afb932bc Message-ID: Subject: Listen/Notify payload and interfaces From: Joachim Wieland To: pgsql-hackers Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.454 tagged_above=-10 required=5 tests=AWL=0.145, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/1428 X-Sequence-Number: 157771 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 interfaces to allow a payload to be sent and received. A notification is sent via SQL: http://developer.postgresql.org/pgdocs/postgres/sql-notify.html and received via the libpq call PQnotifies: http://developer.postgresql.org/pgdocs/postgres/libpq-notify.html Joachim