From: | Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | postgres temporary tables and MS Access |
Date: | 2005-07-24 12:09:31 |
Message-ID: | 000b01c59048$8ce2dc50$b08a1dc3@zlatkovyfkpgz6 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-07-24 12:11:56 | Re: \dt gives ERROR: did not find '}' at end of input node |
Previous Message | NTPT | 2005-07-24 11:50:38 | \dt gives ERROR: did not find '}' at end of input node |
From | Date | Subject | |
---|---|---|---|
Next Message | jing han | 2005-07-28 15:18:13 | about postgres performance issue |
Previous Message | Scott Cain | 2005-07-18 17:06:26 | DBD::PgSPI killing server connection |