postgres temporary tables and MS Access

Поиск
Список
Период
Сортировка
От Zlatko Matić
Тема postgres temporary tables and MS Access
Дата
Msg-id 000b01c59048$8ce2dc50$b08a1dc3@zlatkovyfkpgz6
обсуждение исходный текст
Список pgsql-general
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-general по дате отправления:

Предыдущее
От: "NTPT"
Дата:
Сообщение: \dt gives ERROR: did not find '}' at end of input node
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: \dt gives ERROR: did not find '}' at end of input node