Skip site navigation (1) Skip section navigation (2)

postgres temporary tables and MS Access

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-interfaces by date

Next:From: jing hanDate: 2005-07-28 15:18:13
Subject: about postgres performance issue
Previous:From: Scott CainDate: 2005-07-18 17:06:26
Subject: DBD::PgSPI killing server connection

pgsql-general by date

Next:From: Michael FuhrDate: 2005-07-24 12:11:56
Subject: Re: \dt gives ERROR: did not find '}' at end of input node
Previous:From: NTPTDate: 2005-07-24 11:50:38
Subject: \dt gives ERROR: did not find '}' at end of input node

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group