From: Richard Huxton <dev@archonet.com>
To: DI Hasenöhrl <i.hasenoehrl@aon.at>
To: pgsql-sql@postgresql.org
Subject: Re: How to create a *pass-through-query* in postgresql
Date: Wed, 6 Jun 2001 21:29:40 +0100
Message-ID: <004a01c0eec7$6c522800$1001a8c0@archonet.com> (raw)
References: <00c701c0eeb1$a9e2a980$01011eac@irina>
Please don't post html mail to mailing lists - it screws up quoting.
From: "DI Hasenöhrl" <i.hasenoehrl@aon.at>
Hello all,
>I use postgresql as backend and MsAccess97 as frontend via ODBC.
>I know, how to use VBA and pass through queries to update or insert rows in
postgresql->tables.
>But I don't know, how to do this the other way round, from postgresql to
MsAccess.
>I want to develop a trigger, which updates or inserts rows in some local
tables in >MsAccess on the client side.
Don't think you can do this via ODBC. You can listen for NOTIFY signals with
a real PostgreSQL client, but I wouldn't think ODBC would support this. I
can only think of two ways to approach this:
Have a "change" table and update a timestamp in it whenever a target table
is updated. Then clients can poll once a minute or whatever and see if their
local timestamp is older than the one in the change table.
Or - rig some out-of-band communication. Have a perl script listen for
NOTIFY on the server and signal that to the clients (or just synchronise the
client tables via ODBC).
- Richard Huxton
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-sql@postgresql.org
Cc: dev@archonet.com, i.hasenoehrl@aon.at
Subject: Re: How to create a *pass-through-query* in postgresql
In-Reply-To: <004a01c0eec7$6c522800$1001a8c0@archonet.com>
* 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