From: Zlatko Matić <zlatko.matic1@sb.t-com.hr>
To: pgsql-general@postgresql.org
To: pgsql-interfaces@postgresql.org
Subject: postgres temporary tables and MS Access
Date: Sun, 24 Jul 2005 14:09:31 +0200
Message-ID: <000b01c59048$8ce2dc50$b08a1dc3@zlatkovyfkpgz6> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: zlatko.matic1@sb.t-com.hr, pgsql-general@postgresql.org
Subject: Re: postgres temporary tables and MS Access
In-Reply-To: <000b01c59048$8ce2dc50$b08a1dc3@zlatkovyfkpgz6>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox