Re: signals in ODBC?

At 10:43 26/10/00 -0400, Tom Lane wrote:
>
>Not sure I see the point.  If there's to be a separate connection, you
>might as well just fire up a libpq connection.  Someone else already
>pointed out that you could use ODBC for your main data transfer, if you
>like ODBC, and use a second connection through libpq only to get
>notifications.

I hadn't realized libpq worked without Cygwin etc.


>AFAIK there's no fundamental reason that NOTIFY support couldn't be
>added to our ODBC driver, it's just that it would fall outside the
>ODBC API spec.  But then a second connection through libpq isn't ODBC
>compliant either.

I suspect that a libpq connection would be the go; there is no facility
that I am aware of in ODBC for async callbacks, which is what you'd want
for the NOTIFY stuff to work well.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/