Received: from mailhub2.isdnet.net (mailhub2.isdnet.net [195.154.209.22]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA30044 for ; Fri, 2 Jun 2000 07:49:30 -0400 (EDT) (envelope-from nhuillard@ghs.fr) Received: from toulouse.int.ghs (ppp33-cergy.isdnet.net [194.149.184.160]) by mailhub2.isdnet.net (8.9.3/8.9.3) with SMTP id NAA27813; Fri, 2 Jun 2000 13:49:17 +0200 (CEST) Received: by toulouse.int.ghs with Microsoft Mail id <01BFCC99.A48E1220@toulouse.int.ghs>; Fri, 2 Jun 2000 13:51:25 +0200 Message-ID: <01BFCC99.A48E1220@toulouse.int.ghs> From: Nicolas Huillard To: "'Mihai Gheorghiu'" , "pgsql-interfaces@postgresql.org" Subject: RE: ODBC driver Date: Fri, 2 Jun 2000 12:12:31 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id HAB30046 X-Archive-Number: 200006/8 The best way to see how it works is to look at the query log in the postgres back-end. My bet is that Access will send select/where-clauses and so on to the back-end, for each table, and then do it's join locally, on the subset of the data. Maybe it can work even smarter... Nicolas Huillard -----Message d'origine----- De: Mihai Gheorghiu [SMTP:tanhq@bigplanet.com] Date: jeudi 1 juin 2000 23:49 À: pgsql-interfaces@postgresql.org Objet: ODBC driver A previous message mentioned that MSAccess performs a join locally when accessing a postgres database via the ODBC drivers (link files). Does that mean that it sends the entire tables from the postgres server to the Win computer and the query is actually performed by MSAccess? Thanks, Mihai Gheorghiu