Re: Checking for open connections using ECPG

Well Ingres has INQUIRE_SQL, Sybase has GET DIAGNOSTICS, ... These
seem to do something similiar to what we're talking about (and a whole
lot more too).

Best just using somethign else... Howabout:
GET CONNECTION [CONNECTIONNAME] INTO :var

?

Michael Meskes writes:> On Wed, Mar 06, 2002 at 02:20:05PM -0500, Jim Parker wrote:> > Is there anyway to check for
openconnections to a database using ECPG ?> > Well, you should be able to call ECPGget_connection(). However, it seems>
thefunction is not defined in the include files, so the prototype is:> > struct connection * ECPGget_connection(const
char*);> > But struct connection is an internal datatype that also is not defined> in any header file. So you have to
getthis from the sources of ecpglib.> > To be honest this is a hack. I think I will create a function that does>
exactlywhat you need. Any one out there with an idea how to call this> with an EXEC SQL syntax? > > Michael> -- >
MichaelMeskes> Michael@Fam-Meskes.De> Go SF 49ers! Go Rhein Fire!> Use Debian GNU/Linux! Use PostgreSQL!> >
---------------------------(endof broadcast)---------------------------> TIP 3: if posting/reading through Usenet,
pleasesend an appropriate> subscribe-nomail command to majordomo@postgresql.org so that your> message can get through
tothe mailing list cleanly