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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: When using temporary tables, Excel do not refresh data



J6M wrote:
Hi,

I run in a bit of trouble with configuring psqlODBC that I use to retrieve
data from a PG box to Excel sheets. On my PC, queries with multiple
statements using temporary tables just work fine. On the other computers of
our school, such queries do execute without apparent errors (ps axuw | grep postgres) but data are not refreshed when returned.

E.g.

select now();  works OK on all computers

but

select now() into temp table t; select * from t;  works only on mine.

Could you send me directly the Mylog output of the other computers ?

regards,
Hiroshi Inoue



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group