From i.hasenoehrl@aon.at Wed Jun 6 17:53:26 2001 Received: from email02.aon.at (WARSL401PIP3.highway.telekom.at [195.3.96.75]) by postgresql.org (8.11.3/8.11.1) with SMTP id f56HrQE53914 for ; Wed, 6 Jun 2001 13:53:26 -0400 (EDT) (envelope-from i.hasenoehrl@aon.at) Received: (qmail 477430 invoked from network); 6 Jun 2001 17:53:24 -0000 Received: from n681p003.adsl.highway.telekom.at (HELO irina) ([62.47.29.3]) (envelope-sender ) by qmail2.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 6 Jun 2001 17:53:24 -0000 Message-ID: <00c701c0eeb1$a9e2a980$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: Subject: How to create a *pass-through-query* in postgresql Date: Wed, 6 Jun 2001 19:53:58 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C4_01C0EEC2.6D1F2E40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200106/75 X-Sequence-Number: 3294 This is a multi-part message in MIME format. ------=_NextPart_000_00C4_01C0EEC2.6D1F2E40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 Ms= Access. I want to develop a trigger, which updates or inserts rows in some local ta= bles in MsAccess on the client side. =20 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 t= o 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 clie= nts and to the host, because the connection is not very fast when client_1 changes a special table in the postgresql DB, this should b= e transmitted to a local MsAccess-table to client_2=20 Can I solve this problem with plpgsql???????????? Please, can anyone help me to solve this problem. Thanks in advance Irina =20 E-Mail: i.hasenoehrl@aon.at ------=_NextPart_000_00C4_01C0EEC2.6D1F2E40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello all,
 
I use postgresql as backend and MsAccess97= as=20 frontend via ODBC.
I know, how to use VBA and pass through qu= eries to=20 update or insert rows in postgresql-tables.
But I don't know, how to do this the other= way=20 round, from postgresql to MsAccess.
I want to develop a trigger, which updates= or=20 inserts rows in some local tables in MsAccess on the client=20 side.
 
How can I realize a *pass through query* i= n=20 postgresql ( with plpgsql ?) to be executed in MsAccess?
 
Is there a possibility, to send updates or= inserts=20 from postgresql-tables to local MsAccess-tables (without linked=20 tables)
 
I have the following situation:
1 postgresql database and some= clients=20 on different locations, connected via internet
I want to hold some information realy lo= cal (no=20 linked table) to the clients and to the host, because the connection is n= ot=20 very fast
when client_1 changes a special table in= the=20 postgresql DB, this should be transmitted to a local MsAccess-table to=20 client_2
Can I solve this problem with=20 plpgsql????????????
 
Please, can anyone help me to solve this= =20 problem.
 
Thanks in advance
Irina
 
E-Mail: i.hasenoehrl@aon.at
------=_NextPart_000_00C4_01C0EEC2.6D1F2E40-- From alex@pilosoft.com Wed Jun 6 18:41:03 2001 Received: from spider.pilosoft.com (p55-222.acedsl.com [160.79.55.222]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f56If3E73708 for ; Wed, 6 Jun 2001 14:41:03 -0400 (EDT) (envelope-from alex@pilosoft.com) Received: from localhost (alexmail@localhost) by spider.pilosoft.com (8.9.3/8.9.3) with ESMTP id OAA25958; Wed, 6 Jun 2001 14:50:14 -0400 (EDT) Date: Wed, 6 Jun 2001 14:50:14 -0400 (EDT) From: Alex Pilosov To: =?iso-8859-1?Q?DI_Hasen=F6hrl?= cc: pgsql-sql@postgresql.org Subject: Re: How to create a *pass-through-query* in postgresql In-Reply-To: <00c701c0eeb1$a9e2a980$01011eac@irina> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by postgresql.org id f56If5E73716 X-Archive-Number: 200106/78 X-Sequence-Number: 3297 No, you could not do that _easily_. You'd have to write some sort of a Postgres (C) wrapper against unix-to-odbc libraries, to be able to do something like that. Very nontrivial task. Also you may consider trying to use plperl and perl's DBD interface to a DBD-to-ODBC proxy running on windows. At either case, with current state of plperl it'll be a challenging thing... -alex On Wed, 6 Jun 2001, [iso-8859-1] DI Hasenöhrl wrote: > 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 > From dev@archonet.com Wed Jun 6 22:30:56 2001 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 From josh@agliodbs.com Wed Jun 6 23:12:10 2001 Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f56NCAE70995 for ; Wed, 6 Jun 2001 19:12:10 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 68259; Wed, 06 Jun 2001 16:12:06 -0700 From: "Josh Berkus" Subject: Re: How to create a *pass-through-query* in postgresql To: "Richard Huxton" , DI =?ISO-8859-1?Q?Hasen=F6hrl?= , X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Wed, 06 Jun 2001 16:12:06 -0700 Message-ID: In-Reply-To: <004a01c0eec7$6c522800$1001a8c0@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/84 X-Sequence-Number: 3303 D.I., > >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. 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. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco From dev@archonet.com Thu Jun 7 07:03:18 2001 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