X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C17CEDBDD1
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Nov 2005 12:34:13 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 35904-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Nov 2005 16:34:10 +0000 (GMT)
X-Greylist: delayed 02:02:16.586038 by SQLgrey-
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
	by svr1.postgresql.org (Postfix) with ESMTP id CC627D6822
	for <pgsql-sql@postgresql.org>; Fri, 25 Nov 2005 12:34:09 -0400 (AST)
Received: from smtp.imatech.net (smtp.imatech.net [81.255.215.253])
	by svr2.postgresql.org (Postfix) with ESMTP id 08A96F0BAC
	for <pgsql-sql@postgresql.org>; Fri, 25 Nov 2005 14:31:58 +0000 (GMT)
X-AuthUser: stephane.riff@cerene.fr
Received: from [200.200.200.185] ([195.6.193.141]:56006)
	by smtp.imatech.net ([81.255.215.226]:25) with [XMail 1.21 ESMTP
	Server] id <S7D62DD> for <pgsql-sql@postgresql.org> from
	<stephane.riff@cerene.fr>; Fri, 25 Nov 2005 15:31:50 +0100
Message-ID: <4387204F.1080308@cerene.fr>
Date: Fri, 25 Nov 2005 15:31:43 +0100
From: =?ISO-8859-1?Q?St=E9phane_RIFF?= <stephane.riff@cerene.fr>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7.5) Gecko/20041217
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: LISTEN/NOTIFY
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.291 required=5 tests=[AWL=0.291]
X-Spam-Score: 0.291
X-Spam-Level: 
X-Archive-Number: 200511/243
X-Sequence-Number: 23494

Hi all,

I just saw in the documentation the LISTEN/NOTIFY commands but i don't 
understand how i can use them.

Can someone show me an example in PLPGSQL that use this system ?

=> A process send a NOTIFY command and a LISTEN process execute his own 
commands.

Hope this clear, thanks
Steff