pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: DI Hasenöhrl <i.hasenoehrl@aon.at>
To: pgsql-sql@postgresql.org
Subject: How to create a *pass-through-query* in postgresql
Date: Wed, 6 Jun 2001 19:53:58 +0200
Message-ID: <00c701c0eeb1$a9e2a980$01011eac@irina> (raw)

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.
 
How can I realize a *pass through query* in postgresql ( with plpgsql ?) to be executed in MsAccess?

Is there a possibility, to send updates or inserts from postgresql-tables to local MsAccess-tables (without linked tables)

I have the following situation:
  1 postgresql database and some clients on different locations, connected via internet
  I want to hold some information realy local (no linked table) to the clients and to the host, because the connection is not very fast
  when client_1 changes a special table in the postgresql DB, this should be transmitted to a local MsAccess-table to client_2 
Can I solve this problem with plpgsql????????????

Please, can anyone help me to solve this problem.

Thanks in advance
Irina
 
E-Mail: i.hasenoehrl@aon.at

view thread (5+ messages)  latest in thread

Message-ID: <00c701c0eeb1$a9e2a980$01011eac@irina>
Permalink:  ../00c701c0eeb1$a9e2a980$01011eac@irina/
Also on:    postgresql.org/message-id/00c701c0eeb1$a9e2a980$01011eac@irina

 · 

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: i.hasenoehrl@aon.at
  Subject: Re: How to create a *pass-through-query* in postgresql
  In-Reply-To: <00c701c0eeb1$a9e2a980$01011eac@irina>

* 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