From: Tom Lane <tgl@sss.pgh.pa.us>
To: Philip Warner <pjw@rhyme.com.au>
Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: signals in ODBC?
Date: Thu, 26 Oct 2000 10:43:00 -0400
Message-ID: <5580.972571380@sss.pgh.pa.us> (raw)
In-Reply-To: <3.0.5.32.20001027010536.03c06c00@mail.rhyme.com.au>
References: <39F6F11D.79C5800B@alumni.caltech.edu>
<Pine.LNX.4.05.10010251411460.30412-100000@pc10.radnoti-szeged.sulinet.hu>
<39F6F11D.79C5800B@alumni.caltech.edu>
<3.0.5.32.20001027010536.03c06c00@mail.rhyme.com.au>
Philip Warner <pjw@rhyme.com.au> writes:
> ODBC 1 & 2 don't. I doubt 3 does either. What would be really kind of nice
> is if we had:
> LISTEN <name> [<port>]
> which would send notifications to the specified port on the client machine.
> Then with a small amount of effort, ODBC users could take advantage of
> notifications. Does this sound easy/hard and worthwhile?
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.
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.
My vote would be to spend time updating the driver, rather than adding
a wart onto the backend's LISTEN support.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, pjw@rhyme.com.au, lockhart@alumni.caltech.edu, tip@pc10.radnoti-szeged.sulinet.hu
Subject: Re: signals in ODBC?
In-Reply-To: <5580.972571380@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox