X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 7750F52AA0;
	Sun, 24 Jul 2005 09:09:41 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 22892-03; Sun, 24 Jul 2005 12:09:33 +0000 (GMT)
Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97])
	by svr1.postgresql.org (Postfix) with ESMTP id 0D1E852A46;
	Sun, 24 Jul 2005 09:09:31 -0300 (ADT)
Received: from ls401.t-com.hr (ls401.t-com.hr [195.29.150.236])
	by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id j6OC9Xt8010008;
	Sun, 24 Jul 2005 14:09:33 +0200
Received: from ls401.t-com.hr (localhost.localdomain [127.0.0.1])
	by ls401.t-com.hr (Qmlai) with ESMTP id 761FA70003;
	Sun, 24 Jul 2005 14:09:33 +0200 (CEST)
Received: from zlatkovyfkpgz6 (ad10-m176.net.t-com.hr [195.29.138.176])
	by ls401.t-com.hr (Qmlai) with SMTP id 3FD10A806D;
	Sun, 24 Jul 2005 14:09:32 +0200 (CEST)
Message-ID: <000b01c59048$8ce2dc50$b08a1dc3@zlatkovyfkpgz6>
From: =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
To: <pgsql-general@postgresql.org>, <pgsql-interfaces@postgresql.org>
Subject: postgres temporary tables and MS Access
Date: Sun, 24 Jul 2005 14:09:31 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0008_01C59059.4F867C70"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.158 tagged_above=0 required=5 tests=AWL, HTML_50_60,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200507/954
X-Sequence-Number: 81052

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C59059.4F867C70
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

I tried to work with postgres temporary tables from MS Access, but =
unsuccessfully...
I was able to create temporary table by pass-through query, also I =
succeeded in creating linked table through code, but when I try to open =
it, an error apears and Access says there is no schema...
Also, I couldn't link table using ODBC wizard...
Can someone explain why I can't use temporary tables from MS Access ? =
Does it mean that every query execution is separate connection, so =
previously created temporary table no longer works for next queries ?
Has anybody used postgres temporary tables from MS Access ?

Thanks in advance,

Zlatko
------=_NextPart_000_0008_01C59059.4F867C70
Content-Type: text/html;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.2900.2668" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I tried to work with postgres temporary =
tables from=20
MS Access, but unsuccessfully...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I was able to create temporary table by =

pass-through query, also I succeeded in creating linked table through =
code, but=20
when I try to open it, an error apears and Access says there is no=20
schema...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Also, I couldn't link table using ODBC=20
wizard...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Can someone explain why I can't use =
temporary=20
tables from MS Access ? Does it mean that every query execution is =
separate=20
connection, so previously created temporary table no longer works for =
next=20
queries ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Has anybody used =
postgres&nbsp;temporary tables=20
from MS Access ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Zlatko</FONT></DIV></BODY></HTML>

------=_NextPart_000_0008_01C59059.4F867C70--