Thomas Kellerer wrote:
Mark Morgan Lloyd schrieb am 25.09.2015 um 23:41:
I'm trying to get support for PostgreSQL's listen/notify into a
development environment, but since it supports multiple database
backends: can anybody comment on how many other servers have a
comparable facility?
Minimal r
Mark Morgan Lloyd schrieb am 25.09.2015 um 23:41:
I'm trying to get support for PostgreSQL's listen/notify into a
development environment, but since it supports multiple database
backends: can anybody comment on how many other servers have a
comparable facility?
Minimal research has allowed me t
I'm trying to get support for PostgreSQL's listen/notify into a
development environment, but since it supports multiple database
backends: can anybody comment on how many other servers have a
comparable facility?
Minimal research has allowed me to code something for
Firebird/Interbase, but I'
In early 2009 I asked whether there was a hack to allow PostgreSQL's
listen/notify commands via ODBC, some while later I believe that
somebody sent me example code encoded as base64 which erroneously got
deleted as spam.
Google suggests that several other people have asked about this over the
Thank you guys for your replies!
It is definitely something wrong with my code, here is the thread which does
the listening:
http://mitek.id.au/flex/DBListener.cpp
The rest of application is fairly big and does not relate to the database.
For libpq calls I am using the SPTK (http://sptk.net) libr
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org]on Behalf Of Dmitri Girski
Sent: Monday, 23 March 2009 10:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] LISTEN/NOTIFY problem
Hi everybody,
I've got a weird pr
Hi everybody,
I've got a weird problem with LISTEN/NOTIFY.
My C++ app subscribes for the notifications, just like in libpq examples:
http://www.postgresql.org/docs/8.3/static/libpq-example.html
The only difference, that I am setting the timeout on select just to check
if application wants to exit
John D. Burger schrieb:
Tom Lane wrote:
The standard approach when using libpq directly is to get the file
descriptor number of the backend connection with PQsocket(), then
include that in the set of FDs that the client app's idle loop
select()s or poll()s on.
And Tino Wildenhain, in off-list
Tom Lane wrote:
The standard approach when using libpq directly is to get the file
descriptor number of the backend connection with PQsocket(), then
include that in the set of FDs that the client app's idle loop
select()s or poll()s on.
And Tino Wildenhain, in off-list mail, described getting
"John D. Burger" <[EMAIL PROTECTED]> writes:
> Does anyone have any suggestions for how to write client python code
> that uses LISTEN? The only thing I can find is the older PyGreSQL
> module (import pg), which has getnotify(), but this seems to require
> busy-waiting. Is there any way to
Hi -
Does anyone have any suggestions for how to write client python code
that uses LISTEN? The only thing I can find is the older PyGreSQL
module (import pg), which has getnotify(), but this seems to require
busy-waiting. Is there any way to do this that will use select() or
something
On Fri, Dec 08, 2006 at 03:38:49PM +0100, Hannes Dorbath wrote:
> Is there a way I can have notifications to be streamed to the listener,
> so I don't need to poll with LISTEN?
>
> LISTEN foo;
> LISTEN
> NOTIFY foo;
> NOTIFY
> Asynchronous notification "foo" received from server process with PID
Is there a way I can have notifications to be streamed to the listener,
so I don't need to poll with LISTEN?
LISTEN foo;
LISTEN
NOTIFY foo;
NOTIFY
Asynchronous notification "foo" received from server process with PID 3593.
This does work for the same backend, but not for notifications issued
f
Thanks. I was thinking iirc was the transport
protocol :-)
Looks like dblink is the best bet here.
--Ted
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ted Shab wrote:
> > Richard,
> >
> > Thanks for the response.
> >
> > I'll look into both the dblink and iirc.
> >
> > Do you know of any
Ted Shab wrote:
Richard,
Thanks for the response.
I'll look into both the dblink and iirc.
Do you know of any extended examples of either?
dblink is in the contrib/ folder of the source distribution and possibly
your packaged version if you use such a thing. Never needed it myself,
but the doc
On Wed, Oct 13, 2004 at 08:32:04AM -0700, Ted Shab wrote:
> Thanks for the response.
>
> I'll look into both the dblink and iirc.
That's actually only dblink. IIRC is an acronym, meaning "if I recall
correctly", IIRC.
--
Alvaro Herrera ()
"The West won the world not by the superiority of it
Richard,
Thanks for the response.
I'll look into both the dblink and iirc.
Do you know of any extended examples of either?
--Ted
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ted Shab wrote:
> > Hi,
> >
> > I'm trying to come up with a relatively simple
> > multi-master replication soluti
Ted Shab wrote:
Hi,
I'm trying to come up with a relatively simple
multi-master replication solution. This is for
multiple databases that need to be discreet, and
change relatively infrequently (10-30 updates an
hour), and almost never update each others data (less
than once a day).
The TCL-bas
Hi,
I'm trying to come up with a relatively simple
multi-master replication solution. This is for
multiple databases that need to be discreet, and
change relatively infrequently (10-30 updates an
hour), and almost never update each others data (less
than once a day).
The TCL-based replication
On Wed, 12 May 2004, Glenn Sullivan wrote:
> Thanks for the response. I have been using Sun's JDBC.
> Do I take it that I need to create and use the Postgres
> JDBC to get the ability to do NOTIFY/LISTEN?
>
You have been using the JDBC API provided by Sun as a number of interfaces
(java.sql.
Kris,
Thanks for the response. I have been using Sun's JDBC.
Do I take it that I need to create and use the Postgres
JDBC to get the ability to do NOTIFY/LISTEN?
Glenn
Kris Jurka wrote:
On Tue, 11 May 2004, Glenn Sullivan wrote:
Hi,
I have been trying to get LISTEN/NOTIFY working in with JDBC
On Tue, 11 May 2004, Glenn Sullivan wrote:
> Hi,
>
> I have been trying to get LISTEN/NOTIFY working in with JDBC. I cannot seem
> to get notified. I looked in the e-mail archive and saw a lot of similiar
> questions a couple of years ago. I never could find any answers in the
> e-mail nor i
"Tomas B. Winkler" <[EMAIL PROTECTED]> writes:
> Could someone, please give me a little example on how to use listen/notify
> mechanism. Or at least point me to some more legible documentation.
> What I particulary need is that my frontend application is notified on
> update/insert in a table.
Ma
Hi
Could someone, please give me a little example on how to use listen/notify
mechanism. Or at least point me to some more legible documentation.
What I particulary need is that my frontend application is notified on
update/insert in a table.
Thanx a lot.
Tomas Winkler
The System Group
CSE HUJI
24 matches
Mail list logo
