Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f56MUuE57387 for ; Wed, 6 Jun 2001 18:30:56 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 2.12 #1) id 157lq8-000NrU-0W; Wed, 6 Jun 2001 23:31:49 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 0D9D2132DB; Wed, 6 Jun 2001 21:29:46 +0100 (BST) Message-ID: <004a01c0eec7$6c522800$1001a8c0@archonet.com> From: "Richard Huxton" To: =?iso-8859-1?Q?DI_Hasen=F6hrl?= , References: <00c701c0eeb1$a9e2a980$01011eac@irina> Subject: Re: How to create a *pass-through-query* in postgresql Date: Wed, 6 Jun 2001 21:29:40 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/83 X-Sequence-Number: 3302 Please don't post html mail to mailing lists - it screws up quoting. From: "DI Hasenöhrl" 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