Re: NOTIFY/LISTEN Using Embedded SQL (ecpg) - Mailing list pgsql-general

From Tom Lane
Subject Re: NOTIFY/LISTEN Using Embedded SQL (ecpg)
Date
Msg-id 16561.990645944@sss.pgh.pa.us
Whole thread Raw
In response to NOTIFY/LISTEN Using Embedded SQL (ecpg)  ("Craig Orsinger" <cjorsinger@m5.earthlink_net.invalid>)
List pgsql-general
"Craig Orsinger" <cjorsinger@m5.earthlink_net.invalid> writes:
>      So, it appears that I can set up my program to LISTEN or
> UNLISTEN using embedded SQL, but I can't get a notification when
> it's sent. Or so I think. _Is_ there a way to get the libpq connection info
> from the ESQL CONNECT call?

Seems like there should be, if there isn't.  NOTIFY isn't the only thing
you might want to grab the PGconn object for.

            regards, tom lane

pgsql-general by date:

Previous
From: Robert
Date:
Subject: Sessions with Postgres
Next
From: Tom Lane
Date:
Subject: Re: incomplete transaction keeps table locked?