Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Listen/Notify payload and interfaces

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [HACKERS] Listen/Notify payload and interfaces
Date: 2010-02-17 20:50:12
Message-ID: 7A380D88-3DBB-40DC-9FC5-21DA3CE6759A@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
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 to send payloads, I imagine 
> 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


In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2010-02-17 21:42:35
Subject: Re: Large object dumps vs older pg_restore
Previous:From: Heikki LinnakangasDate: 2010-02-17 20:28:59
Subject: Re: Streaming replication on win32, still broken

pgsql-interfaces by date

Next:From: Greg Sabino MullaneDate: 2010-02-18 21:01:29
Subject: Re: [HACKERS] Listen/Notify payload and interfaces
Previous:From: Greg Sabino MullaneDate: 2010-02-17 18:04:14
Subject: Re: [HACKERS] Listen/Notify payload and interfaces

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group