Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5773DE42817 for ; Thu, 7 Jun 2001 03:03:18 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-34.mail.demon.net with esmtp (Exim 2.12 #1) id 157tpC-0001zZ-0Y; Thu, 7 Jun 2001 08:03:23 +0100 Received: from archonet.com (ibook.archonet.com [192.168.1.32]) by mainbox.archonet.com (Postfix) with ESMTP id A80F7132DB; Thu, 7 Jun 2001 07:39:06 +0100 (BST) Message-ID: <3B1F2112.C682CD33@archonet.com> Date: Thu, 07 Jun 2001 07:37:06 +0100 From: Richard Huxton X-Mailer: Mozilla 4.7C-CCK-MCD {C-UDP; EBM-APPLE} (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: Josh Berkus Cc: DI =?iso-8859-1?Q?Hasen=F6hrl?= , pgsql-sql@postgresql.org Subject: Re: How to create a *pass-through-query* in postgresql References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/94 X-Sequence-Number: 3313 Josh Berkus wrote: > > D.I., > > > >I want to develop a trigger, which updates or inserts rows in some > > local > > tables in >MsAccess on the client side. > > To be blunt, on top of Richard's objections, this sounds like really bad > database application design to me. What is it you're trying to > accomplish? Chances are, it would be a much better idea to simply > relocate those "local tables" to the server. Bad application design can equal good workaround for inadequate resources. I've done the same sort of thing myself, but never tried to manage "live" updates. What this looks like is an attempt to replicate one or more tables. The problem is, that's not going to be easy with ODBC as your connection. - Richard Huxton