pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (5+ messages)  latest in thread

Message-ID: <004a01c0eec7$6c522800$1001a8c0@archonet.com>
Permalink:  ../004a01c0eec7$6c522800$1001a8c0@archonet.com/
Also on:    postgresql.org/message-id/004a01c0eec7$6c522800$1001a8c0@archonet.com

 · 

reply

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